microsoft.public.inetserver.iis

RobinS

1/20/2008 5:43:00 PM

Cool. Thanks for posting the solution.

RobinS.
-------------------------
"Jonathan Wood" <jwood@softcircuits.com> wrote in message
news:eQNAMSxWIHA.1212@TK2MSFTNGP05.phx.gbl...
> 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.
>
> --
> Jonathan Wood
> SoftCircuits Programming
> http://www.softci...
>
> "RobinS" <robins@imnottelling.com> wrote in message
> news:m_6dnekr0KdL2w3anZ2dnUVZ_h2pnZ2d@comcast.com...
>>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@softcircuits.com> wrote in message
>> news:O9Lx2Y7VIHA.1204@TK2MSFTNGP03.phx.gbl...
>>> 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.softci...
>>>
>>
>