Knowledge Base/ALM: QuickTest Pro, Business Process Testing, and Quality Center

Cannot Validate Database Parameters QC 10 / ALM 11 Installation

Chris Carpenter
posted this on February 15, 2011, 6:02 PM

Applies to

QC 10.0 and ALM 11.0 Database validation errors

Issue Summary

When trying to install ALM 11.0 on Server 2008 and SQL 2008 Standalone machine, database parameters fail to be validated. This is most likely due to wrong login credentials, however if you are sure you have the right login information and proper permissions then it could be due to SQL 2008 having TCP/IP disabled by default installation.

Prerequisites

User must have complete administrative access.

SQL 2008 installed, with updates.

Steps

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.

Verify

From the Command Prompt run the command “netstat –an” and verify TCP Port 1433 is in LISTENING MODE.