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.
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.
Disclaimer: As with everything else at Cool Solutions, this content is definitely not supported by Novell (so don't even think of calling Support if you try something and it blows up).
It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test, test, test before you do anything drastic with it.