note 79130 added to function.mssql-connect
| From: | datawiz at osu1 dot php dot net | Date: | Tue, 13 Nov 2007 05:27:23 +0000 |
| Subject: | note 79130 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-132216@lists.php.net to get a copy of this message | ||
My System
- Windows Server 2003 R2
- MS SQL Server 2005
- PHP 5.2.4
- IIS 6
- \System32\ntwdblib.dll 2000.80.194.0 (Windows original)
- \php\ntwdblib.dll 2000.2.80 (php package original)
- On local host
- 'Windows Authentication' for SQL Server
I just changed the default settings as following:
- enabled mssql.secure_connect() [Default was Off]
- enabled pipe name protocol [Default was disable]
- enabled TCP/IP IP1 [Default was disable]
- added my Windows' loging name into database users
- restarted SQL services and the Web server
- and removed the username/password from php script:
mssql_connect('MyDomain', '', '')
- Important: I did NOT downgrade my 'Windows Authentication' to 'Mixed mode"
You can learn how to make these changes by reading other posts on this page. You may get the same
result with even less changes.
----
Server IP: 66.207.199.35
Probable Submitter: 137.186.61.224
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/79130
Del: integrated -- https://master.php.net/note/delete/79130/integrated
Del: useless -- https://master.php.net/note/delete/79130/useless
Del: bad code -- https://master.php.net/note/delete/79130/bad+code
Del: spam -- https://master.php.net/note/delete/79130/spam
Del: non-english -- https://master.php.net/note/delete/79130/non-english
Del: in docs -- https://master.php.net/note/delete/79130/in+docs
Del: other reasons-- https://master.php.net/note/delete/79130
Reject -- https://master.php.net/note/reject/79130
Search -- https://master.php.net/manage/user-notes.php