Friday, March 9, 2012

IIS Virtual Directory Management for SQL Server Utility Problem with IIS 6

I have employed the virtual directory management for SQL Server utility
successfully in my office on two machines (which are part of a network
using Windows NT logins), to enable them to access SQL 2000 via HTTP.
Both machines run Windows XP Professional and IIS 5.1. On both
machines, it worked without any problems, and it also works on my home
machine, which also runs Windows XP Professional and IIS 5.1.
However, I have tried to use the utility to create a virtual directory
for an identical SQL database on a server running Windows 2003 and IIS
6.0, and I always receive the page cannot be found error. I have
ensured that everything is identical on all machines with regard to
security and permissions (although the server only offers Application
pool options rather than high, medium and low security options). They
all require Integrated Windows Authentication for both IIS and SQL, and
the permissions for the database tables are identical in all cases. I
have also installed a simple HTML page into the virtual directory on
the Windows 2003 server, and can view that, so I would be extremely
grateful if anyone could tell me what I need to do with IIS 6.0 and
Windows 2003 to enable the virtual directory to grant access to the SQL
database. I have installed the new service pack 4 for SQL 2000 on all
machines.Hello,
I believe you have to enable the Isapi extensions in IIS for Windows Server
2003.The following link should help you :
http://support.microsoft.com/defaul...4&Product=sql2k
Thanks,
Monica Frintu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"

No comments:

Post a Comment