Set up a linked server to a SQL2000

[seaport]

I am trying to set up a linked server to a 32-bit SQL2000 server on a 64-bit SQL 2008R2 server. On that 2008 Server, a linked server to another 32-bit SQL2000 server has been set up by someone else and it works fine.

I used the following script to create the linked server.

EXEC master.dbo.sp_addlinkedserver @server = N'SQL2000A', @srvproduct=N'MSOLEDB', @provider=N'MSDASQL', 
@datasrc=N'SQL2000A';

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'SQL2000A',
@useself=N'False',@locallogin=NULL,@rmtuser=N'SQL2000Auser',@rmtpassword='SQL2000APw'

When I tried to access this linked server, I got the error

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SQL2000A". (Microsoft SQL Server, Error: 7303)

I have installed SQL2000 SP4 on the SQL2000A server successfully. I could not see any differences between this one and the other 2000 server. I checked "ODBC Drivers" on both sever using "ODBC Data Source Administrator" and the listed drivers are the same.

Any suggestions?

 

[seaport]

I figured it out. I needed to set up an system dsn on the SQL2008 server.