-
fix login for sql 2005
I have a sql2005 db I moved from server A to server B. There was a login called grievuse that was a sql login that was assigned as dbo and data read and write. I added the grievuse to server b, but I can only add the login to the server. WHen I try to map this user to the db user it tells me 15023 user already exists. In sql 2000 there was a sp_fixlogin I could use to do this. Is there an equivalent in 2005
-
If it's regular sql login, you can remap it to db user with sp_change_users_login.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|