# 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:** 20\ **Page:** 1
**Author:** ![Salem\_Marshall](https://avatars.discourse-cdn.com/v4/letter/s/b38774/32.png) [@Salem\_Marshall](https://forum.inductiveautomation.com/u/Salem_Marshall)\ **Post date:** [September 6, 2022, 5:02pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/1 "2022-09-06T17:02:50Z")
I changed the username and password for our database connection. Immediately the connection faulted and now ignition and the database won’t communicate, pretty much breaking our project. I don’t know the old password or else I would just change it back. Why did this happen? Anyone know how I can fix it? ---
**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:** [September 6, 2022, 5:09pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/2 "2022-09-06T17:09:40Z")
Why _wouldn’t_ this happen? If you have a recent backup you could restore it. Otherwise you need to figure out the old username and password or configure the database so that it accepts whatever you used as the new username and password. ---
**Author:** ![Salem\_Marshall](https://avatars.discourse-cdn.com/v4/letter/s/b38774/32.png) [@Salem\_Marshall](https://forum.inductiveautomation.com/u/Salem_Marshall)\ **Post date:** [September 6, 2022, 5:15pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/4 "2022-09-06T17:15:19Z")
Yeah I figured out how to fix it and was about to delete my question. But dude, no need to be pretentious. I am trying to learn on the job while doing lots of other things. Don’t just assume everyone knows what you know and is stupid if they don’t. Mistakes and misunderstandings happen when learning something new. If you hop onto a forum to help people who have questions - that probably means you have knowledge they don’t. So just share that knowledge without trying to make yourself feel like a god by putting others down. It’s childish ---
**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:** [September 6, 2022, 5:19pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/5 "2022-09-06T17:19:46Z")
> [@Salem\_Marshall](#): > > But dude, no need to be pretentious. You just threw shade on one of the most helpful IA employees on this forum (if not **the** most helpful). His comment was not childish at all. It expressed some shock that _anyone_ would do that on what apparently is a production system and not expect those results. Dude. { And why are you "learning" on a production system? } ---
**Author:** ![Salem\_Marshall](https://avatars.discourse-cdn.com/v4/letter/s/b38774/32.png) [@Salem\_Marshall](https://forum.inductiveautomation.com/u/Salem_Marshall)\ **Post date:** [September 6, 2022, 5:26pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/6 "2022-09-06T17:26:24Z")
We both know the comment was intended to make me feel stupid for making the mistake, right? It would turn someone new off of asking a question for fear of looking like an idiot and getting embarrassed. We are a small company, someone implemented ignition here a long time ago and we are just trying to figure it out until we can take a class and learn more. I had taken a gateway backup. I don’t have anywhere else to “learn”. ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [September 6, 2022, 5:27pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/7 "2022-09-06T17:27:43Z")
> [@Salem\_Marshall](#): > > I don't have anywhere else to "learn". Sure you do, on a completely separate box isolated from the production system. Also, [https://inductiveuniversity.com](https://inductiveuniversity.com) ---
**Author:** ![Salem\_Marshall](https://avatars.discourse-cdn.com/v4/letter/s/b38774/32.png) [@Salem\_Marshall](https://forum.inductiveautomation.com/u/Salem_Marshall)\ **Post date:** [September 6, 2022, 5:30pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/8 "2022-09-06T17:30:48Z")
Okay everyone I didn’t mean to make myself public enemy #1. I just felt frustrated because I’m new and it seemed rude. Thanks to those that gave advice on where I can learn without affecting my production system, I will definitely take that into account 👍 ---
**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:** [September 6, 2022, 5:32pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/9 "2022-09-06T17:32:37Z")
> [@Salem\_Marshall](#): > > We both know the comment was intended to make me feel stupid for making the mistake, right? No, we don't. I didn't read it that way. { Kevin is an IA employee, so cannot really defend himself here. I'm not, so I don't feel inhibited defending him. } > [@Salem\_Marshall](#): > > I had taken a gateway backup. That's good. > [@Salem\_Marshall](#): > > I don’t have anywhere else to “learn”. Ignition has a resettable two-hour trial mode. Heavily promoted all over their website. Set it up on another box. Don't touch your production system until you have a clue. > [@Salem\_Marshall](#): > > Okay everyone I didn’t mean to make myself public enemy #1. You imputed rudeness where none existed and were yourself rude. I'll stop here. ---
**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\ **Post date:** [September 7, 2022, 2:33pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/10 "2022-09-07T14:33:53Z")
There, there… This was just a bad day. [Today will be better](https://www.savagechickens.com/2022/08/online-arguments.html). ---
**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:24pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/11 "2024-06-27T15:24:38Z")
I'm having the same issue. How were you able to resolve it. ---
**Author:** ![tmahaf](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tmahaf/32/23492_2.png) [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\ **Post date:** [June 27, 2024, 3:27pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/12 "2024-06-27T15:27:57Z")
You need to find the right creds, or as others have posted you could restore from a point before the change and it will have the credentials ---
**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:28pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/13 "2024-06-27T15:28:36Z")
Hopefully your issue isn't on a production system. ---
**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:30pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/14 "2024-06-27T15:30:56Z")
it is on the production system. I was just told to change the password because no one remembers it and no one on our team is familiar with Ignition, so I'm not sure how to restore from a point previously. ---
**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:33pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/15 "2024-06-27T15:33:09Z")
> **[Gateway Backup and Restore | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/platform/gateway/gateway-backup-and-restore)** > > Gateway Backups vs Project Exports ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [June 27, 2024, 3:34pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/16 "2024-06-27T15:34:35Z")
Also here: > **[Restoring Ignition Gateway Backups Video at Inductive University](https://inductiveuniversity.com/videos/restoring-ignition-gateway-backups/8.1)** > > Learn how to restore a Gateway Backup of Ignition. Understand the risks of overwriting a Gateway and remember to always make a backup of the existing configuration before restoring. ---
**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:35pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/17 "2024-06-27T15:35:07Z")
Once the dust settles, you guys need to sit down internally and discuss how to prevent stuff like this from repeating itself. The person that told you to do that probably shouldn't be in charge. ---
**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:36pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/18 "2024-06-27T15:36:57Z")
If I am able to find the current credentials and change it back would that fix the issues rather than going back to an older point. ---
**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:37pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/19 "2024-06-27T15:37:36Z")
It should, what database are you using? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [June 27, 2024, 3:39pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/20 "2024-06-27T15:39:07Z")
You could also, change them in the DB via your management system. Anyway that you can make the credentials that Ignition is using to connect to the DB valid will resolve the issue. ---
**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:39pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790/21 "2024-06-27T15:39:29Z")
I'm not completely sure as I haven't used any Ignition stuff before, but I can see that the driver is a micrsoft sqlserver jdbc driver so im assuming a sqlserver? [Next page](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790.md?page=2)