Fixing an LDAP account
-
You know how you use sp_change_users_login to re-align SIDs when moving a db to another server?
What would you use for an LDAP account, which normally doesn't require that?
In my situation, my QA network has a domain with the same name as the Production domain, but all the SIDs are different over there. So, when restoring a db over to QA, I have to realign the LDAP users.
Hopefully there is a better way than dropping the login from the instance level....
TIA!
-
Grubb (6/30/2011)
You know how you use sp_change_users_login to re-align SIDs when moving a db to another server?What would you use for an LDAP account, which normally doesn't require that?
In my situation, my QA network has a domain with the same name as the Production domain, but all the SIDs are different over there. So, when restoring a db over to QA, I have to realign the LDAP users.
Hopefully there is a better way than dropping the login from the instance level....
TIA!
I have used sp_change_users_login to re-align SIDS, but never to a server in a complete different domain. All the environments in my DTAP are the same. I think you dont need this,but in case check this link http://msdn.microsoft.com/en-us/library/ms174378.aspx
Good luck!
-
Thanks for the help, Ignacio!
Yeah, I use that one all the time, but just in case, I pulled the link.....And there I discover that sp_change_users_login is deprecated!! "ALTER USER" is the replacement....And it appears to handle windows accounts.
Nevertheless, the issue is that the SIDs are broke between the domain and the instance, rather than the db and the instance, so I don't think it's going to help in this case.
I ended up deleting and re-adding 🙁
Thanks for your help!
-Grubb
-
You are welcome!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply