IBM Support

Newly created SQL Anywhere service cannot be started if SQL Anywhere has NOT been installed to the default path C:\program files\rational

Troubleshooting


Problem

Run a newly created SQL Anywhere® network service after install may give the following error: ”A database server with that name has already started.” The service then fails to start.

Resolving The Problem

This sequence leads to the problem in IBM® Rational® TeamTest and other Rational testing tool products:

  1. Install SQL Anywhere Database Server to the path "D:\rational" on Microsoft® Windows® 2000 SP2.
  2. Once installation is finished, launch Sybase Central and create a new service, name the service Newsql.
  3. Click Next three times to accept the defaults.
  4. Type the following commands in the parameters window (where for this example the server name is "jhsql"):
    -x tcpip
    -n jhsql
    -gd all
  5. Click Next three times and select the checkbox to start the service immediately. This message appears:
    ”A database server with that name has already started.”
  6. Click Finish and note that the service cannot start.

There is no such issue if SQL Anywhere is installed to the default path of
C:\program files\rational.



If you encounter this issue, follow these steps:
  1. In Sybase Central, use the right mouse button to click on the service name and choose “Properties”
  2. Click the Configuration tab and change the server name specified using the “-n” parameter to a different name
  3. Click "Apply" and "OK" to change the close the dialog.
  4. Right-click on the service name and select “Start” to start the service



[{"Product":{"code":"SSSHTR","label":"Rational TeamTest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.13;2003.06.14","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSSHVH","label":"Rational TestManager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSSHDX","label":"Rational Robot"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSSHRJ","label":"Rational Suite TestStudio"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

More support for:
Rational TeamTest

Software version:
2003.06.13, 2003.06.14

Operating system(s):
Windows

Document number:
337417

Modified date:
16 June 2018

UID

swg21196366

Manage My Notification Subscriptions