Unable to connect to MSSQL server if user is non-admin
| From: | Andres Montiel | Date: | Thu, 09 Oct 2003 07:09:39 +0000 |
| Subject: | Unable to connect to MSSQL server if user is non-admin | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-165589@lists.php.net to get a copy of this message | ||
Setup:
Windows 2000
Microsoft SQL Server 2000
PHP 4.3.3
IIS 5
AdoDB
On my IIS server, I set it to reject anonymous logins (I need to
eventually get the NT login names). I am able to run PHP scripts on the
defined site (it can run a phpinfo() script).
On another computer, I try to access the page that reads from the
database. If I logon on the remote pc as using the username of the
database admin, I my script runs fine. If I logon as a regular user, I get
the following errors:
--------------------
Warning: mssql_connect(): Unable to connect to server: datawarehouse,1433
in C:\Inetpub\rr_intra\adodb\drivers\adodb-mssql.inc.php on line 424
Warning: Cannot modify header information - headers already sent by
(output started at
C:\Inetpub\rr_intra\adodb\drivers\adodb-mssql.inc.php:424) in
C:\Inetpub\rr_intra\config\config.php on line 51
--------------------
Any recommendations? :) I have going at this for 3 days but to no avail.