Upgrade SQL Server 2008 to SQL Server 2008 R2 Problem

sonythan

Hi,

I tried to upgrade the database ini my laptop from SQL 2008 to SQL Server 2008 R2.
The data migration process all running well.
But the problem is when i want to connect the NAV 5.0 (SP1) the error appear just like in my attachment.

Thank you In Advance

mohana_cse06

Make sure that your build is compatible with SQL 2008 R2..
http://blogs.msdn.com/b/german_nav_developer/archive/2010/03/05/zusammenfassung-der-betriebssysteme-die-von-microsoft-dynamics-nav-unterst-tzt-werden.aspx

mohana_cse06

this error seems to be a NAV DB upgraded..
When we try to open database with lower version this error appears..
make sure that you are trying to open with right NAV version..

sonythan

The problem appear when i try to restore the database using backup restore SQL server (from 2008 to 2008 R2). There are no problem at all when i restore it to R2.
But when I used backup restore from NAV no problem at all. So i think there are no compatibility issue NAV 5.1 (SP1) and SQL Server 2008 R2.
I think the problem is from backup 2008 database (using backup SQL 2008) and restore it to 2008 R2 (using restore SQL 2008 R2). From the SQL Server view there is no problem but from NAV view there is a problem.


Soni

sonythan

Additional Information:
I'm using Windows 7 64 bit (Ultimate Edition) and SQL Server 2008 R2 64 bit (Standard Edition)

Soni

max_hl

1. Detach database on SQL 2008
2. Copy database files (mdf, ndf, log) to path accessible from SQL 2008 R2
3. Attach database to SQL 2008 R2
4. Change database version to 100
5. Transfer SQL logins from SQL 2008 to SQL 2008 R2

If u're using v.5 NAV client, do not forget to set trace 4616 flag on SQL 2008 R2 instance
I had working v. 4SP3 client on SQL 2008 R2 with trace flag