I have been given the task to see if our software will work against SQL
Server 2005:-
XP Pro installed on a Virtual PC
SQL Server 2005 Standard Edition Installed
Mixed mode Security
Check policy set to off
Installation of 2005 was successful and no error reported in the logs.
Now the fun started hen attempting to install our software, using the SA
account (we have also created additional SQL logins too but still have the
same problem) it gets as far as creating the various databases but when
attempting to create tables it receives the following error:-
Create Table failed
SQL-DMO error: 15118 [Microsoft][ODBC SQL Server Driver][SQL Server]
Password validation failed.The password does not meet Windows policy
requirements because it is not complex enough
The password we are using meets the criteria for creating passwords and I
have also checked Windows Security Settings and the Passord Policy 'Password
must meet complexity requirements' is disabled
If you need any additional information please let me know.
Many thanks
PaulHi Paul,
make sure that there is o domain policy activated which forces secure
passwords.
HTH, jens Suessmeyer.|||Jens,
Thank you for your reply the domain policy is not currently active
Paul
"Jens" wrote:
> Hi Paul,
> make sure that there is o domain policy activated which forces secure
> passwords.
> HTH, jens Suessmeyer.
>
Wednesday, March 7, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment