Unable to connect to MSSQL server if user is non-admin

From: 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.

« previous php.general (#165589) next »