How to make Dollar Universe interact with SQL Server and Agent?
Release: All versions
Component: DOLLAR UNIVERSE
Configuring a Connection to the Database
This window allows the user to enter information about the configuration of connections to the SQL Server database.
The Manager system account does not have an impact on the connection.
Advanced parameters: This property replaces the previous node setting MSQ_CONNECTION_ADVANCED_PARAMETERS. It can therefore be specific to the connection. Enter the connection String Properties e.g. "Failover Partner". Valid properties vary with the version of Microsoft SQL Server.
Refer to section "Working with AlwaysOn Availability Groups (SQL Server 2012)".
Once the required data has been entered, click on the button "Validate SQL Server Connection" to verify that the connection parameters are correct and that the targeted instance can be reached.
If the message: “The database connection verification was not successful…” is displayed, there may be a problem with the credentials provided above. Alternatively, the instance may not be reachable for other reasons in which case contact the SQL Server administrator.
Click on Save or Save and close to update all the connection parameters.
The configurations are saved in the file data/data_java/mssql_connection.xml.
Validate SQL Server Connection
The Validate SQL Server Connection button allows the user to test the communication with the SQL Server database (instance and rights).