I’m upgrading a database from 2009 to 2016. In that process I first convert the database to 2013 format so I can export and import fob files in 2016 (which isn’t possible directly from 2009).
When converting the database I get a login error in the middle of the process:
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 ‘MyDomain\MyUser’.
4060,”42000″,[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database ‘MyDatabase’ requested by the login. The login failed.
It turned out this had nothing to do with login failure. I have read on blogs and forums that it’s the reason should be linked tables in the database, but that was not my problem. It was a custom table that caused the problem. The only solution was to delete the table. I tried changing field names, datatypes, field lengths, deleting statistics etc. but nothing helped. After conversion I could import the table again.
To see which table that is causing the problem you can run SQL Profiler during the conversion and see where it stops.
Thanks for reading this. I’ll continue upgrading now