xrado Posted October 8, 2006 Share Posted October 8, 2006 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\authorsACER-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","","");?> Quote Link to comment https://forums.phpfreaks.com/topic/23365-connect-to-mssql-server-2005-express-and-authentication/ Share on other sites More sharing options...
MCP Posted October 15, 2006 Share Posted October 15, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/23365-connect-to-mssql-server-2005-express-and-authentication/#findComment-108958 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.