Environment
Novell ZENworks Asset Management 3.3 - ZAM3.3
Novell ZENworks 7 Asset Management - ZAM7
Novell ZENworks 7.5 Asset Management - ZAM7.5
Microsoft SQL 2000
Microsoft SQL 2005
Resolution
A usual backup of the database will not restore these 2 SQL users. If a database restore is needed, and these 2 SQL users are lost, create these users as per the steps below before restoring the database. In SQL Enterprise Manager go to Security | Logins and create the following 2 users.
1. NCStartup. In the General tab select the option for SQL authentication and give it a password of tally. Then select the ZAM database and language. Nothing needs to be changed in the Server Roles tab. In the Database Access tab, check the Permit checkbox for the ZAM database. Then in the 'Permit in Database Role' section check the public checkbox.
2. NCSystem. In the General tab select the option for SQL authentication and give it the password of tally. NOTE: NCSystem with password tally is the default, and may have been changed. Select the ZAM database and language. Nothing needs to be changed in the Server Roles tab. In the Database Access tab, check the Permit checkbox for the ZAM database. Then in the 'Permit in Database Role' section check the public and the db_owner checkboxes.