Errors occur while installing database components. Executing OnePointDB\eeaAddTasks.sql (NETIQKB39474)

fact
Security Manager 5.00

symptom
Errors occur while installing database components. Executing OnePointDB\eeaAddTasks.sql

symptom
Error executing SQL Statement in database msdb: 'The specified '@server' is invalid (valid values are returned by sp_helpserver)'.

/*********************************************************************************/
/*                                                                               */
/* AddTasks.SQL                                                                  */
/*                                                                               */
/* OnePoint 3.x SQL Server Script to create the database                         */
/*                                                                               */
/* (c) Copyright 1996-1999, NetIQ Corporation, All Rights Reserved               */
/*                                                                               */
/* Proprietary and confidential to NetIQ Corporation                             */
/*                                                                               */
/* Replacement: OnePoint                                                   */
/* Replacement: HOUQESMDB02\SQL2K .
                                                     */
/*********************************************************************************/
.


cause
The error is the result of changing SQL server name and not registering it in SQL Server.

fix

To resolve this error, exit the installation process and run the following SQL queries in SQL Query Analyzer:

sp_dropserver @server='oldservername'

where oldservername is the old name that appears when you run SELECT @@servername.

Next, run

sp_addserver @server='currentservername', @local='local'

where currentservername is the current name of the server.

 

note

If you get this error while installing the database components on a named instance of SQL Server, use following syntax to correct the issue.

Seperate the 'oldservername' and 'currentservername' statements with "\" to enter the instance name.

Example:
sp_addserver @server='MYTESTSERVER\MYNAMEDINSTANCE'

Formerly known as NETIQKB39474