SQL connectivity issue

Ignition
1

Hello Team,

              I am facing SQL connectivity issue while trying to connect sql server with igntion. Here is the attached error I am getting while trying to connect. I am using sql auth for connection with sa login.

MicrosoftTeams-image (3)
MicrosoftTeams-image (3)849Ă—761 80.6 KB

Thanks

2

Welcome to the forum, Srushti.
You have somehow managed to format your post as code and the paragraph doesn’t wrap. You can use the 🖉 edit link to fix it. Try removing any leading spaces from the paragraph “I am facing …” and it will format correctly and you’ll get proper word-wrap.

Then post the error log as code using the </> code formatting button so we can read the cropped off text.

3 
Login failed for user 'sa'

Ensure you have the correct password in the database connection properties, and that SQL server has allowed Ignition the privileges to connect

4

Agreed with this--if you're getting to the point of receiving "Login failed", it means you're able to establish a socket connection to SQL Server, so connectivity is probably okay. Time to re[set] that password in the DB connection properties per @Matrix_Engineering guidance.

5

Also, I would highly recommend not using the sa user login for Ignition. Create a new, dedicated user for Ignition use.

4 Likes
6

@PGriffith
That was exactly what was going through the back of my head as I read this. Using the sa username/password for outside database access is probably not the best practice.

@Srushti_Nagulwar
Creating separate ignition login credentials for the database and using them instead would be the best approach to fixing this problem.