Connect to Dynamics NAV database with one click (Desktop Shortcut)

If you are using mostly RoleTailored Dynamics NAV client, then this tip will not be that helpful. If, however, you are like me, and you are still use Dynamics NAV Classic client a lot, then you will love this tip!

A few days ago I noticed that my colleague, whenever connecting to the TEST/DEVELOPMENT databases was using different desktop shortcuts. Instead, of starting Dynamics NAV client, clicking File > Database > Open, selecting the right database and connecting, he was achieving same result with just one click (ok, ok… one double-click!). Now, I know, this is an old trick (and possibly, everyone uses it, or at least tried using it in the past), but… when I counted how many times per day I was loging in to Dynamics NAV and selecting a different database, I decided that I should give the desktop shortcut one my try.

How to vcreate a desktop shortcut which would connect straight to Dynamics NAV database?

Actually, it’s quite easy, just follow these steps:
1. Create a shortcut, for finsql.exe – go to your Dynamics NAV client folder, find finsql.exe, right-click on it, select Send To > Desktop (create shortcut).
Dynamics NAV Desktop Shortcut - Send to desktop

2. Go to Properties of your shortcut – go to your Desktop, find the shortcut, right click on it, and select Properties.
Dynamics NAV Desktop Shortcut - Properties

3. Define connection string in Target field – go to the end of the “Target” field and type in your connection details in the format: SERVERNAME=Your Server Name, DATABASE=Your Database Name, COMPANY=Your Company Name, NTAUTHENTICATION=1.
Dynamics NAV Desktop Shortcut - Target Property

So, my “Target” property would have a value of:

"C:\Program Files\Microsoft Dynamics NAV\60\Classic\finsql.exe"
SERVERNAME=TOMASZNC6320, DATABASE=Demo Database NAV (6-0),
COMPANY=CRONUS UK Ltd.,NTAUTHENTICATION=1

where NTAUTHENTICATION=1 means, that shortcut will use my Windows Login to connect to the database.

4. Click OK. And that’s it!

Now, if you would double-click on the shortcut, it will automatically connect to your database. File > Database > Information:
Dynamics NAV Desktop Shortcut - Connected

Result!

Technorati Tags: , , ,

This entry was posted in Dynamics NAV / Navision, functionality and tagged , , , . Bookmark the permalink.

4 Responses to Connect to Dynamics NAV database with one click (Desktop Shortcut)

  1. Cristian says:

    Hi,

    Would you have the same tips but for Dynamics NAV 2013 ?
    Thanks,
    Cristian

  2. Muthukumar says:

    Dear All,

    I Require shortcut icon company wise for NAV 2013 single database.

    Someone help me on this.

    Regards,
    Muthu

  3. Raik says:

    This doas also works with 2013. Don’t use a space after comma.

    “C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client\finsql.exe” servername=LOCALHOST\NAVDEMO,database=Demo Database NAV (7-1),ntauthentication=1

  4. Jason says:

    Hi,

    Is it possible I can preset the username in the shortcuts too?

    Thanks.

Leave a Reply to Cristian Cancel reply

Your email address will not be published. Required fields are marked *