Open topic with navigation

Connecting to a Remote Database

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

ClosedDefining the SQL Server Authentication Method

The authentication method defines the security credentials that are used when you connect to a remote database. The following authentication modes are available when you connect to the BarTender System Database:

ClosedSetting Up the BarTender System Database for Remote Connection

Configuring the Server

For BarTender to communicate with a remote BarTender System Database instance, you must enable remote access and the TCP/IP protocol on the host database.

ClosedTo enable remote access

  1. Start the Microsoft SQL Server Management software.

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

  3. In the Server Properties Select a Page pane, click Security.

  4. Under Server Authentication, select the type of authorization that you want, as follows:

    • Windows Authentication: Specifies that the connection is made by using a local user account that has the correct read, write, and create database permissions.

    • SQL Server Authentication: Specifies that the connection is made by using a SQL Server Authentication user name and password that are defined during the SQL Server installation process. SQL Server performs the authentication by determining whether a SQL Server account is configured and whether the specified password matches the one that was previously recorded.

  5. In the Server Properties Select a Page pane, click Connections.

  6. Under Remote server connections, make sure 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. Start 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, click TCP/IP.

  5. In the Toolbar menu, click Action.

  6. Click Enable.

Configuring the Client

The BarTender System Service that runs on the server requires access to the SQL Server. For the BarTender System Service to communicate with a remote SQL Server, you must configure an account that has Read/Write and Create Database access to the SQL Server.

ClosedTo configure or change the BarTender System Service account information

  1. In the Windows Search field, enter Services, and then click the link for the Services app.

  2. In the Services dialog, double-click BarTender System Service to open the BarTender System Service Properties dialog.

  3. Click the Log On tab, and then click to select This Account.

  4. Enter the account information and password. Make sure that the account has Read/Write access to the SQL Server.

  5. Click Apply.

  6. Click the General tab, and then click Stop.

  7. After the service is stopped, click Start to restart the BarTender System Service.

  8. Click OK to close the dialog.

ClosedTo connect to the remote database

  1. In Administration Console, click System Database to open the System Database page.

  2. Click the System Database Wizard link.

  3. On the Welcome page of the wizard, click Next.

  4. On the Select Database Type page, click to select Customize connection settings, and then click Next.

  5. On the Select Database Server page, enter the name of the server that you want in the Server Name field, and then select the authentication type that you want in the Authentication list. If you select SQL Server Authentication, provide a user name and password. Click Next.

  6. Complete the remaining wizard pages.