HP SIM 6.3 Install "TCP/IP protocol is not enabled for the specified database server..."

[dale wheatley]

When I run the install for HP SIM 6.3 on my Window 2008 R2 Server, I get the following:  "TCP/IP protocol is not enabled for the specified database server.  Please enable the tcp/ip protocol."  This is the result of choosing the MICROSOFT##SSEE database.  I also verified that TCP/IP and Named Pipes were enabled on this server. 

Please let me know what you think.

[shocko · Accepted solution]

I think MICROSOFT##SSEE refers to the windows Internal DB that is shipped with 2008 R2. You should be using SQL/SQLExpress. You can remove the WI DB using the Add/Remove features applet. The Insight Control DDV ships with an appropriate version of SQL express. If you have no other option other than MICROSOFT##SSEE then you need to install a support version. Once this is done, you need to enable TCP/IP connections using the SQL COnfiguration tool ;)

[Jasvir819]

To enable the TCP/IP protocol for the database instance

    Log on to the data-tier server on which the database instance is defined.

    Open the Start menu, point to All Programs, point to Microsoft SQL Server 2005 or Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.

    In the tree pane, click SQL Server 2005 Services or SQL Server 2008 Services.

    In the results pane, verify that, under the State column, Running appears next to the name of each service.

    If Stopped appears, right-click the name of the service, and click Start.

    In the tree pane, click SQL Server 2005 Network Configuration or SQL Server 2008 Network Configuration to expand it, and then click Protocols for MSSQLServer/MyInstanceName.

    If you specified the default instance during installation, the instance name will be MSSQLSERVER.

    In the results pane, verify that, under the Status column, Enabled appears next to the name of the TCP/IP protocol.

    If Disabled appears, right-click TCP/IP, and then click Enable.

    In the tree pane, click SQL Native Client Configuration to expand it, and then click Client Protocols.

    In the results pane, verify that, under the Status column, Enabled appears next to the name of the TCP/IP protocol.

    If Disabled appears, right-click TCP/IP, and then click Enable.

    In the tree pane, click SQL Server 2005 Services or SQL Server 2008 Services.

    In the results pane, right-click SQL Server (MSSQLServer/MyInstanceName), and then click Restart.