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.
| Author |
Topic |
|
sankargvsb
Starting Member
2 Posts |
 Posted - 2007-02-02 : 04:23:06
|
| Hi All,Basically I am Oracle DBA and Programmer.I am new to SQL Server 2005 programming, and I started writing coding for migrating the database from SQL2000 to SQL2005. I am facing one problem here. The problem description is as follows:"In SQL 2000 we have created logins those created to access application, and we need to migrate these users to SQL 2005. But SQL 2005 password policy is strong than SQL-2000. And migrating "logins" script should be called after executing 7 scripts."My question is I need to prompt the users to enter the password to set for all migration users and this password should be replaced in the logins script. Can any body help how to implement this?Thanks in advance,SankarSankarG |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-02 : 12:51:43
|
| Do these users have access to Management Studio? If they do, then they will be able to change their password there. If your users are end-users via an application, then you can't set the flag as the application will not be able to prompt them for their new password unless a code change is done. Let us know if they have access to Management Studio. I'll look for the T-SQL code if that's the case.Tara Kizer |
 |
|
|
sankargvsb
Starting Member
2 Posts |
Posted - 2007-02-05 : 04:23:42
|
| Hi,Thanks for the update!These users have access to Management studio. I solved this as belowFirst creating the logins with password as login names itself; by disabling the check_policy=OFF and once logins created successfully enabling check_policy=ON.Thanks,SankarSankarG |
|
|
|
|
|
|
Migrating users from SQL 2000 to SQL 2005