Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Server Connectivity Failing

Author  Topic 

Phydeauxman
Starting Member

1 Post

Posted - 2010-05-21 : 09:00:40
I have a named instance of SQL 2005 running on a Windows 2008 server using port 1433. The server is configured for Mixed Mode authentication. I am trying to connect to it using an ODBC connection from a Windows 2003 SP2 server and I keep getting an error stating "Login failed for user ". The user is not associated with a trusted SQL Server connection". The Windows 2003 server is on the same subnet as the SQL server. The odd thing is I can connect to the SQL server from another Windows 2003 SP2 server on another subnet AND from the Windows 2003 SP2 server that is failing, I can connect to another SQL server on another subnet.
   

- Advertisement -