Restart Microsoft SQL Server

You may be asked to restart Microsoft SQL Server after an Acctivate installation or upgrade.  Please use the following procedure to safely restart the database service.

First, make sure that all connections to the SQL Server are closed.

  • Verify that everyone has closed Acctivate using the View Current Users tool
  • Stop processing shipments in an integrated shipping workstation (e.g., UPS WorldShip)
  • Exit the Acctivate Mobile software on all mobile warehouse devices

Then, restart the service on the computer running Microsoft SQL Server.

  1. Type SQL Server Configuration Manager in the Windows Start Menu search and select the first item in the “Programs” section
  2. Click SQL Server (ACCTIVATE) in the list on the right (see below)
  3. Click the Restart service button in the toolbar
  4. A Stopping service… pop-up message should appear, followed by the Starting service… message.
  5. Confirm that the State is “Running” again

More Information regarding the SQL Server Configuration Manager tool is available at Microsoft.com.

Posted in Database, Installation - Last modified on September 10, 2015Cassandra Creasy
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.