What are the challenges you face when working across database platforms? Take the survey

Error while converting access db

I got following error while converting access db to MS SQL 2016 db using Microsoft SQL server migrant assist:

SQL Server Error

Error appeared when I installed office proplus. Anyone have had similar issue?

Best Answer

  • Options
    Isha87Isha87 Posts: 1 Bronze 1
    Here are some possible reasons for SQL Server error.
    • A login does not have permission to view data of a column selected in the header
    • A database is offline and/or its collation is NULL
    • Multiple databases with different collations are on the instance and SSMS is unable to retrieve the collation because a database is configured to auto-close
    For more detailed information on how to fix SQL Server errors here


Sign In or Register to comment.