ZCM support for MS SQL server 2008

  • 7004357
  • 02-Sep-2009
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2
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.

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.

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.