Navision 4.03 Application Server error...

Dynamics 365 Business Central/NAV Technical Forum
1

Hi,

Upgraded our client environment to version 4.03 and all seems to be running reasonably smooth. However, when trying to start the 4.03 version of NAS, I get the following error:

The following SQL Server error(s) occurred:

515,“23000”,[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column ‘name’, table 'tempdb.dbo.#$ndo$groups

Anybody have any ideas why this is and how to resolve it?

Thanks

Meint

2

Did you upgrade your NAS to the 4.03 version as well (I mean uninstall the old one and use the new product cd to install the new one)?

3

Yes, even uninstalled the service and reinstalled it, made no difference…

Regards Meint

4

Okay, think this my bad. Forgot to upgrade the stored procedure to allow Windows authentication. The one that is loaded was version 3.70 which obviously no longer works. Will have a chance to test my theory tonight when I can take the DB server offline for a few minutes.

Meint

5

I am suprised the client worked with 4.03 app and 3.70 stored procedure?