Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Question

Let me first start by acknowledging my own stupidity. Our organization has been focusing on cyber security a great deal in recent months and in my zeal to secure our SQL deployment, I decided to "clean up" some of the older bits and pieces installed on our database server. I thought I was thoroughly testing my cleanup procedure in our test environment but I missed testing one piece of the software that runs on SQL and am now receiving the error "Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified." when trying to run a certain function of the system. I am trying to figure out how to recover that missing assembly but am having no luck finding the proper package to reinstall. We are currently running SQL Server 2019. Any assistance would be greatly appreciated.

Answer 1

Install the SQL Server Management Objects. You said the version was 12.x which would seem to point to SQL Server 2014. Therefore install that version of the SMOs. A quick google shows the download here.

However you may start by installing the version for SQL 2019 and see if that resolves the problem for you. It's possible that the current version installs the older version as well. I haven't confirmed.