Thursday, 16 April 2015

Login failed error while upgrading from NAV2009 to NAV2015


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.
---------------------------
OK  
---------------------------



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.


5 comments:

  1. What if those tables are required in NAV 2013?

    ReplyDelete
  2. I am getting this when trying to connect to NAV 2015 through developer mode. Any idea what could be done?

    ReplyDelete
  3. Hi,
    I'm new to this. How do you list the tables with LinkedObject property set to yes?
    Thank you.

    ReplyDelete
  4. Thanks for the helpful info!

    ReplyDelete