NetIQ Security Manager Core service errors when starting. (NETIQKB71206)

NetIQ Security Manager Core Service will not start.


The following errors appear in SMServiceHost.txt:

System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
ERROR NetIQ.SM.SMServiceHost.ServiceMain: The Business Services sub-service failed to start
ERROR NetIQ.SM.SMServiceHost.ServiceMain: NetIQ Security Manager Core service failed to start

When starting the NetIQ Security Manager Core service, you receive an event id 1000 in the application log for both the Business Services and the Core service.

The following file should contain the string that will be used to correct this issue:

C:\Documents and Settings\user_name\Local Settings\Temp\NetIQsm-maininstallation-mmddyyyy hhmmss.txt.

Look for this string in the file:

BusinessServiceServerConfiguration.exe /dir:"C:\Program Files\NetIQ Security Manager\NetIQ Security Manager Core" /onepointdb:HTSSM1 /commondb:HTSSM1 /host:HTSSM2 /id:{54172006-AFE5-4187-8120-0DDB002EE6D1} /name:"labsm"

If there are double double-quotes or double brackets around the last 2 entries (guid and config_group name), remove the excess marks, and then run that string from a command line.

An example of an incorrect string would be:

BusinessServiceServerConfiguration.exe /dir:"C:\Program Files\NetIQ Security Manager\NetIQ Security Manager Core" /onepointdb:HTSSM1 /commondb:HTSSM1 /host:HTSSM2 /id:{{54172006-AFE5-4187-8120-0DDB002EE6D1}} /name:""config_group_name""

An example of a correct command to fix the issue would be:

C:\program files\netiq security manager\netiq security manager core\BusinessServiceServerConfiguration.exe /dir:"C:\Program Files\NetIQ Security Manager\NetIQ Security Manager Core" /onepointdb:HTSSM1 /commondb:HTSSM1 /host:HTSSM2 /id:{54172006-AFE5-4187-8120-0DDB002EE6D1} /name:"config_group_name"

This can be caused if the smservicehost.exe.config file has localhost instead of the actual SQL server listed.  In some cases, a section called BusinessServices may be missing from this file as well.

Formerly known as NETIQKB71206

If the error persists, or you experience additional problems with these services after applying this fix, please contact NetIQ Technical Support for further assistance, and reference this KB Article.