Using sp_addlinkedserver but getting invalid connectoin

[bmacbmac]

Hi!

I am trying to access data from another server on my domain. Both servers are running SQL 2000.

On the first server I ran:

exec sp_addlinkedserver
@server='SERVER1',
@srvproduct='SQL SERVER'

It appears to have created ok. Now I am trying to run:

select * from SERVER1.myDataBase.Dbo.myTable

and getting an 'Invalid Connection' error.

Do I need to add something to my linkedserver script? Like maybe a username/password or something?

 

[SQLBill]

Try:

select * from \\SERVER1.myDataBase.Dbo.myTable

Also, check Server1 to see if the error log shows any related errors.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875