Specifications

© 2015 Digital Monitoring Products
The user should contact the database administrator to find the correct options. If SQL Server
Authentication is chosen, a User Name and Password must be provided. This is the SQL username and
password, not the Remote Link username and password.
The login screen will appear the first time the user runs Remote Link with SQL Server or anytime the
SQL username or password is changed by the administrator. After a successful login the user will not
be prompted again unless something changes on the database side.
For users of Remote Link in mission-critical applications (such as central station monitoring), it is
recommended that an experienced SQL Server administrator performs setup and administrative
duties. This includes initial setup, firewall configuration, database replication, backup, repair, and
other site specific configuration.
When using Link with SQL Server, all backup and repair operations must be performed by the database
administrator, using SQL Server management tools. Remote Link does not perform these operations.
When using Link with the built-in database engine, or with Link Server, Link can still be used to
perform database backup and repair operations.
The database administrator should create an empty database.
Any user created to be used for SQL Server authentication must have permission to read, write,
modify and delete all tables.
An ODBC Data Source will need to be created to allow Link to connect to the new Link database. For
more information, go to Setting up ODBC Data Source.
To use Remote Link with Microsoft SQL Server, a ODBC Data Source must be set up on the user's
machine.
Add a System DSN for SQL Server.
1. For Windows XP: Start > Settings->Control Panel > Administrative Tools > Data Sources
(ODBC) to open ODBC Data Source Administrator.
For Windows 7: Start >Control Panel > Administrative Tools > Data Sources (ODBC) to open
ODBC Data Source Administrator.
2. Select System DSN tab.
3. Press Add...
4. In Create New Data Source window, select 'SQL Server', then press Finish
5. In Create a New Data Source to SQL Server window
a. Give the data source a Name and Description. Make note of the name you assign.
b. Select the server from the dropdown.
IMPORTANT: If you are running SQL Server Express, add \SQLEXPRESS to the end of the
server name. It may also be necessary to add the port 1433 at the end of the name. For
example 'MY_SERVER_NAME_OR_IP_ADDRESS\SQLEXPRESS,1433'