Solved

Problem with Export Navison SQL license

Posted on 2010-08-24
2
1,555 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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

726 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