access to multiple instances on same SQL server

fabio78
fabio78 Member Posts: 37
edited 2009-06-13 in NAV/Navision Classic Client
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.

Comments

  • stryk
    stryk Member Posts: 645
    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 ...
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool

Categories