Sybase DC35823-01-1500-04 manual Starting XP Server after initial installation, Stopping servers

sms_shutdown

Starting XP Server after initial installation

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

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

24 Adaptive Server Enterprise