Jump to content


connect to MSSQL server 2005 express and authentication

  • Please log in to reply
1 reply to this topic

#1 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 is computer name and it has ip

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

#2 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