From NewHaven Software Wiki

Overview

This article details the instructions for stopping the Sybase service. PLEASE NOTE: The Sybase service is responsible for allowing CMS communication to a variety of systems, That said other programs or systems may ALSO require this service. you should only ever follow the instructions below at the request of CMS support or because another one of our Wiki articles has referred you to here.

WARNING

CRITICAL: PLEASE ENSURE NO ONE IS LOGGED INTO CMS BEFORE YOU STOP THIS SERVICE. STOPPING THE SYBASE SERVICE WILL SEVER ALL CMS CONNECTIONS AND CAN LEAD TO UNFORESEEN ISSUES IF YOU HAVE AGENTS STILL LOGGED INTO CMS.

• You can try deleting the file CMSNET.dat from the \NewHaven Software directory and, if successful, you can be sure nobody is logged into CMS. This file will be recreated the next time someone logs into CMS so there is no harm in deleting.
• Using the Manage Open Files section in Windows is another good method of determining if anyone has any related files/programs open (you'd be looking for open files in \NewHaven Software) and can also use this section to disconnect those users if needed.

How to open the Services menu

Below are instructions on how to access your Services menu in Windows. Please note there are a number of different ways to access this menu depending on what version of Windows you are running. The screen shots and steps outlined below are for Windows Server 2008, that said this method should work for all versions of Windows we currently support running CMS on.

Determine what version of Sybase you are running

The instructions below can vary a little depending on what version of Sybase you are running. Your Sybase version is dependent on what version of CMS you are running.

• CMS 7 or earlier runs Sybase version 9. Please follow the instructions below for CMS version 7 or below.
• CMS version 8 or later runs Sybase version 12. Please follow the instructions below for CMS version 8 or above.

CMS 7.0 or earlier

How to Stop the Sybase service if running CMS 7.0 or earlier

How to Start the Sybase service if running CMS 7.0 or earlier

CMS 8.0 or later

How to Stop the Sybase service if running CMS 8.0 or later

How to Start the Sybase service if running CMS 8.0 or later

Restarting just one database

It is possible to restart a single database without restarting your database server as shown above. This is valuable (and only possible) if you're running multiple databases on the same database server such as multiple companies or a production and test database.

You'll need to run the Sybase utility DBISQLC.exe, connect to one of your databases that you're not restarting, and then run the following commands:

STOP DATABASE 'TestCompany';
 
START DATABASE 'TestCompany';

In the above statements, "TestCompany" represents the name of the database you wish to restart. TestCompany also happens to be the default name given to a test database by our installer when performing a test environment install.