Connectors
SQL Server (OleDB)
The connection parameters required to connect to a OleDB SQL Server Database can be found below:
| 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. |
| Network Library | The type of network library you are connecting to. Note: Network Library is nearly always TCP/IP or Named Pipes. |
| 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.