Essentially what i’m doing is attempting a proof of concept running Windows Server2003 SP2 and SQL Server 2005 Express. I am able to go through all the setup options using SQL Express as the external database and Active Directory as my user authentication DB. Every check a long the way works great and as soon as i’m done the config and it’s saved, all works well. When i restart the application, i am unable to login anymore. When this happened, i uninstalled completely, purged the install folder, deleted and re-created the database and tried again; same problem. Next i tried using the internal database for configuration and SQLExpress for user authentication and the same problem occurs. Lastly, I tried using the internal database for both configuration and user authentication and that WORKS. A couple of things to point out:
When i setup the user database to use SQL, the encrypted password has a value and plain password is NULL. If i change plainPassword to admin and encrypted password to NULL i am able to login. Seems to be a problem reading the encrypted password?
In the error logs i get this message: Violation of PRIMARY KEY constraint ‘ofProperty_pk’. Cannot insert duplicate key in object ‘dbo.ofProperty’. Additionally, when i run the Microsoft SQL script to configure the database, i get a message regarding the key length being to big. Exact error =
Warning! The maximum key length is 900 bytes. The index ‘ofRoster_jid_idx’ has maximum length of 2048 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index ‘ofSASLAuthorized_pk’ has maximum length of 4128 bytes. For some combination of large values, the insert/update operation will fail.