September 16, 2010 at 3:43 am
I am running XP Professional aned I have just reinstalled MSSQL server 2005 and want to create a linked server. In Microsoft SQL Server Management Studio, I go to server object -> linked servers -> providers and it is empty. If I right click and go new linked server the next error is returned:
"
Cannot show requested dialog.
===================================
Cannot find table 0. (System.Data)
Please help.
September 16, 2010 at 3:46 am
which version of sql you installed?
----------
Ashish
September 16, 2010 at 4:41 am
Do you see any error messages in SQL Server Error Log\ Event Log?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 16, 2010 at 7:54 am
I installed both Sql Server 2000 and Sql erver 2005.I did not get any error log.
September 16, 2010 at 7:57 am
interested to know about edition of sql server.
----------
Ashish
September 16, 2010 at 8:01 am
Sounds like the account you're running SQL or SSMS under doesn't have appropriate permissions.
Out of curiosity, if you change SQL to run as a local administrator account, does it work?
September 16, 2010 at 11:00 pm
I tried to run as a local administrator account that time also Providers were not displaying in sql.
September 16, 2010 at 11:47 pm
Check if the SQL Server service account has privileges to the following registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Providers
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply