Sysload Management Server: impossible to start with MS SQL Server EXPRESS 2012

book

Article ID: 87261

calendar_today

Updated On:

Products

CA Automic Sysload

Issue/Introduction

Error Message :
On the sldmgts.log we have the following kind of errors at startup:

##############################################################################
Initializing database ...
sldmgts - Database Location : SERVER_NAME\SYSLOAD:0
DATE: sldmgts - Database Name : spa_db
DATE: sldmgts - Database User : spa_user
DATE: sldmgts - Database ClientFlag : 9
DATE: sldmgts - Database DBDir :
DATE: sldmgts - Database OptiLevel : 0
DATE: sldmgts - Current storage used : spa_user:*/[email protected]_NAME\SYSLOAD:0 (SQL Server Native Client 11.0/standard security/ODBC 03.52).
DATE: sldmgts - Active Directory mode set to 'integration'
DATE: sldmgts - Management Server service run as 'ADMR-F\s_sysload'
DATE: sldmgts - AD TraceLevel = 0
DATE: sldmgts - Error when connecting to db 'spa_db', unable to establish a connection using connection string 'DRIVER={SQL Server Native Client 11.0};SERVER=SERVER_NAME\SYSLOAD;DATABASE=spa_db;UID=spa_user;PWD=*hidden*;MARS_Connection=yes;APP=Sysload_ODbMgr;' (rc=-1)
DATE: sldmgts - The driver reported the following diagnostics while running ODbMgr_Open():
DATE: sldmgts - 28000:1:18456:[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'spa_user'.
DATE: sldmgts - Can't connect to base of objects.
DATE: sldmgts - OBaseOfObjects_GetTypeIdByName() failed: unable to connect to database!
DATE: sldmgts - Could not initialize(2) database.
DATE: sldmgts - Could not initialize database.
DATE: sldmgts - The driver reported the following diagnostics while running ODbMgr_Close():
DATE: sldmgts - 08003:1:0:[Microsoft][ODBC Driver Manager] Connection not open
DATE: sldmgts - Unable to close connection from 'spa_db': DB rc=-1
DATE: sldmgts - The driver reported the following diagnostics while running ODbMgr_Close:
DATE: sldmgts - 08003:1:0:[Microsoft][ODBC Driver Manager] Connection not open
##############################################################################

Patch level detected:Sysload Management Server 6.00
Product Version: Sysload 6.0.0

Description :The Management Server cannot start with MS SQL Server EXPRESS 2012

Cause

Cause type:
Defect
Root Cause: The database's password was encrypted multiple times.

Environment

OS: Windows
Related configuration item(s): MS SQL Server EXPRESS 2012

Resolution

Update to the fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Component: Management Server
Version: Sysload 6.0.0
v6.00a

Additional Information

Workaround :
N/A