ZENworks 7.5 Asset Management SQL, Default Domain Password Policy Installation Error

0 Likes

Have you ever received a password error relating to the domain policy while trying to install ZENworks 7.5 Asset Management (ZAM)?



Novell Consulting might have developed a tool to solve this issue, but you may only be able to use it on a business to business case.



Here's how to create accounts on the SQL database in order to install the ZENworks 7.5 Asset Management Database.



There is a very simple solution to this annoying problem:



Create two SQL Login accounts before installing ZAM.



  • The first is called NCStartup with the fixed password tally,

  • The second is 'by default' called NCSystem with a password that complies to the Default Domain Password Policy.



When creating the ZENworks 7.5 Asset Management database during installation, you simply select the already created user "NCSystem".



The installation continues without stopping at that error. All is set and done.



Short guideline


Go to the Microsoft SQL Server, open the SQL Server Management Studio. Use the Object Explorer to expand the server instance where you want to create the two objects.



Right-click on the "Security" folder. Choose New, Login.



Set the Login name to "NCStartup" and select "SQL Server Authentication", Enter the password "tally" and confirm it.



Uncheck the box "Enforce password policy" options and click OK.



Right-click on the "Security" folder again and select New, Login.



Set the Login name to "NCSystem" and select "SQL Server Authentication", Enter a password twice, which complies to the Password Policy of the Domain.



Check the box "Enforce password policy" options and click OK.


Labels:

How To-Best Practice
Comment List
Related
Recommended