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 |
|
gk_sql
Starting Member
9 Posts |
 Posted - 2006-10-17 : 07:23:46
|
| I migrated database from sql server 2000 to 2005. I want to copy logins . I generated the script and add login to 2005 using the following statement.EXEC sp_addlogin 'User1', 0x2131214A212B57304F5A552A3D233453, @encryptopt = 'skip_encryption'EXEC sp_addlogin 'User2', 0x2131214A212B57304F5A552A3D513453, @encryptopt = 'skip_encryption'In 2005 User1 is working fine and i can login. But User2 is not working.I issued same command for the two logins..Collation is same on both servers.What may be the issue ?Plz adviseGK |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-17 : 10:55:30
|
| When you say User2 is not working - do you see any errors, do you see the login in the list in SQL Server Management Studio or when you run sp_helplogins?Also, try running it with @encryptopt='skip_encryption_old'Note that while sp_addlogin still works you should start using CREATE LOGIN. |
 |
|
|
|
|
|
login Issues in 2005