Starting XP Server after initial installation
24 Adaptive Server Enterprise
Starting XP Server after initial installationIf you install Adaptive Server and XP Server in the same build session, srvbuild
automatically adds information about the XP Server to the sysservers table of
Adaptive Server. If you install XP Server in a different build session than the
Adaptive Server installation, you are prompted during the XP Server
installation process to supply the name of the related Adaptive Server and the
System Administrator’s name and password. This information is required by
Adaptive Server to start XP Server.
If you do not supply this information during the installation process, XP S erver
cannot run. When you execute an extended stored procedure (ESP), you see an
error message similar to the following:
Msg 11018, Level 16, State 1:
Procedure 'xp_cmdshell', Line 2
XP Server must be up for ESP to execute.
To add this required information to the sysservers table manually, enter:
sp_addserver servername_XP, NULL, servername_XP
where servername is the name of the Adaptive Server.
Stopping serversOnly the System Administrator has permission to issue a shutdown command.
Using a shutdown command minimizes the amount of work that automatic
recovery needs to do when the servers are restarted.
The preferred method of stopping Adaptive Server or Backup Server is to use
the Transact-SQL shutdown command. For Monitor Server, use the
sms_shutdown command.
Stopping Adaptive Server
To shut down Adaptive Server:
1Use
isql to log in to an Adaptive Server account with System
Administrator privileges:
isql -Usa -Ppassword -Sserver_name