View source for How to stop and start the Sybase service

=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. 

[[image:Services1.png]]

[[image:Services2.png]] 

[[image:Services3.png]]

[[image:Services4.png]]

<br style="clear: both" />

= 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 ===


[[image:Service71.png]]

<br style="clear: both" />

=== How to Start the Sybase service ===

[[image:Service72.png]]


<br style="clear: both" />

==CMS 8.0 or later==
=== How to Stop the Sybase service ===

[[image:Service81.png]]

=== How to Start the Sybase service ===

[[image:Service82.png]]


<br style="clear: both" />