...
| align | center |
|---|
...
...
Overview
...
The Dryv Platform supports Microsoft SQL Server and PostgreSQL databases. For complex database scenarios,
...
you
...
can supply the connection string with the applicable options and format necessary for your database environment.
...
These connection strings can be modified with additional platform parameters and values. See below for examples.
...
...
| Note |
|---|
...
If connectivity to the database cannot be made with default database configuration options, it may be necessary to utilize the connection string to specify the correct parameters. For example, it is a common enterprise practice to change the default SQL Server port from 1433 to another port |
...
, requiring the use of a connection string. |
| Table of Contents | ||
|---|---|---|
|
Sample Microsoft SQL Server Connection Strings
...
Integrated Authentication (Windows Authentication)
| Code Block |
|---|
Server=SqlServer;Database= |
...
dbname;Integrated Security=true |
...
...
Use Specific Credentials (SQL Authentication)
| Code Block |
|---|
Server=SqlServer;Database= |
...
dbname;User ID=myUsername;Password=MyPassword |
...
Always On - Availability Group Listener with Multi-Subnet
| Code Block |
|---|
Server=tcp:MyAGListener,1433;Database= |
...
dbname;IntegratedSecurity=SSPI;MultiSubnetFailover=True |
...
Azure SQL DB Standard Connection
| Code Block |
|---|
Server=tcp:[serverName].database.windows.net;Database= |
...
dbname;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True |
Sample PostgreSQL Connection Strings
...
...
PostgreSQL Standard Connection
| Code Block |
|---|
dbProvider=npgsql,dbConnectionString=User ID=myPostgreSqlUser;Password=MyPassword;Host=myServerName;Port=5432;Database= |
...
dbname |