Missing IIS (PLEASE HELP)

[Jonathan Wood]

Okay, after realizing SQL Server 2005 Express is missing functionality I
need, I decided to install SQL Server 2005. I knew this would be painful,
but underestimated just how bad it would be. And, of course, nothing works
now.

Specifically, Visual Studio can no longer display information under the
database connections. I tried to add a connection. I selected Windows
Authentication, which is what I specified when I installed SQL Server, and
all it tells me when I click Test Connection is that it failed.

Prior to installation, I uninstalled SQL Server Management Studio Express,
SQL Server Express, and SQL Server Native Client.

I restarted SQL Server using the SQL Server Configuration Manager. It
appears the SP2 installation stopped it.

During installation, I got this message (IIS seemed to be working fine
before):

"IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is
disabled. IIS is required by some SQL Server features. Without IIS, some
SQL Server features will not be available for installation. To install all
SQL Server features, install IIS from Add or Remove Programs in Control
Panel or enable the IIS service through the Control Panel if it is already
installed, and then run SQL Server Setup again. For a list of features that
depend on IIS, see Features Supported by Editions of SQL Server in Books
Online.
"

And, when finishing up, I got this message:

..Net SqlClient Data Provider
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server)

Can anyone help? I'm dead in the water and MS doesn't seem to provide
support for this stuff.

 

[RobinS]

I think this is two problems. In the first one, what it is telling you is
that there is a IIS feature that you do not have enabled, and that feature
is called "Messages". You basically have to go into the Windows features (Go
to Programs&Features in Vista or Add/RemovePrograms in XP) and find IIS and
find that feature and enable it. In Vista, you can enable/disable specific
features this way; in XP I'm not sure how to configure which IIS features
are on/off.

For the named pipes problem, you need to run the Surface Area configuration,
go to Services and Connections, look under DatabaseEngine/Remote Connections
and make sure that local and remote connections are enabled, and "using both
TCP/IP and named pipes" is selected.

Good luck.

Robin S.
GoldMail, Inc.
-----------------------------------

 

[Jonathan Wood]

That wasn't it.

In two sessions with Microsoft support, I determined that A) there was no
SQL Server login account associated with my Windows account, and B) the
SqlDataServer connection string in machine.config had to be overridden to
work with SQL Server 2005 (instead of SQL Server Express).

Now it works.

Thanks.

 

[RobinS]

Cool. Thanks for posting the solution.

RobinS.
-------------------------