Attempting to setup a UAT environment as Sitecore 9.3 standalone with a remote SQL 2017 server using SIA gives the error:
Error Code: ERROR_ASSEMBLY_NOT_FOUND
More Information: The assembly 'Microsoft.SqlServer.batchparser, Version=184.108.40.206, Culture=neutral, PublicKeyToken=89845dcd8080cc91' could not be loaded. Learn more at: go.microsoft.com/.../
Error: Could not load file or assembly 'Microsoft.SqlServer.batchparser, Version=220.127.116.11, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
All prerequisites have been installed on the remote SQL server
Using the sa account for access
Turned firewall off completely on remote SQL server
Have performed the installation previously using a local SQL 2017 server without issue.
Have compared the versions of Microsoft.SqlServer.batchparser.dll in the GAC on the remote server which fails with the local server that works and both are the same version.
It did successfully create some of the databases.