December 15, 2016 at 3:58 am
Hi
AD user names have changed. Just the naming standard has changed not the domain.
eg
Previous Name : ROCK\JDaniels
New Name : ROCK\AA230373
On SQL Server, there has been no issues.
There is a business requirement that I have to change the old Logins to the new naming structure.
So I have to rename ROCK\JDaniels to ROCK\AA230373 on SQL Server.
Also I have to make sure the user names in the databases get renamed and the correct rights are retained.
Any help will be appreciated.
December 15, 2016 at 4:41 am
BradGrantSky (12/15/2016)
HiAD user names have changed. Just the naming standard has changed not the domain.
eg
Previous Name : ROCK\JDaniels
New Name : ROCK\AA230373
On SQL Server, there has been no issues.
There is a business requirement that I have to change the old Logins to the new naming structure.
So I have to rename ROCK\JDaniels to ROCK\AA230373 on SQL Server.
Also I have to make sure the user names in the databases get renamed and the correct rights are retained.
Any help will be appreciated.
Although you renamed the account the SID in AD hasnt changed, this is what sql server references.
To rename the logins use the ALTER LOGIN WITH NAME command
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2016 at 10:42 pm
Thank you so for the assistance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply