NAV4.0SP1 / SQL 2005 - Does Not Work!

JDVyska

Microsoft confirmed: Navision 4.0 SP1 does NOT work on SQL 2005 when using permissions. Business Analytics, Business Notifications, Commerce Gateway, and Commerce Portal also do not currently work with SQL 2005.

In a recent support discussion with Microsoft while trying to implement a customer on Navision 4.0 SP1 on Microsoft SQL Server 2005, they said that they have bugs with:

- Database Logins
- Windows Logins
- Any C/AL calling .READPERMISSION (such as all the login and logout triggers in ApplicationManagement)

This is (supposedly) not an issue if you aren’t using users or permissions.

Also, in the process, I discovered that Navision’s finsql.exe also does not use the new SQL ODBC drivers, so in some rare cases, you will have to install the SQL 2000 drivers or an older version of MDAC to even get Navision to browse the server list.

Informingly,
Jeremy


Edit: Send me a PM or email if you'd like the MS word Doc detailing this.

avdberg

Hello JDVyska,

We are working with SQL 2005 x64 win Windows 2003 +SP1 x64 and Navision 4.0 SP1 and also using Windows Logins.

We only had a problem with the SQL dll for Windows Logins because this was not working with 64 bit SQL 2005.

But microsoft made a dll for us and now it's working.

JDVyska

I'm glad to hear that they were able to get you working. It brought me no pleasure to discover there were problems, and the fact that Microsoft was able to assist you in your problem may mean they are close to resolution for the rest of us.

=D>

Jeremy

Scott_Frappier

I posted a potential solution for this issue at the following URL:

http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=16678