We have a few servers running ms sql 2000 and one server that runs ms sql 2005
I have created multiple linked servers from one ms sql2000 server to another and they have worked fine
I am trying to create a linked server from ms sql 2000 to ms sql 2005 but I keep getting the dreaded sql server does not exist or access denied. I have checked with the network team and they have assured me it is not a firewall issue. I am using the sa login and password as connection info. I know it is correct because I can connect if I use sql 2005 management studio
In the past I have added the linked sql server by using enterprise manager and clicking on sql server for server type.....is there a different method for sql server 2005.
I've seen examples for sp_addlinkedserver but that results in the same access denied issues.
If someone could provide an actual example using the folllowing info:
host sql server 2000 name: web02
sql server 2005 name: auditsql
sa login id: sa
sa password :sapassword (note this is not the real password but just for demo purposes)
This seems like it should be so simple and it is driving me nuts!!!!
Start Free Trial
