SQL 64 bit - is this configuration supported by Microsoft?

frel

I have question about this configuration:

Navision 4.01 latest SP on 32 bit Windows XP connected to SQL 64 bit on Windows 2003 64 bit – is this configuration supported by Microsoft?

I would like to use Windows Integrated logins.

kriki

frel wrote:

Navision 4.01 latest SP

I suppose you mean 4.00SP3?

nunomaia

SQL Server 2000 or 2005 ?

DenSter

Yes that is supported. Make sure you install the right 64x version of the extended stored procedures. NAV does not recognise those 64x versions though (dll name is hardcoded in the exe), so you have to add them manually. Make sure you add the enumusergroups as well as the enumusersids ESP's, so both security models are supported.

Also, when you install NAV on the SQL Server, DO NOT do a full install. Make sure you do the custom install, and make sure that you unselect MSDE. For some reason, when you're on 64x, the NAV installer does not recognize SQL Server and it will install MSDE. This will screw up your SQL Server 2005 installation, and can possibly cause the server OS to fail.

kriki

[Topic moved from Navision forum to SQL General forum]