Instructions provided describe how to restore a SQL Server database with Windows logins to another machine. When users backup or detach to send a database for testing, restore/reattach is used to restore the database.However there are some cases when it is necessary to re-synch Windows logins that were created on different domains or are local to different machines.
The following procedures only apply to SQL Server 2005, 2008 and 2012.
ALTER USER [udm\gis] WITH LOGIN = [testdm\gis]
Get help from ArcGIS experts
Download the Esri Support App