NAV 4.03 on SQL Express

NaviDev

Hi,

Anyone tried to use navision 4.03 using SQL Express? Any problem using it with nav?

Thanks!

Marije_Brummel

Yes, it works.

NaviDev

Any problem encountered using it with nav? Or are there any limitation on the features?

kine

Yes, there are - max. 4GB database, max 1GB Ram used, max 1CPU used, no SQL Server agent

Marije_Brummel

In other words, you should seriously consider running on the native server instead.

Waldo

Native has less restrictions .
NAV runs "heavier" on SQL, so you need more hardware, and express doesn't allow it.
I would only use it when I really need the "openess" or the backup or whatever... . Like Mark said ... really consider if you want this.

NaviDev

Thanks to you all for your attention and suggestions. MVP's rocks....

kriki

[Topic moved from Navision forum to SQL General forum]