Error 18452

[NuJoizey]

When trying to set up a linked server from sql2000 running on win2000 server to sql2005 running on win2003 server I keep getting the ever so lovely:

Msg 18452 Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

i gave up on trying to get windows authentication to work between the two servers, so I'm going with local db logins. Both servers are running in mixed mode. Both servers are set up to allow remote connections. - I configured a login to the 2005 machine called 'test' and made 'test' a user in my desired datastore. That didn't work. So then I used the sa account because none of the logins i created worked. That didn't work either so then what the heck else is there to check?

I do have a successful linked server connection running from the sql2005 machine to the sql2000 machine, so i just duplicated the procudure that I use to set that up in reverse, thinking it would work fine, but it didn't. How else do i troubleshoot this thing?

 

[ptheriault]

Are the servers on the same domain?
try to telnet to the server ip port 1433.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[NuJoizey]

yup. nothing finicky going on there.

 

[NuJoizey]

whoops - saw your telnet suggestion just now - the aswer is that i can't seem to telnet, it just hangs on "connecting to myServer..."

but maybe telnet is disabled - have to find that out from the server admin. Telnet doesn't seem to work even from a machine that has a working connection though.