MS SQL Enterprise Geodatabase (EGDB) User Password reset

TylerT — Tue, 16 Jul 2024 19:18:58 GMT

Hello,

I've create a few users to our MS SQL successfully. On my last user creation, I botched the password and the doesn't have access as a result. What is the best workflow to:

1) change password of user (without knowing current password) OR

2) delete user and re-create.

Thank you,

Tyler

Enterprise 11.2

p.s. This is the geoprocessing tool I'm using to create user, called Create Database User.

I'm not readily seeing a change password geoprocessing tool.

Re: MS SQL Enterprise Geodatabase (EGDB) User Password reset

ChrisUnderwood — Wed, 17 Jul 2024 08:45:22 GMT

Hello @TylerT , an Admin user can change another user's SQL Server Authenticated password directly in SQL Server Management Studio > Login Properties. But of course, this change will not propagate to other places you may have stored it such as an Esri Database Connection file.

topic MS SQL Enterprise Geodatabase (EGDB) User Password reset in ArcGIS Enterprise Questions

MS SQL Enterprise Geodatabase (EGDB) User Password reset

Re: MS SQL Enterprise Geodatabase (EGDB) User Password reset