Tip of the Week #189 – Problems Opening a Customer Database in the NAV 2009 Classic Client
Developer Peter Tijsma has some helpful advice for those running older versions.
What if you cannot open a Customer database in the NAV 2009 Classic Client?
Sometimes you encounter strange messages like this when opening a NAV 2009 database on SQL Server:
In this example, we received a database from a customer and we restored this on our local SQL Server.
The thing is that there’s already a license stored in the database and a locally selected Partner license did not work to open the database.
If this happens, there’s still a way to open it. The trick is to import the partner license directly on SQL level.
The steps to do this:
- Open SQL Server Management Studio
- Right-click the SQL Server and select “New Query”
- In the query window that appears type in the following line:UPDATE [CustomerDB (9-0)].[dbo].[$ndo$dbproperty] SET [license] = (SELECT * FROM OPENROWSET(BULK N’C:\Temp\License\Partner License.flf‘, SINGLE_BLOB) as license)
- Replace ‘CustomerDB (9-0)’ with the your database name
- Replace ‘C:\Temp\License\Partner License.flf’ with the path to your partner license
- Press ‘F5’ to run the script
Once executed, it will have imported your license into the database and you’ll be able to open the database with your NAV 2009 Classic Client (finsql.exe).
Thank you Peter!