0

I just installed SQL Server 2016 on my home server. I'm trying to connect to it from Visual Studio 2015 from my desktop PC, and repeatedly getting the well-known error:

An error occurred while attempting to reverse engineer elements of type Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlDatabaseCredential: Batch Command during reverse engineer failed with Error Code: -2146232060 Line Number: 2267 Error Message: Invalid column name compression_delay. Invalid column name compression_delay.

James Z
  • 12,209
  • 10
  • 24
  • 44
Raghu Ariga
  • 1,059
  • 1
  • 19
  • 28
  • So what's unclear about the _well-known_ error? – James Z Nov 19 '16 at 16:03
  • 1
    Possible duplicate of [Visual Studio 2015 Update 2 and Sql Server 2016 Schema Compare](http://stackoverflow.com/questions/36872528/visual-studio-2015-update-2-and-sql-server-2016-schema-compare) – James Z Nov 19 '16 at 16:05
  • 2
    i was not aware of update/patch for VS 2015 Update 2, will try and update question – Raghu Ariga Nov 19 '16 at 16:09

1 Answers1

1

See this question with the exact same error message. Visual Studio 2015 Update 2 and Sql Server 2016 Schema Compare

The fix there was Updating Visual Studio with this patch. https://msdn.microsoft.com/en-us/library/mt752379.aspx

Try updating Visual Studio and see if the error persists!

Good luck!

Community
  • 1
  • 1
Troy Witthoeft
  • 2,498
  • 2
  • 28
  • 37