Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community

Migrating Navision 3.1 to SQL 2005

rated by 0 users
This post has 5 Replies | 2 Followers

Not Ranked
Posts 8
Points 240
Member since 01-27-2003
dlombardozzi Posted: 09-22-2007 0:17

Hi,

 

We are currently running Navision 3.1 against a Windows 2000 server running SQL 8.0. We are upgrading the server hardware and would like to upgrade to SQL 2005 at the same time. The new server is a 64bit machine running Windows 2003.

 

I would like to avoid visiting the desktops at this time to update the Nav clients to a newer (5.0) version, and I’m hoping there is way to make this work.

 

When I try to create a new database using the 3.1 client, I get the error message:

“The ALL permission is deprecated and maintained only for compatibility….”. SQL does create the database files, but they are removed when I click OK in response to the Navision error message?

 

Any help or ideas appreciated!

 

Regards,

Doug

Doug L.
Top 10 Contributor
Male
Posts 1,363
Points 17,805
Member since 01-23-2004
DynamicsNAVMVP

Version 3.1 is not supported on SQL Server 2005. You will need to upgrade your exe's to at least 4.0 SP1, and it is recommended to go all the way up to 4.0 SP3, and apply update 6 to it.

Top 10 Contributor
Male
Posts 1,407
Points 46,614
Member since 06-05-2005
Moderator

DenSter:

Version 3.1 is not supported on SQL Server 2005. You will need to upgrade your exe's to at least 4.0 SP1, and it is recommended to go all the way up to 4.0 SP3, and apply update 6 to it.

Daniel was referring client upgrade, you can maintain objects from NAV 3.1.

Nuno Maia
Not Ranked
Posts 8
Points 240
Member since 01-27-2003
Hi Nuno,  Your saying my 3.1 objects do not have to change, but I have to upgrade the client application on each machine to the latest version? Regards,
Doug

 

Doug L.
Top 10 Contributor
Male
Posts 1,407
Points 46,614
Member since 06-05-2005
Moderator

Yes, must upgrade in all workstations.

Nuno Maia
  • | Post Points: 30
Top 10 Contributor
Male
Posts 5,421
Points 67,563
Member since 04-12-2001
DynamicsNAVMVP
Moderator
SystemAdministrator

dlombardozzi:
Hi Nuno,  Your saying my 3.1 objects do not have to change, but I have to upgrade the client application on each machine to the latest version? Regards,
Doug

 

 

 

Try this link, it explains what is involved:

 http://wiki.dynamicsbook.com/index.php?title=NAV_technical_upgrade

 

David Singleton - MVP Dynamics NAV Dynamics NAV Consultant since 1991 Available for Navision Go-Live assistance
Dynamics Book
  • | Post Points: 5
Page 1 of 1 (6 items) | RSS


Copyright Dynamics User Group, 1995-2009, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.