access to multiple instances on same SQL server

fabio78

Hi all,

I've installed two instance on same SQL Cluster Server named
Instance1
Instance2

how can I access to instance2 in easily way? I've tried with success:
clusterResource\instance2, port number
but I think that it is very difficult for user to enter entire string, including the port number...

There is another way? Or I've installed SQL cluster not properly?

Thanks, fabio.

stryk

Hi!

To make it more convenient for your users to access these instances you could define separate NAV shortcuts for each server:

Shortcut 1: finsql.exe servername=instance1, database=database1, id=1.zup
Shortcut 2: finsql.exe servername=instance2, database=database2, id=2.zup

If the NAV client is always installed into the same/standard folders, you could create such shortcuts and then just copy them to the users' desktops ...