Linked servers connection

I try do database connections used Microsoft SQLServer JDBC Driver with linked servers of SQL SERVER 2012 EXPRESS but i can’t.

What error are you getting? SQL Server is a little more complicated than setting up other databases with Ignition. Follow this and see if it fixes it -

https://docs.inductiveautomation.com/display/DOC/Connecting+to+Microsoft+SQL+Server+Express

i did it, but not worked. is not database in my server is a database that is on other server and I only have a linked server

If its a linked server, you just use an OPENQUERY to query through the main connection, you should not be setting up a separate connection in Ignition unless you want a direct connection (not linked server) to the other DB instance.

1 Like

thanks ryan.
i have this error when run the table : Exception: Error running query:
SQLQuery(query=SELECT * FROM OPENQUERY (KANSAS,‘SELECT * FROM Mont_Tags’), database=)@0ms
On: Carga de modelos.Root Container.Container.Table 3.data
caused by GatewayException: Login failed for user ‘sa’.
caused by SQLServerException: Login failed for user ‘sa’.

how i can login with windows authentication

I don’t know much about linked servers outside of querying them, I leave that stuff up to our DBA, but I believe when you setup the linked server in SQL you need to configure the authentication. My guess is this is something SQL server side, your just seeing the error echo’d back to Ignition from the query.

Ready, only change to windows authentication
https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/5/0/microsoft-sql-server-mssql-connection-guide-for-ignition
thanks