note 96134 added to function.mssql-connect

From: Date: Wed, 10 Feb 2010 16:10:39 +0000
Subject: note 96134 added to function.mssql-connect
Groups: php.notes 
Request: Send a blank email to php-notes+get-165833@lists.php.net to get a copy of this message
When you try to connect to SQL Server 2008 Express, you always have to name the instance you are trying to connect to, even if you installed SQL2008express as "Default" instance instead of named instance. If your instance is SQLExpress and server name is myServer, the server parameter must be: "myServer\SQLExpress". If you installed Default instance of Standard (not express) version of SQL2008 instead, you don't need to name the instance. To connect using TCP/IP, you need also to check server network configuration, enable TCP/IP (listen all: yes), then go to addresses tab and setup port 1433 in all addresses you want the server listen on (by default, port is blank and server don't listen). Libraries involved in TCP/IP are ntwdblib.dll and dbnetlib.dll. Have fun! ---- Server IP: 69.147.83.197 Probable Submitter: 217.133.19.226 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- https://master.php.net/note/edit/96134 Del: integrated -- https://master.php.net/note/delete/96134/integrated Del: useless -- https://master.php.net/note/delete/96134/useless Del: bad code -- https://master.php.net/note/delete/96134/bad+code Del: spam -- https://master.php.net/note/delete/96134/spam Del: non-english -- https://master.php.net/note/delete/96134/non-english Del: in docs -- https://master.php.net/note/delete/96134/in+docs Del: other reasons-- https://master.php.net/note/delete/96134 Reject -- https://master.php.net/note/reject/96134 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#165833) next »