Posted by xchong.zhou@gmail.com on 11/23/05 03:33

EXEC xp_regwrite 'HKEY_LOCAL_MACHINE',
'Software\Microsoft\MSSQLServer\Providers\SQLOLEDB',
'DisallowAdhocAccess', 'REG_DWORD', 0

I ran the script above,the problem solved,Thank you very much.

• Next in forum: SQL backup - dun understand
• Prev in forum: Re: SQL Query Help
• Thread view: Re: There is a question when i work on Linkedserver~Pls kindly help me:)

[Reply to this message]