Microsoft Visual Studio Could not load file or assembly Microsoft.SqlServer.Management.SqlParser Version=13.0.0.0 The system cannot find the file specified.

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  February 5, 2018 at 4:51 am

  #343479

  Installing SQL Server 2017 broke SSDT. I have fixed the issue, but just wanted to post this because I couldn't find the solution at first.
  Steps

  • Uninstall Microsoft SQL Server 2017 TSQL Language Service.
  • Install TSqlLanguageService.msi from SQL Server 2016.

  • Part of Microsoft® SQL Server® 2016 Feature Pack - https://www.microsoft.com/en-us/download/details.aspx?id=52676
  • Version:13.0.1601.5
  • File: ENU\x64\TSqlLanguageService.msi

  I hope this helps someone.

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]

• Alexander Zhang

  Default port

  Points: 1497

  More actions

  February 12, 2018 at 10:32 am

  #1979466

  Good to know. Thanks for sharing.

  GASQL.com - Focus on Database and Cloud

• Stefan LG

  SSCommitted

  Points: 1936

  More actions

  April 26, 2018 at 3:22 am

  #1988320

  Thanks Sean.
  I encountered the exact same problem and your solution fixed it!

  For the record:
  SQL 2017 Developer Edition.
  Visual Studio 2013 Professional with Update 5.
  I used TSqlLanguageService.msi from the SQL 2016 RTM (not the developer edition).