Database connection string examples

This page provides examples of .NET connection strings for connecting to the Alvao database for various authentication methods, etc. Connection strings can be used to configure connections in:

Alvao WebApp
Asset Management WebService
Alvao Service
...

Authentication method	Connection type	Example connection string
Windows integrated	SQL server	Data Source=SERVER1;Initial Catalog=ALVAO;Integrated Security=True;TrustServerCertificate=True
SQL Server user/password	SQL server	Data Source=SERVER1;Initial Catalog=ALVAO;User ID=user1234;Password=secret1234;TrustServerCertificate=True
Microsoft Entra ID	Azure SQL	Data Source=company.database.windows.net;Initial Catalog=ALVAO;Authentication=Active Directory Integrated;TrustServerCertificate=True
Microsoft Entra ID user/password	Azure SQL	Data Source=company.database.windows.net;Initial Catalog=ALVAO;Authentication=Active Directory Password;User ID=user1234;Password=secret1234;TrustServerCertificate=True

Did not find what you were looking for? Ask our technical support team.