Solved

Problem with Export Navison SQL license

Posted on 2010-08-24
2
1,548 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

749 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