Database connection string formats
Published 24 October 2024
For different types of connection strings explained in full, please visit https://www.connectionstrings.com
Here are some examples of connection string formats, however these are not exhaustive.
SQL Server
"Server=[myServerName];Database=[myDatabase];User Id=[myUsername];Password=[myPassword];Trust Server Certificate=true;"
Using Entra
If not using integrated security, no username or password are provided and no authentication method is specified in the connection string then our tools will attempt to acquire an authentication token for the standard azure scope https://database.windows.net/.default.
We obtain this using DefaultAzureCredential.
PostgreSQL
"host=[myServerName];Port=[myPortNumber];Database=[myDatabase];User Id=[myUsername];Password=[myPassword];"
MySQL
"Server=[myServerName];Database=[myDatabase];Uid=[myUsername];Pwd=[myPassword];"
Oracle
"DATA SOURCE=[myServerName]/[myDatabase];USER ID=[myUsername];PASSWORD=[myPassword];"
