title: Cannot connect to SQL SERVER 2000 with php
body: <blockquote>
  <p><strong>Possible Duplicate:</strong><br />
  <a href="https://stackoverflow.com/questions/13467286/cannot-connect-to-sql-server-2000">Cannot connect to SQL SERVER 2000</a></p>
  </blockquote>
  
  <p>I am using php 5.3.1 to connect to my SQL SERVER 2000 on remote machine. I use Windows XP.
  On using simple program like this:</p>
  <pre><code>$conn = mssql_connect(&quot;VBNET&quot;,&quot;sa&quot;,&quot;anythinghere&quot;) or die ( 'Can not connect to server' );
  </code></pre>
  <p>I get following error:</p>
  <blockquote>
  <p>Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in C:\wamp\www\Mssql\test.php on line 8</p>
  <p>Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: VBNET in C:\wamp\www\Mssql\test.php on line 8
  Can not connect to server</p>
  </blockquote>
  <p>I enabled TCP/IP and named pipes in my SQL SERVER and restarted it. Also its Authentication is set to Mixed Mode Authentication. So what am I missing here ?</p>
  <p>Thanks in advance.</p>
  <p><em><strong>EDIT</strong></em> This question was first about SQL SERVER 2008 but later it was brought to my knowledge that it was SQL SERVER 2000. Forgive me for my ignorance but the problem still exists. So please give me suggestions.</p>