Navision 3.6 DB Restore

mmcbratn
mmcbratn Member Posts: 3
edited 2005-03-14 in Navision Attain
Hey there, wondering if somebody can help me out.

I currently have Navision 3.6 with SQL Server 2000. I backup the database each day by doing a backup from Sql Server Enterprise Manager.

I need to restore one of these backup that I've made. So I have a new server, I"ve installed Sql Server 2000 on it, and created a new database (same name as before), restored the database, however now when I try to connect to it with the client, I"m getting license file errors. Its saying that I can only have 0 nondemonostration companies. I've looked at the old server and the license file ( the fin license) and have put it in the same spot on the new server, but I don't seem to be getting anyway. Has anybody ever done a successful restore of the database before?

Am I missing something that I have to do with the license file?

Comments

  • fb
    fb Member Posts: 246
    Sounds to me like your new server has the 'demo' license installed (CRONUS.flf) instead of your production license. (The license is uploaded to the table [master.dbo.ndo$srvproperty] when the the first database is created on a server.)

    See section 3.1 - "License Files" of the Installation & System Management: Microsoft SQL Server Option document on your Product CD for instructions on how to upload your production license to your new server. (Log in with an account with sysadmin access; click on Tools, License Information on the Navision client menu; then click on the 'Upload' button...)

    You may also need to follow the instructions in section 1.2 of that document regarding the xp_ndo extended stored procedure...
  • mmcbratn
    mmcbratn Member Posts: 3
    I didn't realize there was anything in the master database that I needed to restore as well.

    I'll do that.

Categories