please help me I'm desperate!!
I have installed PHP version 5.2 - fine
I have SQL Server 2008 - fine
Operating system is Windows Server 2008
I ran PHP Info and it shows SQL Server loaded as an extension - fine
correct DLL's installed including the one that needs to be placed in the windows folder.
I am connecting from a standard database connection script (see below) and it keeps coming back as Couldn't connect to server
it pauses for a few moments as if it were trying to connect and then spits back the message. If I keep trying it will actually lock the user account in SQL Server and I will have to log in to SQL Server unlock it.
This seems as if it is trying to connect but the password is wrong but this cant be..... AND if I log in with the same user name and password into SQL Server that I use in my database connection script, it logs in fine.
What have I missed? it doesn't make sense why it wont connect!!!
The connection script:
$dbhost = 'localhost';
$dbusername = 'theusername';
$dbpasswd = 'thepassword';
$database_name = 'mydatabasename';
$connection = mssql_pconnect("$dbhost","$dbusername","$dbpasswd" )
or die ("Couldn't connect to server.");
$db = mssql_select_db("$database_name", $connection)
or die("Couldn't select database.");
