Home Forums SQL Server 2008 SQL Server 2008 Administration Renamed AD users' accounts, now some SQL Servers can't get info RE: Renamed AD users' accounts, now some SQL Servers can't get info
Orlando Colamatteo
SSC Guru
Points: 182276
More actions
July 11, 2012 at 2:10 pm
#1511787
On the problem instance can you do this?
EXECUTE AS LOGIN = 'NewLoginName';
GO
REVERT;
EXECUTE AS LOGIN = 'OldLoginName';
There are no special teachers of virtue, because virtue is taught by the whole community.--Plato