Startup/shutdown of Sybase database server under Windows

Starting, shutting down the Sybase database server First, start Sybase Server

Two methods are introduced under Windows to start the Sybase database server.

1. Through Server Manager

Open Control Panel > Administrative Tools > Service Management window. Dragging the scroll bar to the service name that starts with Sybase typically finds 5 services: Sybase SQL Server _ <servername>, Sybase bckserver _ < ServerName>_bs, Sybase monserver _ <servername>_ms, Sybase Unified Agent, Sybase xpserver _ < servername>_xp.

In general, you can start the primary service (SQL Server) and the backup service (bckserver). Monitoring Services (Monserver) is turned on when you need to monitor Sybase performance. The extended Stored procedure Service (Xpserver) is opened by the primary service (SQL Server) as needed, and Xpserver cannot be started manually.

On the Sybase SQL Server _ RUSKYPC service item, right-click and select Start to start the Sybase master server. The boot process for the backup service Sybase bckserver _ Rusky_bs is similar.

2. Through net start Command

You can also start the Sybase home Server and the backup server from the command line under Windows. net start syntax is: net start [service]

You need to know the service name in the above command to execute the command. The service name for the Sybase Master service is service_name:sybsql_<servername>. where servername is the configured Sybase server name. If you configure the Sybase service name to test, you can do so by Sybase master service and backup service. The servicename can be found through the Service Manager---Right-click---properties: You can see the service name.

net start Sybsql_test

net start Sybbck_test_bs

ii. closure of Sybase Server

There are four ways to turn off Sybase services

1. Service Manager

Open Control Panel > Administrative Tools > Service Management window. Locate the primary service and backup service for Sybase. On the service name Sybase SQL Server _ <servername> and Sybase bckserver _ <servername>_bs respectively, right-click the stop to close the service. If the status column next to the corresponding service name is empty, the service has stopped successfully.

2, in isql medium-use shutdown Command

Use the command-line utility isql to connect to the Sybase server and execute shutdown to close.

C:\users\administrator>isql-usa-sruskypc
Password:
1> Sthutdon
2> Go

Note: You can use the shutdown with nowait command in an emergency or unexpected situation.

3. Using net stop command to close Sybase Service

The syntax for net stop is:net stop service

The service name for the Sybase Master service is:sybsql_<servername, and the service name for the backup service is:sybbck_<servername>_bs, The monitoring service is:sybmon_<servername>_ms for the corresponding service name. The commands executed at the command prompt are:

net stop Sybsql_test

net stop Sybbck_test_bs

net stop Sybmon_test_ms

4. Using Sybase Central Close Sybase Service

In Sybase Central, right-click on the connected server and select "Close", and when you choose to close "Servername:port" immediately, click "Yes" to close Sybase's main service.

Third, check the connection with the server

1. Using isql perform a quick test

At the command prompt, enter: Isql-usa-p<password or leave it blank>-Sserver_name

Where server_name is the name of the Adaptive server.

Note: When you log on to Adaptive Server for the first time, you can use the default "SA" username and the password is empty. After you log on for the first time, you should change the password for the system administrator.

If the login succeeds, the isql command prompt is displayed. To display the Adaptive Server version number, at the isql prompt, enter:

1> SELECT @ @version

2> Go

The Adaptive Server version number is displayed. The output should show that the version of Adaptive Server is 15.0.7.

2. Connect to Adaptive Server via Sybase Central

Sybase Central provides a graphical user interface where you can perform Adaptive Server administrative tasks. The Sybase central interface displays a hierarchical list of servers in the left pane, and a list of details for the selected server in the right pane. To select a server, click its icon in the left pane.

• 1 from the Windows taskbar, select Start | Program "|" Sybase "|" Sybase Central ".
• 2 in the left pane, click the server that you want to connect to.
• 3 in the Login window, enter the user name and password for the system administrator. You must be logged on as a system administrator to perform administrative tasks.
• 4 Click OK.

Note: When you log on to Adaptive Server for the first time, you can use the default "SA" username and the password is empty. After you log on for the first time, you should change the password for the system administrator. The Adaptive server plug-in for Sybase Central does not display all the servers listed in the Sql.ini file. Sybase Central lists only those servers that were previously connected, or lists those servers that were started as Windows services.

Four, set the system administrator password

When you install the Sybase software, a user account named "sa" is created for the Sybase system administrator. Users who are logged on as "sa" can use any database on Adaptive server, including the master database, and have full permissions. the "SA" account does not have a password when a new installation has just been completed. The initial default value for the password is: NULL. in a production environment, Sybase system administrators should always use a non-default password.

The Sybase system administrator should log on to the new Adaptive Server as "sa" and use sp_password to set the password:

%sybase%\%sybase_ocs%\bin\isql-usa-p-Sserver_name

1> sp_password NULL, New_password

2> Go

where "null" is the default password, New_password is the password assigned to the "SA" account. For maximum security, Sybase recommends that you set a password that contains at least eight characters, combined with uppercase and lowercase letters and numbers.

1. Using isql perform a quick test

At the command prompt, enter: Isql-usa-p<password or leave it blank>-Sserver_name

Where server_name is the name of the Adaptive server. server_name can be viewed through%sybase%\ini\sql.ini.

Note: When you log on to Adaptive Server for the first time, you can use the default "SA" username and the password is empty. After you log on for the first time, you should change the password for the system administrator.

If the login succeeds, the isql command prompt is displayed. To display the Adaptive Server version number, at the isql prompt, enter:

1> SELECT @ @version

2> Go

The Adaptive Server version number is displayed. The output should show that the version of Adaptive Server is 15.0.7.

2. Connect to Adaptive Server via Sybase Central

Sybase Central provides a graphical user interface where you can perform Adaptive Server administrative tasks. The Sybase central interface displays a hierarchical list of servers in the left pane, and a list of details for the selected server in the right pane. To select a server, click its icon in the left pane.

• 1 from the Windows taskbar, select Start | Program "|" Sybase "|" Sybase Central ".
• 2 in the left pane, click the server that you want to connect to.
• 3 in the Login window, enter the user name and password for the system administrator. You must be logged on as a system administrator to perform administrative tasks.
• 4 Click OK.

Note: When you log on to Adaptive Server for the first time, you can use the default "SA" username and the password is empty. After you log on for the first time, you should change the password for the system administrator. The Adaptive server plug-in for Sybase Central does not display all the servers listed in the Sql.ini file. Sybase Central lists only those servers that were previously connected, or lists those servers that were started as Windows services.

3. Set the system administrator password

When you install the Sybase software, a user account named "sa" is created for the Sybase system administrator. Users who are logged on as "sa" can use any database on Adaptive server, including the master database, and have full permissions. The "SA" account does not have a password when a new installation has just been completed. The initial default value for the password is: NULL. In a production environment, Sybase system administrators should always use a non-default password.

The Sybase system administrator should log on to the new Adaptive Server as "sa" and use sp_password to set the password:

%sybase%\%sybase_ocs%\bin\isql-usa-p-Sserver_name

1> sp_password NULL, New_password

2> Go

where "null" is the default password, New_password is the password assigned to the "SA" account. For maximum security, Sybase recommends that you set a password that contains at least eight characters, combined with uppercase and lowercase letters and numbers.

Startup/shutdown of Sybase database server under Windows