Select to view content in your preferred language

MS SQL Enterprise Geodatabase (EGDB) User Password reset

120
1
4 weeks ago
TylerT
by
Occasional Contributor III

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.

TylerT_0-1721157280145.png

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

0 Kudos
1 Reply
ChrisUnderwood
Esri Contributor

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.

 

0 Kudos