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®, enter the name of the SQL Server® instance in its text field. Then, enter the database in its text field. In this case, you cannot check whether the entered SQL Server® instance exists. You cannot check 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.