Re: PHP connecting to MSSQL

Baboucarr Sanneh wrote:

okay try including the port number for the mssql server (I.e 1433) in the connection string..that also can be the problem somethimes and Sasha Meyer said: just a guess, are you using any kind of firewall (application or port based) > on your computer? Could you try a "telnet localhost 1433" to check if this > > works?

Regarding php.ini changes: have you restarted the web server's services > > after changing?

Yes I have restarted the needed processes. I have now attempted testing with firewall on, with firewall turned off, with firewall on but exception made for port 1433 and a number of others but in all cases it failed with the following results. Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Alf Stockton>telnet localhost 1433 Connecting To localhost...Could not open connection to the host, on port 1433: C onnect failed C:\Documents and Settings\Alf Stockton>telnet localhost 1433 Connecting To localhost...Could not open connection to the host, on port 1433: Connect failed C:\Documents and Settings\Alf Stockton>telnet localhost 1433 Connecting To localhost...Could not open connection to the host, on port 1433: Connect failed C:\Documents and Settings\Alf Stockton>telnet localhost 1433 Connecting To localhost...Could not open connection to the host, on port 1433: Connect failed C:\Documents and Settings\Alf Stockton>telnet localhost 1433 Connecting To localhost...Could not open connection to the host, on port 1433: Connect failed BTW How can I reinstall MSSQL without loosing existing databases? -- Regards, Alf Stockton www.stockton.co.za Your boss is a few sandwiches short of a picnic.