Problem with connection to the local database

Ignition
1

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?

2

Can you connect to the database with any other tools?

3

I was trying to connect it to SQL Server management Studio as per our requirements.

4

Do you get any kind of error message, or does it just show as 'faulted'? Can you try to give us more details?

6

It either shows faulted or reconnecting

7

Screenshot (17)
Screenshot (17)1920×1080 215 KB

8

As a newbie myself I would double check

JDBC driver

connect URL is within reach

Or double check DB password...

9
  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?
10
  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
11

Your database connection will eventually throw an error in the gateway logs(status>logs) can you post it here.

12

Screenshot (18)
Screenshot (18)1920×1080 343 KB

Screenshot (19)
Screenshot (19)1920×1080 400 KB

Screenshot (20)
Screenshot (20)1920×1080 315 KB

Screenshot (21)
Screenshot (21)1920×1080 320 KB

13
  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.
14
  1. 231.1.1.1 is a multicast address. The multicast addresses range is 224.0.0.0 through 239.255.255.255
15

I got an error message when I further looked into it

Screenshot (24)
Screenshot (24)1920×1080 244 KB

16

Are you connecting to SQL Express or full blown SQL Server?

17

I'm connecting to the SQL Express Service

18

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?

19

Have you turned on Allow Remote Connections?
AFAIR, Express has that turned OFF by default.

20

The instance is localhost

21

But is it necessary to enable 'Allow Remote Connections' since my SQL Server and the Ignition Gateway is on the same machine?