Environment
Security Manager 6.x
Security Manager 5.x
Situation
When installing Security Manager, the installation will have an error mentioning that the @server name is incorrect.
Resolution
This can be addressed by correcting the servername. First, validate the servername in sql by performing the following query:
select @@servername
If this returns the incorrect hostname, please follow the steps in this MSDN article to correct it (note the need to restart the SQL service once the changes are made): http://technet.microsoft.com/en-us/library/ms143799.aspx
Cause
When the hostname of the SQL server is changed, but the @@servername is not modified, the installer will fail.
You may see the following error when installing Security Manager:
Error executing onepoint. edb.addtask.sql
Additional Information
Formerly known as NETIQKB71324