Sybase Adaptive Server, Руководство по настройке

Страница: 40 / 150

Starting XP Server after initial installation
24
Adaptive Server Enterprise
Starting XP Server after initial installation
If 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 Server
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 servers
Only 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:
1 Use
isql
to log in to an Adaptive Server account with System
Administrator privileges:
isql -Usa -P password -S server_name