Re: Missing IIS (PLEASE HELP)
- From: "RobinS" <robins@xxxxxxxxxxxxxxxx>
- Date: Thu, 17 Jan 2008 22:27:27 -0800
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" <jwood@xxxxxxxxxxxxxxxx> wrote in message news:O9Lx2Y7VIHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
Okay, after realizing SQL Server 2005 Express is missing functionality I need, I decided to install SQL Server 2005. I knew this would be painfuFl, 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.
--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com
.
- Follow-Ups:
- Re: Missing IIS (PLEASE HELP)
- From: Jonathan Wood
- Re: Missing IIS (PLEASE HELP)
- References:
- Missing IIS (PLEASE HELP)
- From: Jonathan Wood
- Missing IIS (PLEASE HELP)
- Prev by Date: Re: How to search Team Foundation Server?
- Next by Date: Re: Inserting and updating values
- Previous by thread: Missing IIS (PLEASE HELP)
- Next by thread: Re: Missing IIS (PLEASE HELP)
- Index(es):
Relevant Pages
|
