Web+Center Support
22 Oct

Knowledge Base Detail

Case Summary: Connecting to Remote SQL*Server Database
ID: 260
Date Created: 02/23/2001
Last Modified: 02/23/2001
Problem Type: Problem Report
Item: Database
Resolution:
When IIS and SQL Server are running on separate machines, the NT domain security
must be set up to allow named pipes connections between the two servers.
Specifically:
The NT user account under which IIS runs anonymous processes
(IUSR_servername is the default) must be registered on both the Web server and the
SQL Server.
IUSR_servername must be a domain user and must have sufficient security
privileges to establish named pipe connections between the Web server and the SQL
server.

For additional information, refer to the following Microsoft knowledge base articles
which explain important interactions between NT network domains, IIS, and SQL
Server.

http://support.microsoft.com/support/kb/articles/q152/8/28.asp
http://support.microsoft.com/support/kb/articles/q175/6/71.asp
http://support.microsoft.com/support/kb/articles/q184/5/66.asp
Alternatively, you can modify the registry to run all applications as the system using
the following key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W3SVC\Parameters
Under W3SVC/Parameters, place the value CreateProcessAsUser as a
REG_DWORD and give it a value of 0. This causes CGIs to run with the
CreateProcess( ) API and run in the system context.
Note: This has serious security implications because CGI scripts will have much
greater access to the system than they normally would.

Return to FAQ List


Home | Search

Web+Center
Free and affordable Web-based Help Desk
Version: Ver. 9.0 - 02.07.17
(C) 2015 Internet Software Sciences
www.inet-sciences.com