/
Configure Database Connection Strings
Configure Database Connection Strings
Overview
The DryvIQ 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.
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.
Sample Microsoft SQL Server Connection Strings
Integrated Authentication (Windows Authentication)
Server=SqlServer;Database=dbname;Integrated Security=true
Use Specific Credentials (SQL Authentication)
Server=SqlServer;Database=dbname;User ID=myUsername;Password=MyPassword
Always On - Availability Group Listener with Multi-Subnet
Server=tcp:MyAGListener,1433;Database=dbname;IntegratedSecurity=SSPI;MultiSubnetFailover=True
Azure SQL DB Standard Connection
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
dbProvider=npgsql,dbConnectionString=User ID=myPostgreSqlUser;Password=MyPassword;Host=myServerName;Port=5432;Database=dbname
, multiple selections available,
Related content
Creating a New Connection
Creating a New Connection
More like this
Configure Microsoft SQL Server
Configure Microsoft SQL Server
Read with this
Configure Hosted PostgreSQL Database
Configure Hosted PostgreSQL Database
Read with this
Database Platforms
Database Platforms
Read with this
Configuration Options
Configuration Options
Read with this
Setting up DryvIQ Using REST Services
Setting up DryvIQ Using REST Services
More like this