I used MS Article ID: 246133 to create the sql logins from my sql 2000 installation into the sql 2005 installation. I then restored the user databases. If I go into sql and reset the password, I can then access. How do I avoid having to reset all 50 user's passwords?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copied sql logins from 2000 to 2005 but cannot access
- Thread starter Luvsql
- Start date
- Thread starter
- #3
Is there a way to determine which one is the issue? Our passwords are not complex (the one I was trying was only 6 letters), so I assume it's the SIDs, however, the Microsoft how to document is specifically aimed at "moving" sql logins between servers on different versions, so I'm surprised there is nothing in there are adjusting for this when they are created.
I looked at the SID articles and it looks like each one has to be fixed one at a time? We have over 50.
I looked at the SID articles and it looks like each one has to be fixed one at a time? We have over 50.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question