Creating a New Database Configuration

  1. On the All Data Sources tab, click Data Source.
  2. In the New Data Source Configuration tab, enter a unique name in the Name field.
  3. Optional: Add a description of the data source in the Description field.
  4. Optional: Enable Use Configuration as default if you want to use the selected data source when PAconfigurator launches.
  5. Enable Use additional login if you want to login using specific PAtools user credentials. This is required if your windows user does not exist as a PAtools user in the database.
  6. Set the authentication according to your server configuration requirements.
    OptionDescription
    Use Windows Authentication Recommended
    Use SQL Server Authentication Use this option to set an SQL Server authentication login. Enter the user name and password that you received from your IT department.
  7. Set the database connection.
    1. From the Server drop-down list, select the SQL Server® name where the database is stored. If necessary, wait until the list of available servers is completely filled. This may take a few seconds.
    2. From the Database drop-down list, select the desired database. The list of databases generates after you specify the server.
      Note If you cannot reach the desired SQL Server® during the configuration of the connection, it is also possible to enter the name of the SQL Server® instance and the database in the text fields. In this case, however, no check can be made as to whether the entered SQL Server® instance exists or whether the configured database exists in this SQL Server® instance.
  8. Click Test data source to verify the data source configuration.
  9. Click Save to store the new data source configuration.
The new database configuration appears in the list of configurations on the All Data Sources tab.