SMS 2.0 Web Reporting Installation Issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Roderick Buenbrazo [MSFT] (anonymous_at_discussions.microsoft.com)
Date: 03/13/04 

Date: Fri, 12 Mar 2004 16:47:06 -0800

Assuming you have the right password, the next thing you
should try to do is to stop & restart your SQL server
service, and then try to continue with the installation.

"This posting is provided AS IS with no warranties and
confers no rights. "

Roderick

>-----Original Message-----
>I'm having problems installing the SMS 2.0 Web Reporting
>Tool. I can't get past the "SQL Server Admin Access"
>installation page when it asks for the SQL "sa"
password.
>I do know the correct password and have changed it to be
>sure. I get the following errors after clicking "Verify
>Now"
>
>First error message:
>"The application failed to initialize properly
>(0xc06d007e). Click OK to terminate the application."
>
>Second error message:
>"Password verification failed! Please ensure you have
>mixed-mode security, Named Pipes as the default protocol,
>then re-enter the SQL server connection information and
>click the Verify Now button."
>
>I've checked the following:
>
>- SQL security is set to "Windows and SQL."
>- Named Pipes is the default protocol.
>- The correct password is being entered.
>
>Any ideas?
>
>BillB
>.
>

Relevant Pages

  • Re: Connect to SQL Sererv thru Named Pipes
    ... to acced SQL Server via Named Pipes from VB 6. ... The DBMSSOCN tell the OLEDB driver to use TCP/IP instead of the default ... There are pros and cons as normal for which protocol to use however IMO ...
    (microsoft.public.vb.general.discussion)
  • Re: Connect to SQL Sererv thru Named Pipes
    ... >> Ijust wanted to know how to configure the SQL Server to use Named Pipes ... In order to use TCP/IP protocols you need to ... > There are pros and cons as normal for which protocol to use however IMO ...
    (microsoft.public.vb.general.discussion)
  • Slammer Worm and SQL Server Network Protocols
    ... two cents on the Slammer worm and SQL Server worms in general. ... Named Pipes you can probably safely remove the TCP/IP protocol support from ...
    (NT-Bugtraq)
  • Re: How can I tell what protocols are enabled for the client?
    ... If your application connects thru the alias, ... secure network connectivity for SQL Server 2000 local databases) ... >If I have alias setup to use other protocol such as Named Pipes, does it mean the alias cannot be connected since Named Pipes is not enabled? ...
    (microsoft.public.sqlserver.connect)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... the ODBC source using named pipe, but I don't know how to enable named pipes ... If it is not working I am going to use ado to connect to sql server. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)