I need to link a SQL 7.0 server on NT4.0 (server A) to SQL Server 2000 on Windows 2003 (server B). The servers are on seperate domains (although there is a 2 way trust).
When linking to the server B as "sa" I get "Error 17: SQL Server does not exist or access is denied.". sa account is fine - I can connect via QA.
I'm using Named Pipes, TCP/IP and multiprotocol on both.
I have several servers of similar configuration and all provide the same results. I can link server A to another server of a similar configuration to that of Server A, infact I can also link it to a SQL 2000 server running on NT4.0
Has anyone come across this scenario?