MSSQL Connection Help. Can't connect to server.

[paulferree]

I'm getting a "Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: " message.  And I'm having a hard time trying to find a concise explanation on how to make the PHP MSSQL connection.

 

Im on windows server 2008.  The mssql line is uncommented in the ini file.  Whats next?  Do I need to install that Freetds stuff?

 

Thanks!

Paul

[pkedpker]

mssql_connect() will only work if you uncomment the

 

extension for php_mssql.dll  in php.ini

 

is how you connect

$mssql_connect = ("localhost", "username", "password");

$msdb = mssql_select_db("databasename", $msconnect);

 

But I ran a private server of a stolen game a while that used mssql and I didn't allow any remote connections nor did I have any username / passwords I just used standard windows authentication.

 

which means you connect like this

 

$msconnect = mssql_connect("YourIPgoesHere");

$msdb = mssql_select_db("DatabaseName", $msconnect);

 

simple as that.

[paulferree]

That didn't seem to work. I think I'm missing some configuration before that point.

 

What do I need to ensure is in place to get PHP and MSSQL working besides the initial uncommenting of the mssql line in the ini file?

 

Thanks,

Paul