Issue  There is a login problem that occurs when using pre-Nav 4.0.SP1 client with SQL 2005


Solution

There is a SQL error after attempting to re-open a Navision Database in a version prior to version 4.0.SP1.



If you create and restore a Navision database of a version prior you can use the database until closed the first time.

Attached is a sql fix for this situation that in theory should allow prior versions of Navision to work with SQL2005.  If attempting to use a version of Navision prior to 4.0.sp1 with SQL 2005 please ensure the database is adequately tested!