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
- Alvao Service
- Alvao Custom Apps WebService
- ...
| 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 |