Re: SQL2005 security



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


.