I'm using Windows Server 2003 R2 and SQL Server 2000 and I'm attempting to connect to to my database from another PC in the same Network (Also using Win Server 2003 R2) But I'm getting SQLSTATE[28000] SQLDriverConnect: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]
It says it not on a Trusted Connection.
I read in the Microsfot Docs that this error ONLY occurs when using Windows Authentication Only, BUT I'm currently using Mixed Authentication.
I'm using PHP PDO to connect this is my connection string:
$conn = new PDO("odbc:Driver={SQL Server};Server=MyServer;Database=MyDB","sa","pass");
This connection string currently works with SQL SERVER 7, But it doesn't with SQL SERVER 2000. Do You know any workarounds? or maybe... How to created a Trusted Connection?
You need to add ";Integrated Security=SSPI" or ";Trusted_Connection=Yes" - I forget which one. SSPI relates to "just use the current user", whereas the other is "it is a domain - use the following user and password"