Jump to content


Photo

connect to MSSQL server 2005 express and authentication


  • Please log in to reply
1 reply to this topic

#1 xrado

xrado
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 08 October 2006 - 05:30 PM

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","","");
?>



#2 MCP

MCP
  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts

Posted 15 October 2006 - 05:00 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users