Connectors

SQL Server (SqlClient)

The connection parameters required to connect to a SqlClient SQL Server Database can be found below:

SQL Client

Parameter Value
Connection Name Name for the connection.
Description Description of the connection.
SQL Server Name The name of the SQL Server and SQL Instance Name (if applicable) you are connecting to. E.g. SQL01, SQL01\SQLExpress, server.database.windows.net.
SQL Database Name of the SQL Database you are connecting to.
Username (optional) The username required to access the SQL Server.
Password (optional) The password required to access the SQL Server.
Encrypt Option to encrypt the connection
Trust Server Certificate Option to save the trust server certificate.

Note: Ouvvi Windows Service Credentials are used by default unless alternate SQL Server credentials are supplied.

SQL Azure DB expects the username in the format username@database.database.windows.net.