SQL Server 2005 - SQL Server does not exist or access denied.
I am attempting to relocate our SQL Server 2005 to a different host. The old host/instance was server\traverse105. The new host/instance is traverse\traverse105.
Local use on the actual server 'traverse' works fine. However, attempting to connect from a Windows 7 client gives me the message, "SQL Server does not exist or access denied." I am attempting the connection with a specific login ID, not a "Trusted Connection" (although that gives me the same error).
I've checked the SQL Server Configuration Manager > Protocols for TRAVERSE105 and the IPAll is set to port 1433; named pipes is enabled and set to \\.\pipe\MSSQL$TRAVERSE105\sql\query
I can connect from a Linux host to port 1433 and the same user ID I specified in the Windows 7 client and can connect just fine, so I don't think it's a port or firewall issue.
This same Windows 7 client connected to the other server, SERVER, without problem. If I switch back to "SERVER/TRAVERSE105" it connects OK. I can see no Config Mgr difference between the Config Mgr settings on host TRAVERSE and host SERVER.
Need ideas on what's wrong!
Microsoft SQL Server 2005
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.