I have an issue where I cannot get ignition to communicate with SQL. They are on separate VM’s on same server. I’ve tried all examples I could find online. Any suggestions on what I could do that I haven’t done yet?

Solution: I'm under the SQL authentication. I needed the same user and password. I also needed to go into SSMS and go to login or users tab and change password for my login to match login in my ignition gateway.

[image] Breen: Any suggestions on what I could do that I haven’t done yet? There's some pretty smart people here but I don't think any of us can read your mind. What have you tried? What's the error message?

Which flavour of SQL? E.g. MySQL by default only allows connections from LocalHost, MsSQL server has a roles feature for saying which users/from where can connect to the instance/schemas.

Some hypervisors have a default networking type that blocks guest-to-guest traffic. Have you made any connection or even pings from one VM to the other?

Your Right! I started this to see general ideas. I can ping VM, I’ve gone into properties on MSSQL and changed authentications. I’ve tried to recofig database in ignition for the MSSQL. no connection to database.

I am using MSSQL on a separate VM

I have been able to ping the other VM and I can RDP to my sql VM from the ignition VM. I’ll look into the default networking type in the Hyper V to see if guest to guest is blocked.

What is the error you are getting? What version of MSSQL? Express LocalDB, for example, does not allow TCP/IP connections.

Also probably worth making sure that Windows Firewall (where MSSQL is running) has a rule to allow incoming connections on ports 1433/tcp and 1434/udp.

“connection Error username failed to connect.” Fails if I have an actual user connected and if I do not create a user or password.

what about using sql management studio to connect from the ignition machine to the sql machine using the credentials you setup for ignition?

Ignition to SQL on separate VM's Troubleshooting

Ignition

Matrix_Engineering July 20, 2022, 4:09pm 14