Navision 4.03 Application Server error...


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?



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)?

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

Regards Meint

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.


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