Chapter 3. Setting Up SQL Remote
Preparing your Adaptive Server Enterprise serverBeforeyou start Thissection assumes the following:
♦Youhave installed an Adaptive Server Enterprise server that is to contain
theSQL Remote database.
♦Youhave installed the SQL Remote software on your computer. To install
theSQL Remote software, run the setup program from the CD-ROM.
♦Youhave created a database in the Adaptive Server Enterprise server that
willtake part in your SQL Remote installation.
♦Youhave system administrator permissions on the Adaptive Server
Enterpriseserver, and database owner permissions in the database.
Ensuring TEMPDB is large enough
SQLRemote uses the TEMPDB database for the following purposes:
♦Thedatabase extraction utility used to create remote databases uses
TEMPDBto hold a temporary set of Adaptive Server Anywhere system
tables.
♦TheMessage Agent creates a temporary table called #remote when it
connectsto the server.
Forthese reasons, you should make TEMPDB larger than the 2 MB default
size. The size required depends on the number of tables and columns in your
SQLRemote installation, but a size of 10 MB is generally sufficient.
Installing the SQL Remote system objects
Fora database in your Adaptive Server Enterprise server to take part in a
SQLRemote installation, you must install a number of SQL Remote system
tables,views, and stored procedures in your database.
❖Toinstall the SQL Remote system objects
1. Locate the SQL Remote initialization script
ssremote.sql
inyour
SQLRemote installation directory.
2. Make a backup copy of the
ssremote.sql
scriptfile. Thenadd the
followingtwo lines to the beginning of
ssremote.sql
:
use database_name
go
21