Error when initializing mssql database

Error when initializing mssql database

Hey all,

So, I'm trying to setup ADAudit Plus in our environment but am running into some trouble.
I've setup a server 2008 R2 to run the application. Installed ADAudit and everything looked fine. Installed as a Windows service and tried starting it with a domain admin account. That worked just fine and the system could grab data from our DCs.
The problem arises when I try to switch to using MSSQL 2008 R2 Standard as the backend database. After running the ChangeDB.bat and successfully connecting to MSSQL and also creating the database I am unable to start ADAudit.

From looking at logs, specifically serverOut, I can see one clear error:
[com.adventnet.db.adapter.mssql.MssqlDBAdapter]|[SEVERE]|[11]: Error during database preparation| 
java.sql.SQLException: Password validation failed. The password does not meet Windows policy requirements because it is too short.

Nw I've tried the ChangeDB.bat using both Windows credentials and even the sa account for MSSQL but I still get that same error when trying to start ADAudit.

This is from sysenvout log:
[com.adventnet.mfw.Starter]|[SEVERE]|[11]: Problem while Starting Server  | 
java.lang.Exception: Exception while initializing DB.
at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:327)
at com.adventnet.mfw.Server.startServer(Server.java:134)
at com.adventnet.mfw.Starter.start(Starter.java:334)
at com.adventnet.mfw.Starter.main(Starter.java:397)
at com.adventnet.sym.adsm.start.StartADSM$2.run(StartADSM.java:260)
Caused by: java.sql.SQLException: Password validation failed. The password does not meet Windows policy requirements because it is too short.

I can see that database_params.conf update with whatever I choose with ChangeDB.bat and since the database is created I would argue there is nothing wrong with the account, be it windows auth or sql sa.

I tried following the video,  https://www.youtube.com/embed/3YejvvuG-Rk, but that just doesn't work. Everything is successful until I get to executing run.bat. Then I see the above errors.



Regards,
Stefan

              New to ADManager Plus?

                New to ADSelfService Plus?