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.

BeckyS 20 Reputation points
2024-02-09T14:22:08.8166667+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,238 questions
0 comments No comments
{count} votes

Accepted answer
  1. Michael Taylor 43,976 Reputation points
    2024-02-09T15:39:37.03+00:00

    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.


0 additional answers

Sort by: Most helpful