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).
2. Go to Properties of your shortcut – go to your Desktop, find the shortcut, right click on it, and select 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.
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: