topic Re: sync all users after database backup in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815898#M3428 <HTML><HEAD></HEAD><BODY><P><A href="https://community.esri.com/migrated-users/364211">Craig Russell</A>‌ thanks for the reply, let me go into&nbsp; a little more detal, I restored a database from an April 30th backup and named it a different name (GDB2020) , I did this from SSMS. I ran the script, (<SPAN style="background-color: #ffffff;">EXEC sp_change_users_login 'Update_One', 'sde', 'sde')&nbsp;</SPAN> now I;m trying to connect to it from ArcMap using the sde credentials and ArcMap is giving me error ...</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/501845_pastedImage_1.png" /></P></BODY></HTML> Thu, 30 Jul 2020 13:24:00 GMT BryanPrice 2020-07-30T13:24:00Z sync all users after database backup https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815896#M3426 <HTML><HEAD></HEAD><BODY><P>After restoring a database from backup i use ...</P><P>EXEC sp_change_users_login 'Update_One', 'sde', 'sde'</P><P>how do i sync the windows authinicated users?</P></BODY></HTML> Thu, 30 Jul 2020 11:55:44 GMT https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815896#M3426 BryanPrice 2020-07-30T11:55:44Z Re: sync all users after database backup https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815897#M3427 <HTML><HEAD></HEAD><BODY><P>Hi Bryan</P><P></P><P>Not sure of the exact source of the script that I've used in the past to do this, but it was similar to the one found here -&nbsp;<A class="link-titled" href="https://www.sqlservercentral.com/blogs/what-about-orphaned-windows-users" title="https://www.sqlservercentral.com/blogs/what-about-orphaned-windows-users">What about orphaned windows users? – SQLServerCentral</A>&nbsp;&nbsp;</P><P></P><P>This only works for SQL Server 2012 and higher.</P></BODY></HTML> Thu, 30 Jul 2020 13:00:19 GMT https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815897#M3427 CraigRussell 2020-07-30T13:00:19Z Re: sync all users after database backup https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815898#M3428 <HTML><HEAD></HEAD><BODY><P><A href="https://community.esri.com/migrated-users/364211">Craig Russell</A>‌ thanks for the reply, let me go into&nbsp; a little more detal, I restored a database from an April 30th backup and named it a different name (GDB2020) , I did this from SSMS. I ran the script, (<SPAN style="background-color: #ffffff;">EXEC sp_change_users_login 'Update_One', 'sde', 'sde')&nbsp;</SPAN> now I;m trying to connect to it from ArcMap using the sde credentials and ArcMap is giving me error ...</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/501845_pastedImage_1.png" /></P></BODY></HTML> Thu, 30 Jul 2020 13:24:00 GMT https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815898#M3428 BryanPrice 2020-07-30T13:24:00Z Re: sync all users after database backup https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815899#M3429 <HTML><HEAD></HEAD><BODY><P><A href="https://community.esri.com/migrated-users/364211">Craig Russell</A>‌, I think I may see the problem if this below is correct?</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/501846_pastedImage_1.png" /></P></BODY></HTML> Thu, 30 Jul 2020 13:30:12 GMT https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815899#M3429 BryanPrice 2020-07-30T13:30:12Z Re: sync all users after database backup https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815900#M3430 <HTML><HEAD></HEAD><BODY><P>The source of your issue is more likely to be the renaming of the geodatabase; this doesn't work because fully qualified&nbsp;table names (i.e. database.schema.table) are stored throughout the SDE system tables.</P></BODY></HTML> Thu, 30 Jul 2020 13:34:57 GMT https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815900#M3430 CraigRussell 2020-07-30T13:34:57Z Re: sync all users after database backup https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815901#M3431 <HTML><HEAD></HEAD><BODY><P>Yep, just got in before me!</P></BODY></HTML> Thu, 30 Jul 2020 13:35:40 GMT https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815901#M3431 CraigRussell 2020-07-30T13:35:40Z Re: sync all users after database backup https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815902#M3432 <HTML><HEAD></HEAD><BODY><P>yes that is what the problem was... Thanks guys!!</P></BODY></HTML> Thu, 06 Aug 2020 13:19:17 GMT https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815902#M3432 BryanPrice 2020-08-06T13:19:17Z Re: sync all users after database backup https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815903#M3433 <HTML><HEAD></HEAD><BODY><P>Thanks for the update Bryan; could you please mark this as helpful and the correct answer&nbsp;to assist others who might have the same issue?</P></BODY></HTML> Mon, 10 Aug 2020 04:15:18 GMT https://community.esri.com/t5/geodatabase-questions/sync-all-users-after-database-backup/m-p/815903#M3433 CraigRussell 2020-08-10T04:15:18Z