note 36843 added to ref.mssql
| From: | Steve at rn2 dot php dot net | Date: | Fri, 24 Oct 2003 13:30:38 +0000 |
| Subject: | note 36843 added to ref.mssql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-59233@lists.php.net to get a copy of this message | ||
If you are getting "Not associated with a trusted SQL Server connection" when trying to
connect to SQL Server 2000 or MSDE on a foreign computer and you have allready set SQL
Authentication to Windows and SQL Authentication, then try going to Control Panel->Administrative
Tools->Local Security Policy->Local Policies->Security Options and enable both Network
access: Let Everyone permissions apply to anonymous users AND Network access: allow anonymous
SID/Name translation. This should stop the error and allow you to use the server.
This was tested on Windows XP Profesional running MSDE.
----
Manual Page -- http://www.php.net/manual/en/ref.mssql.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+36843
Delete -- http://master.php.net/manage/user-notes.php?action=delete+36843&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+36843&report=yes
Search -- http://master.php.net/manage/user-notes.php