[SOLVED] Connection to MsSQL Server

[RossM]

Hi People,

 

This problem is doing my nut! I am trying to get a connect to my MsSQL server however it keeps erroring.

 

I ahve tried the code:

<?php
function customError($errno, $errstr)
{
        echo "<b>Error:</b> [$errno] $errstr";
}

set_error_handler("customError");
mssql_connect("sqlserver", "username", "password");
?>

 

But says [2] mssql_connect() [function.mssql-connect]: Unable to connect to server: sqlserver

 

Anyone have any ideas?

[rhodesa]

is the server running on the same system or a remote system? if it's local, use 'localhost' for host or if it's remote, use the full hostname (aka sqlserver.yourdomain.com) or the IP address of the sql server

[corbin]

You might also have to specify the instance name depending on the configuration of the server.

 

 

 

For example:

 

localhost\INSTACE1

[RossM]

Hi,

 

Thanks for the replies.

 

The sql server is on a remote machine within the same network. I tried [servername], [servername].domain.com and the ip address of the server and still says cannot connect.

 

The sql server doesn't have an instance name. Any other suggestions?

 

Thanks,

Ross

[RossM]

Figured it out. For future reference, this is how I did it:

 

- Download the newest version of ntwdblib.DLL (version 2000.80.194.0 or greater to connect to SQL 2003 or higher)

- In the php.ini file, make sure mssql.secure_connection is off if you want to use sql authentication

- Reboot the server

- Done!