Used for working with Microsoft SQL Server, this connector also works with both On-Premise and Azure Hosted SQL Server instances.
| 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; |
The connection strings used by this connection are standard ADO.NET connection strings.
You can use Visual Studio to easily generate or find a connection string for a connected SQL Server.
We support SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL database, and Azure Synapse Analytics (formerly Azure SQL Data Warehouse).
Any users who are connecting to unencrypted databases will need to add encrypt=false to their connection string in Loome Monitor as of agent version 2022.05.17.1.