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

Document ID : KB000087261
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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:*/spa_db@SERVER_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
Environment:
OS: Windows
Related configuration item(s): MS SQL Server EXPRESS 2012
Cause:
Cause type:
Defect
Root Cause: The database's password was encrypted multiple times.
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