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/default...&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"

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"

IIS

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
Thanks

From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install.

|||

Tried that already and still sql server 2005 management studio does not appear.

|||

Are you able to install SQL Server?

What all components are you selcting while installing? Since you are not able to open Sql sever 2005, it seems like you are not selecting tools option.

Could you please give a snapshot of the error that you are getting?

(This http://msdn2.microsoft.com/en-us/library/ms143506.aspx mentions that “Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS)”. There should be no problem in installing SQL server without IIS (We tried in our lab we were able to install SQL Server without IIS).)

Thanks

Arpita

|||

Management Studio can be installed regardless of whether IIS is installed.

Management Studio is one of the "Workstation components", so you need to check that checkbox on the "Components to Install" page of the setup wizard. If you need to be more selective, you can also click the "Advanced" button the "Components to Install" page, expand the "Client Components" folder, and then install just the Management Tools to your machine.

Hope this helps,
Steve

IIS

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
Thanks

From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install.

|||

Tried that already and still sql server 2005 management studio does not appear.

|||

Are you able to install SQL Server?

What all components are you selcting while installing? Since you are not able to open Sql sever 2005, it seems like you are not selecting tools option.

Could you please give a snapshot of the error that you are getting?

(Thishttp://msdn2.microsoft.com/en-us/library/ms143506.aspx mentions that “Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS)”. There should be no problem in installing SQL server without IIS (We tried in our lab we were able to install SQL Server without IIS).)

Thanks

Arpita

|||

Management Studio can be installed regardless of whether IIS is installed.

Management Studio is one of the "Workstation components", so you need to check that checkbox on the "Components to Install" page of the setup wizard. If you need to be more selective, you can also click the "Advanced" button the "Components to Install" page, expand the "Client Components" folder, and then install just the Management Tools to your machine.

Hope this helps,
Steve

Iis

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
ThanksAs far as I've understood (I'm still on 2000), there's no need for IIS. At least it's not listed in the software requirements for Express Edition.

IIS

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
Thanks

From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install.

|||

Tried that already and still sql server 2005 management studio does not appear.

|||

Are you able to install SQL Server?

What all components are you selcting while installing? Since you are not able to open Sql sever 2005, it seems like you are not selecting tools option.

Could you please give a snapshot of the error that you are getting?

(This http://msdn2.microsoft.com/en-us/library/ms143506.aspx mentions that “Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS)”. There should be no problem in installing SQL server without IIS (We tried in our lab we were able to install SQL Server without IIS).)

Thanks

Arpita

|||

Management Studio can be installed regardless of whether IIS is installed.

Management Studio is one of the "Workstation components", so you need to check that checkbox on the "Components to Install" page of the setup wizard. If you need to be more selective, you can also click the "Advanced" button the "Components to Install" page, expand the "Client Components" folder, and then install just the Management Tools to your machine.

Hope this helps,
Steve