![]() Ensure the SQL Server login associated with the database user has been added to the instance under Security > Logins, prior to running the ALTER USER statement.Īttempting to make a connection to the database or within ArcCatalog as the SDE or USER login verifies that the login and user are properly synched.Use the following workflow for Microsoft SQL Server 2008 and later: The stored procedure 'sp_change_users_login' is in maintenance mode and may be deprecated by Microsoft. MSDN: sp_change_users_login (Transact-SQL) Note: Open a new query in SQL Server Management Studio and execute the following command:ĮXEC sp_change_users_login 'Update_One', 'sde', 'sde'Īfter the command is completed the following is reported:. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |