How to Install Sybase ASE 11.5 on Windows 2003

Recently, we installed Sybase ASE 11.5 on Windows 2003 for one of our projects need. Installation seems to run smoothly without any problems and creating an adapter server after that is also successful. But when we tried to start the server using Services (Administration Tools>Services) or using Sybase Central, the server is failed to start as a service.

After doing some searching and ‘googling’, I found that this step-by-step workaround is our savvier and we managed to start the server using Services & Sybase Central. The only problem is that we cannot configure the server using Sybase Utility sybconfig.exe. But it is 'okay' for us and case closed!

Step-by-step workaround

1) Download the "Windows Server 2003 Resource Kit Tools"

2) Install the "Windows Server 2003 Resource Kit Tools" into a directory like "c:\reskit".

3):\Program Files\Windows Resource Kits\Tools>cd \reskit

3) Remove the existing SQL Server service using the following command.
c:\reskit> INSTSRV YourSQLServerServiceName REMOVE
upon successful, message 'The service was successfully deleted!' will appear

4) Install the SQL Server service using the "INSTSRV" utility command
C:\reskit>instsrv YourSQLServerServiceName C:\reskit\srvany.exe
Upon successful, message 'The service was successfuly added!

Make sure that you go into the Control Panel and use the Services applet to change the Account Name and Password that this newly installed service will use for its Security Context.' will appear.

5) In the Registry Editor window, go to HKEY_LOCAL_MACHINE | SYSTEM | CurrentControlSet | Services and click your SQL Server service name).
a. Add a new key by selecting Edit | New | Key. Enter "Parameters" as the Key name.
b. Click Parameters and add a new string value by selecting Edit | New | String Value. Enter "Application" as the new String value.

c. Double-click Application. The Edit String dialog box appears. In Value Data field, enter:
c:\sybase\bin\sqlsrvr.exe -C -SYourSQLServerName -IC:\sybase\ini

6) Select Control Panel | Services. Click , then click Startup.