Open topic with navigation

The Connect to BarTender System Database dialog, accessible from the File menu or the main toolbar, connects History Explorer to a specific BarTender System Database. The BarTender System Database can be installed locally, or on any computer on the network. The user must have the proper credentials to access the database.

The Connect to the BarTender System Database dialog contains the following controls:

• System Server: Defines the BarTender System Database server machine. The server name is the SQL server instance name hosting the BarTender System Database (e.g. MyComputer\BarTender). The SQL server hosting the BarTender System Database may be located on the local computer or on a remote machine.

  When the System Server dropdown field is expanded, previously selected BarTender System Database servers are shown. The Browse for more option displays the Browse for BarTender System Servers dialog, initiating a search for all BarTender System Database servers on your network.

• Database: Displays the BarTender System Database name. The default BarTender System Database name is "BarTender".

• Authentication: Defines the security credentials used to connect to the system database. The following authentication modes are available:

  • Windows Authentication: Uses a Windows user account for establishing a connection with the database. Access to the BarTender System Database SQL Server is controlled by your Windows account or group, which is authenticated when you log on to the Windows operating system on the client.

  • SQL Server Authentication: Uses SQL Server authentication for establishing a connection with the database. When you connect with a specified login name and password from a non-trusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded.

• User Name: Displays the active Windows user account. This option is only available if you have selected to connect using Windows Authentication.

• Login: Allows you to enter login credentials. This option is only available if you have selected to connect using SQL Server Authentication.

• Password: Allows you to enter the password for the login. This option is editable only if you have selected to connect using SQL Server Authentication.

• Remember Password: When enabled, specifies that the system will remember the password the next time you attempt to connect to the BarTender System Database.