Re: SQL2005 security

Gilbert
Take a loot at BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/508c686d-2bd4-41ba-8602-48ebca266659.htm





"Gilbert" <Gilbert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C9F348B4-FBB1-453D-9A2E-F4A897F442E3@xxxxxxxxxxxxxxxx
Thanks for the reply.

I am using backward compatability feature for SQL2005 which includes
SQLDMO,
it works fine except that all the security calls to SQL2005 instance fail.
If
you can point me in some direction whether if SQL2005 needs to be
configured
for user rights etc.

Any help is appreciated.


"Uri Dimant" wrote:

Gibert
I have not played personally with it on SQL Server 2005 , however , you
may
want to look at SMO object library which replaced SQLDMO




"Gilbert" <Gilbert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:25E4C87D-23BA-4C9E-95B4-559EF75FA743@xxxxxxxxxxxxxxxx
Hi,

I am trying to call an SQLDMO method GetImpersonateClient on SQL2005
server
instance, which fails the HRESULT code is 0x80045310(unknown error).

SQL 2005 is configured as follows:
*xp_cmdshell extended store procedure is enabled
*account is BUILTIN\Administrators on SQL2005 and Adminstrator on the
local
machine.

The same call to GetImpersonateClient works fine on SQL2000 instance.
Can
any one help?

TIA





.