DB Connection Faulted

Ignition
,
1

I’m new to Ignition and I’m trying to create value trend logs using the Historian. From what I’ve learned in Ignition University, I need to set up a database connection, but mine is currently showing as FAULTED.

When creating the database connection, it asks for a username and password.

My first question is: Are these credentials supposed to be created earlier in SQL?
I’ve attached a screenshot of my localhost database settings, but I’m not sure if they are correct.

Could you please guide me on the correct steps to create the database and set up the connection?

SQL Setup
SQL Setup1241×667 151 KB

Thanks

2

Yes.
If you are using MSSQL. You can go through these two videos and try to set up the connection. If you still face issues after doing so, you can post the issue with the error message here.

3

Thanks Peter

I have already watched the videos and followed them up, I have attached the steps that I have passed to create DB.

Step 1:

1

Step 2:

2
21153×801 137 KB

Step 3: Error message

3
31361×109 13.5 KB

Any missing step. unfortunately I am not very familiar with SQL and haven no idea if the settings are correct.

Thanks and Regards

4

This is not the error message. The error message is in the database connections section is status tab in the gateway.

5

Sorry, wrong attachment.

4
4676×480 64.3 KB

A quick note, that I have used the username : sa and password created at following page while adding SQL connection.

5
5590×471 56.5 KB

Thanks

6

Verify if you have set the right server name in connect URL section.

Also check if you have set databaseName=test or to whatever DB name that you have created in Extra Connection Properties

1 Like
7

This issue is normally because TCP/IP is not enabled on the MSSQL server.

See here: Troubleshooting: Enabling TCP/IP in the SQL Server | DUG Insight User Manual | DUG Insight User Manual

6 Likes
8

Two notes;

  1. you are running the DB on localhost. This isn’t best practice, if this is for an install that will grow in requirements, run the DB on a separate VM or different server.

  2. You are using the SA account. Don’t do that. Create an Ignition user for the DB, and use that.

4 Likes
9

Thanks @Matrix_Engineering @Cose_Peter1 @jonathan.taylor for your advices.

I wasn’t successful on Microsoft SQL ,but could create DB using MySQL.

I am very novice at using SQL, so I needed to upgrade my knowledge about it.

By the way, I described steps, just in case if someone like me have issue of DB Creation.

  1. Installed MySQL , I learned from this YouTube video : MySQL installation

  2. I have done following settings at ignition Gateway

    MySQL
    MySQL760×811 122 KB

  3. Done!

image
image1337×144 6.09 KB

Appreciate you kind support.

1 Like
10

I know you moved to mysql, but where did you get that instance name from (MSSQLSERVER)? My guess is that you created the instance as the default instance which means this should be blank on the ignition connection. Ie just

jdbc…./localhost/

11

From the docs: Connecting to Microsoft SQL Server Express | Ignition User Manual

MySQL is better anyway, IMO. MSSQL requires a license.

2 Likes
12

Is your MSSQL server located on the same server ? if not , probably , you need to create an inbound rule to let your Ignition server see the MS SQL server through TCP/IP.

13

Based on their connection param of “localhost”, I’d say yes.

1 Like