I have just installed Sybase ASE 12.0 locally and cannot seem to get any access. If I try and access the DB server through Sybase Central, I can start the server, but when asked for a login name, password and server name, the default 'sa' combo is not accepted, and furthermore, there is no servername in the dialogue box and I cannot enter one manually.
If I try and access the DB from a 3rd party client (Ms-ISQL in my case), I get told that the server cannot be found or does not exist.
Sybase Central picks the Server name entry from the interfaces(UNIX) or sql.ini(Windows) file. If there ain't any entry for the server that you are trying to connect then it won't show up in the drop down list.
You can reset the sa password on ASE by using the -p switch. Simply type -p sa in a new line in your RUN SERVER file and start the server using the updated RUN file. You should have a new password for sa login in your errorlog.
Starting from ASE 11.9.2, you cannot use the Microsoft supplied ISQL to coonect to ASE.