Error: Connection test failed for user. The SQL Server might not be running. Verify that the SQL Server is running or try a different SQL Server login. (NETIQKB72239)

  • 7772239
  • 20-Apr-2010
  • 08-Dec-2010

Environment

NetIQ Analysis Center 2.7
NetIQ Analysis Center 2.7.5
Microsoft SQL Server 2005

Situation

When attempting to install Analysis Center on SQL Server 2005 cluster you may receive the following error:
Error: Connection test failed for user. The SQL Server might not be running. Verify that the SQL Server is running or try a different SQL Server login.

Resolution

The following is a workaround in order to install Analysis Center on a SQL Server 2005 cluster:

  1. Launch the Registry Editor (regedit or regedt32
  2. Backup the following registry entry: [HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\ComputerName\ComputerName]
  3. Change the registry entry value for the ComputerName key from the physical_server_name to virtual_server_name that you provided during SQL Server installation.
  4. Run the NetIQ Analysis Center setup, this time virtual_server_name will be listed in the installer's Warehouse text box. Provide the credentials, and this should allow the installation to proceed.
  5. After the installation completes, please revert the changes performed in Step 3 to its original value by restoring the backed up Registry key.

Cause

This error is caused if the NetIQ Analysis Center installer is not able to locate the SQL servers virtual name during installation and is unable to identify the cluster.

Additional Information

Formerly known as NETIQKB72239