Environment
Novell ZENworks 10 Configuration Management with Support Pack 2 -
10.2
Microsoft SQL Server 2005
Microsoft SQL Server 2008
Microsoft SQL Server 2005
Microsoft SQL Server 2008
Situation
Unable to access the ZENworks Control Center
Error: Login failed for user 'DATABASE\administrator'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1]
Errors accessing the MS SQL 2008 database appear when viewing the MS SQL database through the Microsoft SQL Server Management Studio.
Error: Login failed for user 'DATABASE\administrator'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1]
Errors accessing the MS SQL 2008 database appear when viewing the MS SQL database through the Microsoft SQL Server Management Studio.
Resolution
Microsoft SQL server 2008 is not supported with ZENworks
Configuration Management. See the supported databases at
Novell Documentation.
In this instance, ZCM needed to be reinstalled using a MS SQL server 2005 database.
In this instance, ZCM needed to be reinstalled using a MS SQL server 2005 database.
Additional Information
The "Failed to open the
explicitly specified database " error may not be the root cause of
ZCM not being supported on MS SQL 2008, nor is it the only error
that could be observed running ZCM on MS SQL 2008
server.