Open topic with navigation

Connecting to a Remote Database

Required Edition

Enterprise Automation

Additional Software

SQL Server or SQL Express

The following instructions describe how to connect to a remote database.

ClosedDefining the SQL Server Authentication Method

Two authentication modes are available when connecting to the BarTender System Database. The selected authentication method defines the security credentials that are used when connecting to a remote database.

ClosedSetting Up the BarTender System Database for Remote Connection

Configuring the Server

In order for BarTender to communicate with a remote BarTender System Database instance, remote access and the TCP/IP protocol on the host database must be enabled. If you are using MSSQL 2005, use the SQL Server Configuration Manager to enable the TCP/IP connections.

ClosedTo enable remote access

  1. Open the Microsoft SQL Server Management software.

  2. In the Object Explorer, right-click the Server Instance name and select Properties. The Server Properties dialog appears.

  3. Select Security from the Server Properties Select a Page pane.

  4. Under Server Authentication, select the type of authorization from the following options.

    • Windows Authentication. Allows you to connect with a local user account that has the proper read, write and create database permissions.

    • SQL Server Authentication. Allows you to connect with a SQL Server Authentication login name and password which is predefined during the SQL Server install. SQL Server performs the authentication by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded.

  5. Select Connections from the Server Properties Select a Page pane.

  6. Under Remote server connections, ensure that the Allow remote connections to this server check box is selected.

  7. Close the Server Properties dialog.

ClosedTo enable the TCP/IP protocol

  1. Open the SQL Server Configuration Manager software.

  2. Expand the SQL Server Network Configuration node.

  3. Select Protocols for MSSQLSERVER.

  4. In the right-hand pane under Protocol Name, select TCP/IP.

  5. In the Toolbar Menu, select Action.

  6. Select Enable.

Configuring the Client

The BarTender System Service running on the server requires access to the SQL Server. For the BarTender System Service to communicate with a remote SQL Server, you will need to set up an account that has Read/Write and Create Database access to the SQL Server.

ClosedTo set up or change the BarTender System Service account information

  1. From the Window's Start menu, right-click My Computer and select Manage.

  2. Expand Services and Applications.

  3. From the tree menu, select Services.

  4. Double-click BarTender System Service to launch the BarTender System Server Properties dialog.

  5. From the Log On tab, select the option for This Account.

  6. Enter the account information and password. Ensure that the account has Read/Write access to the SQL Server.

  7. At the bottom of the dialog, select Apply.

  8. From the General tab, click the Stop button.

  9. Once the service has stopped running, select the Start button to restart the BarTender System Service.

  10. Click OK to close the dialog.

ClosedTo connect to the remote database

  1. From the Windows Start menu, select BarTender, then System Database Setup to launch the BarTender System Database Setup dialog.

  2. Click the System Database Setup Wizard button.

  3. On the System Database Setup Wizard "Welcome" page, click Next.

  4. Enable Connect to an existing database and click Next.

  5. Specify the Database Server name by either entering it in the text box or browsing to it using the Browse button.

  6. Select the authentication type. If using SQL Server Authentication enter a login name and password. Click Next.

  7. Select to use an existing BarTender System Database or to create a new one, and click Next.

  8. If you are creating a new database, enter a name. The default name is BarTender. Click Next.

  9. Click Setup and Finish when prompted.