Wednesday, December 16, 2015

New AD User Login Not Reflecting In SQL

Too many warning messages in site systems or site components is not good. The SMS_HIERARCHY_MANAGER generated too many warnings and caused the component to critical status. The warning message is as below:

Microsoft SQL Server reported SQL message 15410, severity 11: [42000][15410][Microsoft][SQL Server Native Client 11.0][SQL Server]User or role 'DOMAIN\SC-Admins' does not exist in this database. : sp_addrolemember

My next action is try to create the login manually in SQL Server Management Studio but ended up with this SQL Error 15025, saying that the account is already exists.

After some searching and understanding with Mr.Customer, I found out that the login name is changed in the Active Directory but the SQL server is still having the old login name.

Instead of deleting the old login from SQL and recreate a new login. I used ALTER LOGIN to fix the problem. So just open up New Query in the SQL Server Management Studio. Enter and run the command below to alter the login

ALTER LOGIN [DOMAIN\Admins] WITH NAME = [DOMAIN\SC-Admins]

Command Guide:
ALTER LOGIN [DOMAIN\OldLogin] WITH NAME = [DOMAIN\NewLogin]



Regards,
Hau

No comments:

Post a Comment