Login failed error while upgrading from NAV2009 to NAV2015

Mohana Yadav

60,195 Super User 2025 Season 1

16 Apr 2015

Like(0)

Report

Error Message:

---------------------------

Microsoft Dynamics NAV Development Environment

---------------------------

The following SQL Server error or errors occurred:

18456,"28000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'GAC\MPA'.

4060,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "GAC-COPY-PRODUCTION-Test" requested by the login. The login failed.

---------------------------

Problem Statement:

System returns this error message when you try to open the NAV2009 database with NAV2013 client in upgrade process and you can’t open the database in NAV2009 anymore, can’t fix the error and can’t continue further with upgrade process.

Solution:

Restore the NAV2009 backup again and remove all tables which have property “LinkedObject“ Yes before converting the database to NAV2013.

This was originally posted here.