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