SQL 2000 script used in SQL 2005 Issue

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL 2000 script used in SQL 2005 Issue

Author

Topic

PCJunkie
Starting Member

7 Posts

Posted - 2009-06-01 : 00:39:32

I am new to SQL. I'm definately not a DBA or understand scripting yet.

I have a script that I can execute in SQL 2000 and it builds a new database and creates a couple default objects along with a Guest User account and Database Admin Account.

The problem when I run this same script in SQL 2005 I get the following output. **Note The new database is created without the default guest and ieadmin users which I beleive is the result of the below output. Is there a simple solution to this?

Msg 15116, Level 16, State 1, Line 1
Password validation failed. The password does not meet Windows policy requirements because it is too short.
Msg 15116, Level 16, State 1, Line 1
Password validation failed. The password does not meet Windows policy requirements because it is too short.
Msg 15007, Level 16, State 1, Procedure sp_addsrvrolemember, Line 68
'ieadmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Procedure sp_addsrvrolemember, Line 68
'ieadmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Procedure sp_addsrvrolemember, Line 68
'ieadmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 1
'ieadmin' is not a valid login or you do not have permission.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 75
User or role 'ieadmin' does not exist in this database.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 75
User or role 'ieadmin' does not exist in this database.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 75
User or role 'ieadmin' does not exist in this database.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 75
User or role 'ieadmin' does not exist in this database.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 15116, Level 16, State 1, Line 1
Password validation failed. The password does not meet Windows policy requirements because it is too short.
Msg 15007, Level 16, State 1, Line 1
'IEUSER' is not a valid login or you do not have permission.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 75
User or role 'IEUSER' does not exist in this database.

(1 row(s) affected)

PCJunkie
Starting Member

7 Posts

Posted - 2009-06-01 : 19:44:07

I figured this one out. The script that I was running has the NULL variable which sets the password of the user to blank. Of course this won't pass password limitations regardless of setting domain policy. When I entered a 6 digit password in place of the NULL variable it worked fine.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources