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! Stick out tongue

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.