Solved

how to rename Sybase ASE on Windows ?

Posted on 2009-04-15
3
1,044 Views
Last Modified: 2012-05-06
I need to rename an existing instance, it is running on a Windows Server 2003 box. We are using this version: "Adaptive Server Enterprise/12.5.0.3/EBF 11449 ESD#4/P/NT (IX86)/OS 4.0/rel12503/1939/32-bit/OPT/Sat Sep 20 22:28:57 2003"

I know the usual Sybase steps involved in this task (change Run file, change sql.ini, do drop/add server) but I am unfamiliar with the widows specific parts of the task. For example are registry changes needed & how to change/create a new windows service ?

Andy
0
Comment
Question by:IDCSSupport
3 Comments
 
LVL 14

Assisted Solution

by:Jan_Franek
Jan_Franek earned 50 total points
ID: 24148326
I haven't seen Windows ASE for a while but as far as I remeber, the name of Windows service and name of run file is not important. So I would just change server name in run file, sql.ini and drop and add 'local' remote server in ASE.
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 200 total points
ID: 24166243
Sybase ASE on Windows runs mostly out of the registry. If you're starting/stopping ASE as a service, the RUN_SERVER file is ignored. However I think the Windows version actually lets you rename a server...? I don't have one installed right now on my laptop so I can't check.

You're correct about what you'd normally have to do under UNIX, but the Windows registry complicates things.

That said, if you do all those things, you can still start ASE through the RUN_SERVER file. You won't be able to stop it as a service, and you have to keep open the command prompt window you launched the RUN_SERVER in else ASE dies! :)

Also that is an old and unreliable version to be running. If you have to be on ASE 12.5.x then 12.5.4 with the latest patch/EBF is the place to be. Of course, all 12.5.x support ends this year on December 31.
0
 

Author Closing Comment

by:IDCSSupport
ID: 31570427
Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question