Is there any option to change the sybase sql default port ?
Here I want to change the port number because we can't start two SAP instances at the same time on the same server?
How to change sybase sql default port
sybase
Related Question
- Parameter for Sybase Sql Anywhere 12 Serverport
- Load sybase .db into new sybase developer server
- Java Sybase Datetime Storage – How Sybase Stores Datetime Information
- Sql-server – Extra column when migrating Sybase databases to single SQL Server database
- Sybase – Non-Blocking Transaction Read Like Oracle and SQL Server 2014
- Sybase 16 SP 02 – SQL Central Overview
- Sybase errors – meaning and resolution
Best Answer
Sybase ASE retrieves port numbers for the listeners from the
interfacesfile. On *nix systems, this is typically in the Sybase Home directory ($SYBASE/interfaces)On Windows systems it's called
interfaces.iniand can be found in %SYBASE%, which is likely to be c:\sybase (I think..been a while since I've run on Windows).I believe you can launch the GUI interfaces editor through Sybase Central, if you are using that to manage your ASE databases.
dseditanddscpare the two utilities that can be used to edit the interfaces file.You can also manually edit the interfaces file using a text editor such as
vibut be sure to pay attention to the format of the entries and permissions, so as not to accidentally muck it up.