Hello i have a database setup with windowns authentication but when i try to connect i get this message. any idea what this is
I think Ignition does not accept windows auth for connecting to a DB, you must configure a user on your DB and enable the option to accept SQL external connections.
on SQL Server it's on Server Properties > Security > Server authentication
another possible solution it's to upgrade your JDBC driver.
EDIT: Link updated, thanks @Chris_Bingham
1 Like
@paul-griffith does this still work if I am running RHEL to a MSSQL server? The documentation is all for if Ignition is running on windows correct? So what if I am running linux?
See MSSQL Integrated Security on Linux Host - #4 by Kevin.Herron and MSSQL Integrated security from a docker container - #3 by declan.mccarthy
this isn't really documented / tested / supported by us, but it seems that at least one person has gotten it to work.
2 Likes