Tip #9 – Gain access to a database without a password

This Blog Article was brought forward from my old blog

Update 2014 : For the latest version of Dynamics NAV, this still works but you need other tables.

This is often an issue when you get a SQL Backup from a customer to analyse.

Off course you can create a user on SQL and change the password, but it is easier.

Navision stores the users into two tables. User and ‘Windows Login’, The first table is for database logins, the latter for Windows Logins.

When you delete all records from both tables Navision will no longer ask for passwords and allowes blank access.

So to all end users: Protect your backupfiles!