# Database password change broke connection **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [September 6, 2022, 5:02pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790 "2022-09-06T17:02:50Z")\ **Posts on this page:** 15\ **Page:** 2
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [June 27, 2024, 3:40pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/22 "2024-06-27T15:40:39Z")
Ok do you have SSMS installed? I would try and login in that way to verify the credentials. Or, you can just keep changing the credentials within Ignition until you get it right. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [June 27, 2024, 3:43pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/23 "2024-06-27T15:43:13Z")
Or change both ends to the same new password. 🤷‍♂️ ---
**Author:** ![O\_L](https://avatars.discourse-cdn.com/v4/letter/o/e56c9b/32.png) [@O\_L](https://forum.inductiveautomation.com/u/O_L)\ **Post date:** [June 27, 2024, 3:47pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/24 "2024-06-27T15:47:01Z")
there is ssms installed, but I'm not sure how to login. Is there different credentials I would need for that? ---
**Author:** ![O\_L](https://avatars.discourse-cdn.com/v4/letter/o/e56c9b/32.png) [@O\_L](https://forum.inductiveautomation.com/u/O_L)\ **Post date:** [June 27, 2024, 3:50pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/25 "2024-06-27T15:50:56Z")
How would I do this? ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [June 27, 2024, 3:51pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/26 "2024-06-27T15:51:00Z")
I don't understand, when you open SSMS it should prompt for login. Are you not seeing a prompt? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [June 27, 2024, 3:51pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/27 "2024-06-27T15:51:54Z")
> [@O\_L](#): > > there is ssms installed, but I'm not sure how to login. Is there different credentials I would need for that? If you also don't have the credentials for SSMS you probably need some help from your IT department or somebody at your company who does. > [@O\_L](#): > > How would I do this? via SSMS, the management software for your database. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [June 27, 2024, 3:53pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/28 "2024-06-27T15:53:07Z")
Log into SQL Server (via SSMS or other IDE) with an account that has user management privileges. Then you can change the password on the DB side for the account that Ignition is using, to match the new password you already put into Ignition. ---
**Author:** ![O\_L](https://avatars.discourse-cdn.com/v4/letter/o/e56c9b/32.png) [@O\_L](https://forum.inductiveautomation.com/u/O_L)\ **Post date:** [June 27, 2024, 3:55pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/29 "2024-06-27T15:55:27Z")
We got our Ignition from another company who set it up for us. Would it be advisable to call them, let them know about the password change, as I'm assuming they have user management privileges? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [June 27, 2024, 3:56pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/30 "2024-06-27T15:56:17Z")
Perhaps, but presumably **you** have the SQL Server. ---
**Author:** ![O\_L](https://avatars.discourse-cdn.com/v4/letter/o/e56c9b/32.png) [@O\_L](https://forum.inductiveautomation.com/u/O_L)\ **Post date:** [June 27, 2024, 4:13pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/31 "2024-06-27T16:13:34Z")
Ya, the server is located on site, but I'm not sure how to connect to it via SMMS. ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [June 27, 2024, 4:15pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/32 "2024-06-27T16:15:00Z")
Did you try to open SSMS? ---
**Author:** ![O\_L](https://avatars.discourse-cdn.com/v4/letter/o/e56c9b/32.png) [@O\_L](https://forum.inductiveautomation.com/u/O_L)\ **Post date:** [June 27, 2024, 4:17pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/33 "2024-06-27T16:17:18Z")
Ya, when I open it the only server name that pops up is my own computer, and I can log into that, but I don't think that is the correct option. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [June 27, 2024, 4:18pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/34 "2024-06-27T16:18:39Z")
Do you have IT people available that can do this, or at least supervise? An unsupervised neophyte connecting to a production database with superuser privileges is a potential disaster. ---
**Author:** ![O\_L](https://avatars.discourse-cdn.com/v4/letter/o/e56c9b/32.png) [@O\_L](https://forum.inductiveautomation.com/u/O_L)\ **Post date:** [June 27, 2024, 4:22pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/35 "2024-06-27T16:22:52Z")
We don't have IT people, besides the other company who set it up. We have never accessed the server, as only production is run through it, and we have never looked at production history. So, I am thinking of potentially calling this other company, but it's generally not a big deal if we are missing a bit of data, as long as production is running. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [June 27, 2024, 4:24pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/36 "2024-06-27T16:24:08Z")
> [@O\_L](#): > > calling this other company Ok, yeah. You probably need the DB admin password from them anyways. [Previous page](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790.md?page=1)