Microsoft SQL Server

Description

Used for working with Microsoft SQL Server, this connector also works with both On-Premise and Azure Hosted SQL Server instances.

Connection String Templates

Template Name Description
SQL Server Standard The standard connection string for connecting to a SQL Server instance on the same server as the agent, uses integrated SSPI security.
SQL Server SSAS Uses SSAS to connect to a SQL Server instance.
SQL Server Trusted Uses trusted security to connect to a SQL Server instance. This requires the agent to be running as a trusted account.
SQL Azure Standard Uses the Azure standard URL naming convention to connect to SQL Server.

You can copy the connection string templates below into the connection string field in Loome Monitor and then replace the placeholders with your own details.

Template Example
SQL Server Standard Data Source=myServerAddress;Database=myDataBase;Integrated Security=SSPI;
SQL Server SSAS Data Source=myServerAddress;Initial Catalog=myDataBase;Provider=MSOLAP;Integrated Security=SSPI;Persist Security Info=True;
SQL Server Trusted Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
SQL Azure Standard Server=tcp:[serverName].database.windows.net;Database=myDataBase;Trusted_Connection=False;Encrypt=True;

Connection Notes