Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Linked Server

Author  Topic  remi Starting Member 1 Post Posted - 2011-03-19 : 10:10:10 Hi, I am trying to create a link to a database in sql server 2000 as below. EXEC sp_addlinkedserver @server=N'temp', (actual server name is 172.16.11.102) @srvproduct=N'', @provider=N'SQL Server', @datasrc=N'test'; I created datasource from administrative tools->Data Sources(ODBC) But it gave an error as below The OLE DB provider "SQL Server" has not been registered. Please help