# Problem with connection to the local database **URL:** \ **Category:** Ignition\ **Created:** [May 9, 2024, 6:44am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143 "2024-05-09T06:44:04Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 9, 2024, 6:44am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/1 "2024-05-09T06:44:04Z")
I have downloaded Ignition Gateway version-8.1.31 for my 64 bit windows 10 computer, I am new to this software and when I tried to follow the documentation and connect to the local database I was unable to do so. The status of the database I'm trying to connect is shown as faulted. I also made sure that there was no problem with the firewall or network and still it didn't work. Can you please help me with this? ---
**Author:** ![nideyijuyidong](https://avatars.discourse-cdn.com/v4/letter/n/7cd45c/32.png) [@nideyijuyidong](https://forum.inductiveautomation.com/u/nideyijuyidong)\ **Post date:** [May 9, 2024, 6:48am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/2 "2024-05-09T06:48:01Z")
Can you connect to the database with any other tools? ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 9, 2024, 7:14am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/3 "2024-05-09T07:14:41Z")
I was trying to connect it to SQL Server management Studio as per our requirements. ---
**Author:** ![Josue\_Cuadras](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/josue_cuadras/32/59915_2.png) [@Josue\_Cuadras](https://forum.inductiveautomation.com/u/Josue_Cuadras)\ **Post date:** [May 9, 2024, 7:19am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/4 "2024-05-09T07:19:15Z")
> [@Thanya\_Gangesh](#): > > I'm trying to connect is shown as faulted. Do you get any kind of error message, or does it just show as 'faulted'? Can you try to give us more details? ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 9, 2024, 8:27am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/6 "2024-05-09T08:27:00Z")
It either shows faulted or reconnecting ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 9, 2024, 8:29am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/7 "2024-05-09T08:29:04Z")
![Screenshot (17)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/9/f9886d6897711210979c606f5cff4ff7a250ca4d.png) ---
**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\ **Post date:** [May 9, 2024, 8:44am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/8 "2024-05-09T08:44:55Z")
As a newbie myself I would double check JDBC driver connect URL is within reach Or double check DB password... ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [May 9, 2024, 10:02am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/9 "2024-05-09T10:02:59Z")
> [@nideyijuyidong](#): > > Can you connect to the database with any other tools? > [@Thanya\_Gangesh](#): > > I was trying to connect it to SQL Server management Studio as per our requirements. 1. You didn't answer the question. Were you able to connect using SQL Managemet Studio? 2. Please describe your setup more clearly. Is SQL Server on the same machine as the Ignition gateway or on a different machine? 3. What version of SQL Server are you using? ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 10, 2024, 4:17am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/10 "2024-05-10T04:17:46Z")
1. I was unable to connect using SQL Management Studio. 2. Yes, the SQL Server is on the same machine as the Ignition Gateway. 3. I'm using Microsoft SQL Server Management Studio - 19.0.2 version ---
**Author:** ![aaronrai24](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aaronrai24/32/87248_2.png) [@aaronrai24](https://forum.inductiveautomation.com/u/aaronrai24)\ **Post date:** [May 10, 2024, 4:25am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/11 "2024-05-10T04:25:47Z")
Your database connection will eventually throw an error in the gateway logs(status\>logs) can you post it here. ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 10, 2024, 4:34am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/12 "2024-05-10T04:34:27Z")
![Screenshot (18)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/3/6366e63d272552b12a80acbc5052fb8bfb37a2e6.png) ![Screenshot (19)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/6/36b7de3371f7b6b07ff198ac5d5ec7bc41d39804.png) ![Screenshot (20)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/e/5e94d25747030f3a5498a26830a9b65cd1758fa7.png) ![Screenshot (21)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/8/d899dbc50b06a0a30e0503df4aaa193898108122.png) ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [May 10, 2024, 8:08am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/13 "2024-05-10T08:08:44Z")
1. What is address 231.1.1.1? It's an Internet public address - not a private address. Any private network addresses should be in one of the ranges, - 192.168.0.0 - 172.16.0.0 to 172.31.0.0 - 10.0.0.0 1. What is the configuration of the SQL Server? If it is on the same machine then `localhost` would be the normal configuration. (Usually the database is installed on a different machine to avoid performance issues.) 2. What are you using SQLite for? You can't use it for Historian as it doesn't have a DATETIME datatype needed for the t\_stamp column. It is only intended for saving configuration information. > **[Private network](https://en.wikipedia.org/wiki/Private_network)** > > In Internet networking, a private network is a computer network that uses a private address space of IP addresses. These addresses are commonly used for local area networks (LANs) in residential, office, and enterprise environments. Both the IPv4 and the IPv6 specifications define private IP address ranges. > Most Internet service providers (ISPs) allocate only a single publicly routable IPv4 address to each residential customer, but many homes have more than one computer, smartphone, or other Int... ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 13, 2024, 5:27pm UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/14 "2024-05-13T17:27:07Z")
1. 231.1.1.1 is a multicast address. The multicast addresses range is 224.0.0.0 through 239.255.255.255 ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 13, 2024, 5:31pm UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/15 "2024-05-13T17:31:44Z")
I got an error message when I further looked into it ![Screenshot (24)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/8/2821a4028a325c4544bed6c34768b98afc50a6fd.png) ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [May 13, 2024, 5:41pm UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/16 "2024-05-13T17:41:54Z")
Are you connecting to SQL Express or full blown SQL Server? ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 15, 2024, 9:48am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/17 "2024-05-15T09:48:26Z")
I'm connecting to the SQL Express Service ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [May 15, 2024, 11:03am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/18 "2024-05-15T11:03:41Z")
Check the instance name. Express uses a different one from standard. When you connect to it with SQL Studio what is the instance it is using to connect? ---
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [May 15, 2024, 12:07pm UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/19 "2024-05-15T12:07:53Z")
Have you turned on Allow Remote Connections? AFAIR, Express has that turned OFF by default. ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 16, 2024, 4:34am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/20 "2024-05-16T04:34:07Z")
The instance is localhost ---
**Author:** ![Thanya\_Gangesh](https://avatars.discourse-cdn.com/v4/letter/t/58956e/32.png) [@Thanya\_Gangesh](https://forum.inductiveautomation.com/u/Thanya_Gangesh)\ **Post date:** [May 16, 2024, 4:36am UTC](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143/21 "2024-05-16T04:36:19Z")
But is it necessary to enable 'Allow Remote Connections' since my SQL Server and the Ignition Gateway is on the same machine? [Next page](https://forum.inductiveautomation.com/t/problem-with-connection-to-the-local-database/90143.md?page=2)