Greg Charles
SSC-Forever
Points: 45403
More actions
November 9, 2004 at 12:44 pm
#529500
What's happened is the database users were created with the database, but they aren't associated with a login on the new server. You can use sp_change_users_login to associate them. Look it up in BOL to see the details.
Greg
jcfilth
SSC-Addicted
Points: 447
November 10, 2004 at 2:24 am
#529569
Take a look at http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp
JC
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply