note 96134 added to function.mssql-connect
| From: | Micio2 at osu1 dot php dot net | 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