The installation takes these steps:
SQL.INI file
sybase_sql and sybase_rep. Make both accounts
member of the local Administrators group. This is at least needed during
installation, because they will install the services. (Actually, it is needed later too, because the SQL server will start up the XP server, and only administrators are allowed to start services). Think up good passwords
(don't delay that until later, do it now) and write them down .
Unselect the "User must change password at next logon" and select "Password
never expires".
sybase_sql account and install your
server as usual. Choose a path that is meaningfull for the SQL server. (I
used c:\etc\srvapp\ASE ). This is a pretty straigtforward
process, and most readers will have done this before (Replication server is
not normally installed by unexperienced DBA's...)
Go to the control panel, choose services and select "Sybase SQLServer_APOLLO" (assuming
your server is named APOLLO). Click on the "startup" button. In this dialog
you can set how the service starts. Leave the startup type to manual for now
(you'll have to reboot a few times). Set the "Log On As" option to "This
Account", and fill the correct username (sybase_sql)
Repeat this step for the Backup server, the Monitor server, the Historical server, and the XP server.
do this while logged on as sybase_sql
If the system search path includes the SQL binaries or DLL's, problems will occur with the Replication server... Go to the control panel, choose "System" and select the "Environment" tab. Change the following entries:
c:\etc\srvapp\ASE\bin and
c:\etc\srvapp\ASE\dll from the system path. (it makes no sense
moving them to the user path, because this doesn't seem to work when a
service logs in. Maybe this is a NT bug, or a feature :-)
move all files in the c:\etc\srvapp\ASE\dll directory
to the c:\etc\srvapp\ASE\bin directory. Because the path will
not get set correctly, this is the only way they will be found... (Yes I know
this is a dirty trick, but I don't know any other way. This is the only trick
I had to use)
sybase_rep. Install the Replication server in a
normal way (Note: your Sybase server has to be running). The installation
program probably defaults to the same directory where the SQL server is
installed. Choose another directory! You might have to insert your Sybase
SQL server in the SQL.INI file. (they use different interfaces
files.) (I choose c:\etc\srvapp\repserver ). The
installation program wants you to install a RSSD (Replication Server System
Database) on your SQL server. You can do this in advance. Don't forget to
write down all userids and passwords!
sybase_rep)
do this while logged on
as sybase_rep
Change the following entries:
c:\etc\srvapp\repserver\bin and c:\etc\srvapp\repserver\dll
from the system path.
move all files in the c:\etc\srvapp\repserver\dll directory to
the c:\etc\srvapp\repserver\bin directory.
Start regedt32.exe (using Start -> RUN. There is no icon for
it). Open the window HKEY_LOCAL_Machine On Local Machine . Go
to the following path: SYSTEM -> CurrentControlSet -> Services
and browse down until you are at SYBREP_APOLLO_RS (assuming
your Replication server is named APOLLO_RS). Select this service and choose
"Add Value" from the "Edit" menu. Add a value of type REG_MULTI_SZ
named DependOnService . Fill in the name of the service
for the SQL server (it is near the service of the replication service). It
will be something like SYBSQL_APOLLO
SQL.INI file
SQL.INI file in the SQL server
directory so it contains the entry for the replication server. Then edit both
the startup files of the replication server:
Edit the batch file in c:\etc\srvapp\repserver\install. Change
the -I option to reflect the new path.
Open the registry editor and go to HKEY_LOCAL_MACHINE -> SOFTWARE ->
SYBASE -> Server -> APOLLO_RS -> Parameters. Edit the value of Arg3
to the new path.