Dbatools unable to connect using Agent environment

I know dbatools doesn’t play nice with the integrated environment anymore (which is fair enough).

I was hoping however that the Agent environment would work, but it is giving the same error… Adam, does the agent environment have a requirement itself for Microsoft.Data.SqlClient.dll?

Product: PowerShell Universal
Version: 3.5.5

It doesn’t directly but it may be bringing in the SQL assembly for some reason since it’s in the same base directory as the SQL assemblies. We may be able to publish the agent to its own directory to avoid this.

1 Like