Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution

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

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.

2 REPLIES
shocko
Honored Contributor
Solution

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

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 ;)

If my post was helpful please award me Kudos! or Points :)
Jasvir819
Frequent Advisor

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

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.