SQL Server 2005 64 bit on NAV 4 SP3

davmac1

Are there any outstanding problems running the 64 bit version of SQL Server 2005 with Navision?
Anyone currently running it okay in a production environment?

DenSter

Just one tip: when you install NAV, run the custom option and make sure that MSDE is NOT installed. Repeat, do NOT install MSDE. When you do a full install, this WILL be installed, even when you have SQL Server 2005 already installed.

The edition of MSDE that comes with the NAV product CD is part of the SQL Server 2000 product on 32bit, and can completely screw up your 64bit SQL Server 2005. We even had one instance where the OS failed and could not be restored.

DenSter

Oh and you have to do the extended stored procedures manually. Even when you put the dll in the right folder, NAV is hard coded to look for xp_ndo.dll, and will consequently not find xp_ndo_64.dll (IIRC). Don't forget to create an extended SP for enumusergroups as well as enumusersids, due to the dual security model in SP3.

davmac1

Thanks!

Sorcerer

if you have got a big database >40 gb you should wait until the "performance issue with sql 2005" is solved by mbs

Nobody

The combo we recommend for all new NAV SQL customers is

SQL 2005 x64 Standard Edition
Windows Server x64 R2 Standard Edition

This is because this combination will support upto 32 gigs of RAM and 4 processor sockets (sockets not cores you can have 4 quad cores if you want) and a 2 node cluster.

This covers 99.9% of all potential installs and is SO MUCH cheapier than having to buy sql enterprise edition like you had to in 2000 if you wanted to use more than 1.7 gigs of RAM.

kriki

[Topic moved from Navision forum to SQL General forum]