My requirement is to create a named instance, while there is a default instance running on the same machine and connect to it, through some kind of management console or command line.
I created a firebird 2.5 second instance using
instsvc install -auto -superserver -guardian -name secondservice
instsvc start -name secondservice
This created the engine service and guardian service and was confirmed running using firebird control centre and through services window.
However I am unable to connect to the instance using ibo console when I put the parameters to host name as localhost/secondservice, nor can I cannot to it through isql using
isql localhost\secondservice:employee
I downloaded the zip file through http://downloads.sourceforge.net/project/firebird/firebird-win32/2.5.4-Release/Firebird-2.5.4.26856-0_Win32.zip
Would anyone have any idea what is missing?
Firebird doesn't have a concept of named instances like SQL Server. If you want to run a second instance, then the firebird.conf file of that instance must have a different value for the configuration option RemoteServicePort (which defaults to 3050), and you need to specify that port number when connecting (say you configured the port on 13050):
isql localhost/13050:employee
Running multiple instances of the server, also requires you to have separate installations for each instance.