Problem with Export Navison SQL license

Posted on 2010-08-24
Medium Priority
Last Modified: 2013-11-23

I'm moving an Navision 4.0 SQL database to a new server. Detached and attaced on the new server and data base is runnin.

so far so good.

If i want to open my database from my client it says that my license does not allow to open MS sql server.

So i tried to export the license file from my old server but every time i try to export it, the license file stays empty. Or i get an old license without the SQL option.

Any help is welcome

Question by:atysxx
LVL 14

Expert Comment

by:Dhanasekaran Sengodan
ID: 33509349

Accepted Solution

atysxx earned 0 total points
ID: 33732949
sorry for the late reply.
I did knew the license is stored inthe master database of the sql instance

"Table dbo.$ndo$srvproperty in Master"

Apparently NAV doen's have an option to export that table 2 another server. So this is what we did.

- dropped the tabel in a new database
- detached that database
- Attached that database in new instance  on new server
- dropped that tabel into the master database tabel.

and voila...

maybe there is a quicker way but this one worked..

thanks any why


Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question