This guide helps you with any difficulties you may have in getting the correct settings and parameters when connecting Ignition to Microsoft SQL Server, a popular and robust relational database. To display the details about the status of your database connection, see the Note on the above window and click on the Database Connection Status link.Your connection is now created and the Database Connections page is displayed showing the Status of your connection as Valid.
Select Microsoft SQLServer JDBC Driver and click Next.Look for the orange arrow, click on Create new Database Connection.
The Database Connections page is displayed. From the menu on the left, select Databases > Connections.From the Gateway, go to the Configure section.To connect Ignition to Microsoft SQL Server