October 20, 2006 at 1:55 pm
Run a Profiler trace on the server being linked to. Make sure you add in Audit Login Failure as an event. Try to use the linked server connection. If you don't see the audit failure, there's a communications issue. If you do, perhaps the account you are using doesn't have the appropriate rights to login (whether you've mapped it or told it to use existing credentials).
K. Brian Kelley
@kbriankelley
October 20, 2006 at 2:06 pm
Well, I can register it, use query analyzer, and even connect via ODBC, but it won't add as a linked server, so it's not a connection issue (unless the port for linked servers is different than 1433 in which case I'll have to open it in the firewall). I even tried to connect linked server using several credentials including the sa account and it still doesn't work. If I can view the objects in EM, use Query Analyzer, and connect via ODBC, linked servers shouldn't be a problem, unless there's a different connection property that i'm not aware of. BTW, I have other servers registered as linked with no problem, so the issue appears to be with the remote server...?
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply