Navision 3.6 DB Restore

mmcbratn

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?

fb

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

I didn't realize there was anything in the master database that I needed to restore as well.

I'll do that.