Could not load file or assembly microsoft sqlserver transactsql scriptdom errors causing trouble? Find out how to fix the issue.

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Services.

Let’s take a look at how our Support Team is ready to help customers with “could not load file or assembly Microsoft sqlserver transactsql scriptdom” error.

Resolve: “could not load file or assembly Microsoft sqlserver transactsql scriptdom”

If you have been coming across the following error, you have come to the right place:

"System.IO.FileNotFoundException: Could not load file or assembly 
'Microsoft.SqlServer.TransactSql.ScriptDom"

One of our customers recently had a similar error when attempting to deploy .dacpac. Fortunately, our Support Techs were able to solve the issue on hand.

In fact, this error arises as a result of the premature failure of RMAD installation. Furthermore, we will find the following error after creating the msiexec install log at msiexec /i “RMAD_x64.msi” /L*v RMADInstall.log:

"Exception thrown by custom action: System.Reflection.TargetInvocationException:
 Exception has been thrown by the target of an invocation. ---> 
System.IO.FileNotFoundException: Could not load file or assembly 
'Microsoft.SqlServer.TransactSql.ScriptDom, Version=12.0.0.0, 
Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. 
The system cannot find the file specified"

According to our Support Team, we have to verify the following components are installed on the RMAD server:

• Microsoft SQL Server 2014 Transact-SQL ScriptDom
• Microsoft SQL System CLR Types for SQL Server 2012
• MS SQL Server Data-Tier Application Framework

In case these components are present, our Support Techs recommend uninstalling them and then reinstalling them again. We can reinstall the components from the RMAD installation package under the Setup folder.

After re-installation, the error will not appear. However, if you are still having trouble, drop us a line and one of our in-house experts will resolve the issue in no time.

[Looking for a solution to another query? We are just a click away.]

Conclusion

To sum up, our skilled Support Engineers at Bobcares demonstrated how to resolve could not load file error.