Solved

Problem with Export Navison SQL license

Posted on 2010-08-24
2
1,529 Views
Last Modified: 2013-11-23
Hello,

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




0
Comment
Question by:atysxx
2 Comments
 
LVL 14

Expert Comment

by:Dhanasekaran Sengodan
ID: 33509349
0
 

Accepted Solution

by:
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

0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
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
Via a live example, show how to shrink a transaction log file down to a reasonable size.

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now