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.


Posted by at
Labels: , , , ,
Location: Hyderabad, Telangana, India

4 comments:

  1. Krupesh & Family17 April 2015 at 17:09

    What if those tables are required in NAV 2013?

    ReplyDelete
  2. nish25 September 2015 at 17:57

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

    ReplyDelete
  3. Dani27 October 2015 at 14:31

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

    ReplyDelete
  4. Anonymous29 January 2016 at 22:31

    Thanks for the helpful info!

    ReplyDelete

Subscribe to: Post Comments (Atom)