Jump to content

Archived

This topic is now archived and is closed to further replies.

xrado

connect to MSSQL server 2005 express and authentication

Recommended Posts

i'd like to connect from remote host to MSSQL server 2005 express.
MSSQL uses windows authentication and path to database table looks like this:
ACER-TM4104\SQLEXPRESS\Databases\authors

ACER-TM4104 is computer name and it has ip 192.168.1.4.

i dont know about password...where do i set it?

i tried a few variants with connection below but every one : PHP Warning:  mssql_connect(): Unable to connect to server
<?
  $link=mssql_connect("192.168.1.4\SQLEXPRESS","","");
?>

Share this post


Link to post
Share on other sites
I don't use this method myself, but you have to set mssql.secure_connection = On in the php.ini file.

Or, you can turn on mixed mode authentication in SQL Server, and then go the username/password method.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.