PowerShell 7.4.2 version error with dotnet 8.0.4 and Microsoft.Data.SqlClient assembly

[brad-simpson]

Verified issue does not already exist?

I have searched and found no existing issue

What error did you receive?

Exception: Couldn't import C:\Program Files\WindowsPowerShell\Modules\dbatools.library\2024.4.12\core\lib\win-sqlclient\Microsoft.Data.SqlClient.dll | Assembly with same name is already loaded

Steps to Reproduce

Success in v5

C:\>powershell -noprofile -nologo
PS C:\> $PSVersionTable.PSVersion.ToString()
5.1.19041.4412
PS C:\> Import-Module SqlServer
PS C:\> Import-Module dbatools
# Success

Reverse order succeeds in v.5:

C:\>powershell -noprofile -nologo
PS C:\> $PSVersionTable.PSVersion.ToString()
5.1.19041.4412
PS C:\> Import-Module dbatools
PS C:\> Import-Module SqlServer
# Success

Fails in v.7:

SqlServer first:

C:\>pwsh -noprofile -nologo
PS C:\> $PSVersionTable.PSVersion.ToString()
7.4.2
PS C:\> Import-Module SqlServer
PS C:\> Import-Module dbatools
Exception: Couldn't import C:\Program Files\WindowsPowerShell\Modules\dbatools.library\2024.4.12\core\lib\win-sqlclient\Microsoft.Data.SqlClient.dll | Assembly with same name is already loaded

Fails in reverse from the SqlServer module side:

C:\>pwsh -noprofile -nologo
PS C:\> $PSVersionTable.PSVersion.ToString()
7.4.2
PS C:\> Import-Module dbatools
PS C:\> Import-Module SqlServer
Add-Type: Assembly with same name is already loaded
Add-Type: Assembly with same name is already loaded
Add-Type: Assembly with same name is already loaded
Add-Type: Assembly with same name is already loaded
Add-Type: Assembly with same name is already loaded
Add-Type: Assembly with same name is already loaded
Add-Type: Assembly with same name is already loaded
Add-Type: Assembly with same name is already loaded
Add-Type: Assembly with same name is already loaded
Add-Type: Assembly with same name is already loaded

Please confirm that you are running the most recent version of dbatools

Get-Module dbatools | Select -ExpandProperty Version | Set-Clipboard

Result:

2.1.16

Other details or mentions

No response

What PowerShell host was used when producing this error

PowerShell Core (pwsh.exe), Windows PowerShell (powershell.exe)

PowerShell Host Version

Desktop:

Name                           Value                                                                                                                                                                                                        
----                           -----                                                                                                                                                                                                        
PSVersion                      5.1.19041.4412                                                                                                                                                                                               
PSEdition                      Desktop                                                                                                                                                                                                      
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}                                                                                                                                                                                      
BuildVersion                   10.0.19041.4412                                                                                                                                                                                              
CLRVersion                     4.0.30319.42000                                                                                                                                                                                              
WSManStackVersion              3.0                                                                                                                                                                                                          
PSRemotingProtocolVersion      2.3                                                                                                                                                                                                          
SerializationVersion           1.1.0.1                                                                                                                                                                                                      

Core:

Name                           Value
----                           -----
PSVersion                      7.4.2
PSEdition                      Core
GitCommitId                    7.4.2
OS                             Microsoft Windows 10.0.19045
Platform                       Win32NT
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
WSManStackVersion              3.0

SQL Server Edition and Build number

Not applicable

.NET Framework Version

[System.Runtime.InteropServices.RuntimeInformation]::get_FrameworkDescription() | Set-Clipboard

Result:

.NET 8.0.4

[wsmelton]

Confirming this does seem to be legit bug on dotnet side for that library.

ErrorRecord                 : Exception calling "ExecuteWithResults" with "1" argument(s): "Failed to connect to server {redacted}."
WasThrownFromThrowStatement : False
TargetSite                  : Void CheckActionPreference(System.Management.Automation.Language.FunctionContext, System.Exception)
Message                     : Exception calling "ExecuteWithResults" with "1" argument(s): "Failed to connect to server {redacted}."
Data                        : {[System.Management.Automation.Interpreter.InterpretedFrameInfo, System.Management.Automation.Interpreter.InterpretedFrameInfo[]]}
InnerException              : Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server {redacted}.
                               ---> System.DllNotFoundException: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
                                 at Microsoft.Data.SqlClient.SNINativeMethodWrapper.UnmanagedIsTokenRestricted(IntPtr token, Boolean& isRestricted)
                                 at Microsoft.Data.Win32NativeMethods.IsTokenRestrictedWrapper(IntPtr token)
                                 at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrentNative()
                                 at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrent()
                                 at Microsoft.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)
                                 at Microsoft.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)
                                 at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
                                 at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                                 at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                                 at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
                                 at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
                                 at Microsoft.Data.SqlClient.SqlConnection.Open()
                                 at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnectImpl()
                                 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                              --- End of stack trace from previous location ---
                                 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                                 at System.Security.Principal.WindowsIdentity.RunImpersonatedInternal(SafeAccessTokenHandle token, Action action)
                                 at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect()
                                 at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                                 --- End of inner exception stack trace ---
                                 at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                                 at Microsoft.SqlServer.Management.Common.ConnectionManager.PoolConnect()
                                 at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand, Boolean retry)
                                 at CallSite.Target(Closure, CallSite, Object, String)
HelpLink                    : 
Source                      : System.Management.Automation
HResult                     : -2146233087
StackTrace                  :    at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
                                 at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
                                 at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
                                 at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)

TargetSite     : 
Message        : Error connecting to [{redacted}]: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
Data           : {}
InnerException : System.Management.Automation.MethodInvocationException: Exception calling "ExecuteWithResults" with "1" argument(s): "Failed to connect to server {redacted}."
                  ---> Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server {redacted}.
                  ---> System.DllNotFoundException: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
                    at Microsoft.Data.SqlClient.SNINativeMethodWrapper.UnmanagedIsTokenRestricted(IntPtr token, Boolean& isRestricted)
                    at Microsoft.Data.Win32NativeMethods.IsTokenRestrictedWrapper(IntPtr token)
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrentNative()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrent()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
                    at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnectImpl()
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                 --- End of stack trace from previous location ---
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                    at System.Security.Principal.WindowsIdentity.RunImpersonatedInternal(SafeAccessTokenHandle token, Action action)
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    --- End of inner exception stack trace ---
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.PoolConnect()
                    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand, Boolean retry)
                    at CallSite.Target(Closure, CallSite, Object, String)
                    --- End of inner exception stack trace ---
                    at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
                    at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
HelpLink       : 
Source         : 
HResult        : -2146233088
StackTrace     : 

TargetSite     : 
Message        : Error connecting to [{redacted}]: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
Data           : {}
InnerException : System.Management.Automation.MethodInvocationException: Exception calling "ExecuteWithResults" with "1" argument(s): "Failed to connect to server {redacted}."
                  ---> Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server {redacted}.
                  ---> System.DllNotFoundException: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
                    at Microsoft.Data.SqlClient.SNINativeMethodWrapper.UnmanagedIsTokenRestricted(IntPtr token, Boolean& isRestricted)
                    at Microsoft.Data.Win32NativeMethods.IsTokenRestrictedWrapper(IntPtr token)
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrentNative()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrent()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
                    at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnectImpl()
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                 --- End of stack trace from previous location ---
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                    at System.Security.Principal.WindowsIdentity.RunImpersonatedInternal(SafeAccessTokenHandle token, Action action)
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    --- End of inner exception stack trace ---
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.PoolConnect()
                    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand, Boolean retry)
                    at CallSite.Target(Closure, CallSite, Object, String)
                    --- End of inner exception stack trace ---
                    at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
                    at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
HelpLink       : 
Source         : 
HResult        : -2146233088
StackTrace     : 

TargetSite     : 
Message        : Error connecting to [{redacted}]: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
Data           : {}
InnerException : System.Management.Automation.MethodInvocationException: Exception calling "ExecuteWithResults" with "1" argument(s): "Failed to connect to server {redacted}."
                  ---> Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server {redacted}.
                  ---> System.DllNotFoundException: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
                    at Microsoft.Data.SqlClient.SNINativeMethodWrapper.UnmanagedIsTokenRestricted(IntPtr token, Boolean& isRestricted)
                    at Microsoft.Data.Win32NativeMethods.IsTokenRestrictedWrapper(IntPtr token)
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrentNative()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrent()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
                    at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnectImpl()
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                 --- End of stack trace from previous location ---
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                    at System.Security.Principal.WindowsIdentity.RunImpersonatedInternal(SafeAccessTokenHandle token, Action action)
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    --- End of inner exception stack trace ---
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.PoolConnect()
                    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand, Boolean retry)
                    at CallSite.Target(Closure, CallSite, Object, String)
                    --- End of inner exception stack trace ---
                    at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
                    at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
HelpLink       : 
Source         : 
HResult        : -2146233088
StackTrace     : 

TargetSite     : 
Message        : Error connecting to [{redacted}]: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
Data           : {}
InnerException : System.Management.Automation.MethodInvocationException: Exception calling "ExecuteWithResults" with "1" argument(s): "Failed to connect to server {redacted}."
                  ---> Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server {redacted}.
                  ---> System.DllNotFoundException: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
                    at Microsoft.Data.SqlClient.SNINativeMethodWrapper.UnmanagedIsTokenRestricted(IntPtr token, Boolean& isRestricted)
                    at Microsoft.Data.Win32NativeMethods.IsTokenRestrictedWrapper(IntPtr token)
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrentNative()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrent()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
                    at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnectImpl()
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                 --- End of stack trace from previous location ---
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                    at System.Security.Principal.WindowsIdentity.RunImpersonatedInternal(SafeAccessTokenHandle token, Action action)
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    --- End of inner exception stack trace ---
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.PoolConnect()
                    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand, Boolean retry)
                    at CallSite.Target(Closure, CallSite, Object, String)
                    --- End of inner exception stack trace ---
                    at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
                    at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
HelpLink       : 
Source         : 
HResult        : -2146233088
StackTrace     : 

TargetSite     : 
Message        : Error connecting to [{redacted}]: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
Data           : {}
InnerException : System.Management.Automation.MethodInvocationException: Exception calling "ExecuteWithResults" with "1" argument(s): "Failed to connect to server {redacted}."
                  ---> Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server {redacted}.
                  ---> System.DllNotFoundException: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))
                    at Microsoft.Data.SqlClient.SNINativeMethodWrapper.UnmanagedIsTokenRestricted(IntPtr token, Boolean& isRestricted)
                    at Microsoft.Data.Win32NativeMethods.IsTokenRestrictedWrapper(IntPtr token)
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrentNative()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolIdentity.GetCurrent()
                    at Microsoft.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)
                    at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
                    at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
                    at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
                    at Microsoft.Data.SqlClient.SqlConnection.Open()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnectImpl()
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                 --- End of stack trace from previous location ---
                    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
                    at System.Security.Principal.WindowsIdentity.RunImpersonatedInternal(SafeAccessTokenHandle token, Action action)
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    --- End of inner exception stack trace ---
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
                    at Microsoft.SqlServer.Management.Common.ConnectionManager.PoolConnect()
                    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand, Boolean retry)
                    at CallSite.Target(Closure, CallSite, Object, String)
                    --- End of inner exception stack trace ---
                    at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
                    at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
                    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
HelpLink       : 
Source         : 
HResult        : -2146233088
StackTrace     : 

Assemblies in current session

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/win-sqlclient/Microsoft.Data.SqlClient.dll
FullName            : Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5
EntryPoint          : 
DefinedTypes        : 
IsCollectible       : False
ManifestModule      : Microsoft.Data.SqlClient.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\win-sqlclient\Microsoft.Data.SqlClient.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.Data.OperationAbortedException, Microsoft.Data.SqlTypes.SqlFileStream, Microsoft.Data.SqlClient.ActiveDirectoryAuthenticationProvider, Microsoft.Data.SqlClient.ApplicationIntent…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/win-sqlclient/Microsoft.Data.SqlClient.dll
Modules             : {Microsoft.Data.SqlClient.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Server.dll
FullName            : Microsoft.SqlServer.Server, Version=1.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5
EntryPoint          : 
DefinedTypes        : {System.ThisAssembly, Microsoft.SqlServer.Server.IBinarySerialize, Microsoft.SqlServer.Server.InvalidUdtException, Microsoft.SqlServer.Server.SqlFacetAttribute…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.Server.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.Server.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Server.IBinarySerialize, Microsoft.SqlServer.Server.InvalidUdtException, Microsoft.SqlServer.Server.SqlFacetAttribute, Microsoft.SqlServer.Server.DataAccessKind…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)], [System.CLSCompliantAttribute((Boolean)True)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Server.dll
Modules             : {Microsoft.SqlServer.Server.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Dac.dll
FullName            : Microsoft.SqlServer.Dac, Version=162.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
EntryPoint          : 
DefinedTypes        : {Microsoft.CodeAnalysis.EmbeddedAttribute, System.Runtime.CompilerServices.NullableAttribute, System.Runtime.CompilerServices.NullableContextAttribute, Microsoft.SqlServer.Dac.BacPackage…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.Dac.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.Dac.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Dac.BacPackage, Microsoft.SqlServer.Dac.DacAzureEdition, Microsoft.SqlServer.Dac.DacAzureDatabaseSpecification, Microsoft.SqlServer.Dac.DacDataProgressMessage…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Dac.dll
Modules             : {Microsoft.SqlServer.Dac.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.Data.Tools.Schema.Sql.dll
FullName            : Microsoft.Data.Tools.Schema.Sql, Version=162.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
EntryPoint          : 
DefinedTypes        : {<>f__AnonymousType0`2[<Name>j__TPar,<Value>j__TPar], Microsoft.CodeAnalysis.EmbeddedAttribute, System.Runtime.CompilerServices.NullableAttribute, System.Runtime.CompilerServices.NullableContextAttribute…}
IsCollectible       : False
ManifestModule      : Microsoft.Data.Tools.Schema.Sql.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.Data.Tools.Schema.Sql.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {System.Reflection.Adds.WIN32_FILE_ATTRIBUTE_DATA, Microsoft.Isam.Esent.Interop.JET_coltyp, Microsoft.SqlServer.Dac.Extensibility.CompositionProperties, Microsoft.SqlServer.Dac.Extensibility.IDependencyManager…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.Data.Tools.Schema.Sql.dll
Modules             : {Microsoft.Data.Tools.Schema.Sql.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Smo.dll
FullName            : Microsoft.SqlServer.Smo, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {<>f__AnonymousType0`2[<dr>j__TPar,<isOnlineDAC>j__TPar], <>f__AnonymousType1`4[<GroupID>j__TPar,<NodeId>j__TPar,<CpuIds>j__TPar,<CpuAffinityMask>j__TPar], <>f__AnonymousType2`2[<propertyName>j__TPar,<groupOption>j__TPar], Microsoft.CodeAnalysis.EmbeddedAttribute…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.Smo.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.Smo.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.Smo.ApplicationRoleCollection, Microsoft.SqlServer.Management.Smo.AsymmetricKeyCollection, Microsoft.SqlServer.Management.Smo.AuditCollection, Microsoft.SqlServer.Management.Smo.AvailabilityDatabaseCollection…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Smo.dll
Modules             : {Microsoft.SqlServer.Smo.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.ConnectionInfo.dll
FullName            : Microsoft.SqlServer.ConnectionInfo, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.Server.SqlContext, Microsoft.SqlServer.Server.SqlPipe, Microsoft.SqlServer.Management.Common.NetworkProtocol, Microsoft.SqlServer.Management.Common.DatabaseEngineType…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.ConnectionInfo.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.ConnectionInfo.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Server.SqlContext, Microsoft.SqlServer.Server.SqlPipe, Microsoft.SqlServer.Management.Common.NetworkProtocol, Microsoft.SqlServer.Management.Common.DatabaseEngineType…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.ConnectionInfo.dll
Modules             : {Microsoft.SqlServer.ConnectionInfo.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.Sdk.Sfc.dll
FullName            : Microsoft.SqlServer.Management.Sdk.Sfc, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.Management.Sdk.Differencing.DifferencingService, Microsoft.SqlServer.Management.Sdk.Differencing.IDifferencer, Microsoft.SqlServer.Management.Sdk.Differencing.IDiffgram, Microsoft.SqlServer.Management.Sdk.Differencing.DiffType…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.Management.Sdk.Sfc.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.Management.Sdk.Sfc.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.Sdk.Differencing.DifferencingService, Microsoft.SqlServer.Management.Sdk.Differencing.IDifferencer, Microsoft.SqlServer.Management.Sdk.Differencing.IDiffgram, Microsoft.SqlServer.Management.Sdk.Differencing.DiffType…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.Sdk.Sfc.dll
Modules             : {Microsoft.SqlServer.Management.Sdk.Sfc.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.SqlEnum.dll
FullName            : Microsoft.SqlServer.SqlEnum, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.Management.Dmf.PolicyHealthState, Microsoft.SqlServer.Management.Smo.ConditionedSql, Microsoft.SqlServer.Management.Smo.ConditionedSqlList, Microsoft.SqlServer.Management.Smo.DatabaseLevel…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.SqlEnum.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.SqlEnum.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.Dmf.PolicyHealthState, Microsoft.SqlServer.Management.Smo.DdlTextParserHeaderInfo, Microsoft.SqlServer.Management.Smo.FileGrowthType, Microsoft.SqlServer.Management.Smo.IndexKeyType…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.SqlEnum.dll
Modules             : {Microsoft.SqlServer.SqlEnum.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Dmf.Common.dll
FullName            : Microsoft.SqlServer.Dmf.Common, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.Management.Dmf.DmfConstants, Microsoft.SqlServer.Management.Dmf.DmfExceptionType, Microsoft.SqlServer.Management.Dmf.DmfException, Microsoft.SqlServer.Management.Dmf.AssemblyAlreadyRegisteredException…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.Dmf.Common.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.Dmf.Common.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.Dmf.DmfConstants, Microsoft.SqlServer.Management.Dmf.DmfExceptionType, Microsoft.SqlServer.Management.Dmf.DmfException, Microsoft.SqlServer.Management.Dmf.AssemblyAlreadyRegisteredException…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Dmf.Common.dll
Modules             : {Microsoft.SqlServer.Dmf.Common.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.ServiceBrokerEnum.dll
FullName            : Microsoft.SqlServer.ServiceBrokerEnum, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.ServiceBrokerEnum.AssemblyVersionInfo, Microsoft.SqlServer.Management.Smo.Broker.DialogEndPointState, Microsoft.SqlServer.Management.Smo.Broker.DialogType, Microsoft.SqlServer.Management.Smo.Broker.MessageTypeValidation…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.ServiceBrokerEnum.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.ServiceBrokerEnum.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.Smo.Broker.DialogEndPointState, Microsoft.SqlServer.Management.Smo.Broker.DialogType, Microsoft.SqlServer.Management.Smo.Broker.MessageTypeValidation, Microsoft.SqlServer.Management.Smo.Broker.MessageSource}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)], [System.Resources.NeutralResourcesLanguageAttribute("en-US")]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.ServiceBrokerEnum.dll
Modules             : {Microsoft.SqlServer.ServiceBrokerEnum.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.SmoExtended.dll
FullName            : Microsoft.SqlServer.SmoExtended, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.SmoExtended.NetCoreHelpers, Microsoft.SqlServer.SmoExtended.AssemblyVersionInfo, Microsoft.SqlServer.Management.Smo.Backup, Microsoft.SqlServer.Management.Smo.BackupTruncateLogType…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.SmoExtended.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.SmoExtended.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.Smo.Backup, Microsoft.SqlServer.Management.Smo.BackupTruncateLogType, Microsoft.SqlServer.Management.Smo.BackupActionType, Microsoft.SqlServer.Management.Smo.BackupCompressionOptions…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.SmoExtended.dll
Modules             : {Microsoft.SqlServer.SmoExtended.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.SqlWmiManagement.dll
FullName            : Microsoft.SqlServer.SqlWmiManagement, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.SqlWmiManagement.AssemblyVersionInfo, Microsoft.SqlServer.Management.Smo.WmiMgmtImpl, Microsoft.SqlServer.Management.Smo.Wmi.ClientProtocol, Microsoft.SqlServer.Management.Smo.Wmi.ClientProtocolCollection…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.SqlWmiManagement.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.SqlWmiManagement.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.Smo.Wmi.ClientProtocol, Microsoft.SqlServer.Management.Smo.Wmi.ClientProtocolCollection, Microsoft.SqlServer.Management.Smo.Wmi.ServerInstanceCollection, Microsoft.SqlServer.Management.Smo.Wmi.ServerIPAddressCollection…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)], [System.Resources.NeutralResourcesLanguageAttribute("en-US")]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.SqlWmiManagement.dll
Modules             : {Microsoft.SqlServer.SqlWmiManagement.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.WmiEnum.dll
FullName            : Microsoft.SqlServer.WmiEnum, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.Management.Smo.Wmi.ClientProtocol, Microsoft.SqlServer.Management.Smo.Wmi.ClientProtocolProperties, Microsoft.SqlServer.Management.Smo.Wmi.CNetLibInfo, Microsoft.SqlServer.Management.Smo.Wmi.EnumManagedComputer…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.WmiEnum.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.WmiEnum.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.Smo.Wmi.ServiceStartMode, Microsoft.SqlServer.Management.Smo.Wmi.ServiceState, Microsoft.SqlServer.Management.Smo.Wmi.ServiceErrorControl, Microsoft.SqlServer.Management.Smo.Wmi.ManagedServiceType…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)], [System.Resources.NeutralResourcesLanguageAttribute("en-US")]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.WmiEnum.dll
Modules             : {Microsoft.SqlServer.WmiEnum.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.RegisteredServers.dll
FullName            : Microsoft.SqlServer.Management.RegisteredServers, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {<>f__AnonymousType0`2[<ver>j__TPar,<possiblePath>j__TPar], Microsoft.SqlServer.Management.RegisteredServers.AzureDataStudioConnection, Microsoft.SqlServer.Management.RegisteredServers.AzureDataStudioConnectionStore, Microsoft.SqlServer.Management.RegisteredServers.AzureDataStudioConnectionGroup…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.Management.RegisteredServers.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.Management.RegisteredServers.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.RegisteredServers.AzureDataStudioConnection, Microsoft.SqlServer.Management.RegisteredServers.AzureDataStudioConnectionStore, Microsoft.SqlServer.Management.RegisteredServers.AzureDataStudioConnectionGroup, Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)], [System.Resources.NeutralResourcesLanguageAttribute("en-US")]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.RegisteredServers.dll
Modules             : {Microsoft.SqlServer.Management.RegisteredServers.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.Collector.dll
FullName            : Microsoft.SqlServer.Management.Collector, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {HighestIncompatibleMDWVersion, Microsoft.SqlServer.Diagnostics.STrace.STraceConfigurationAttribute, Microsoft.SqlServer.Diagnostics.STrace.TraceContext, Microsoft.SqlServer.Diagnostics.STrace.ActivityContext…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.Management.Collector.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.Management.Collector.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {HighestIncompatibleMDWVersion, Microsoft.SqlServer.Management.Collector.CollectionItem, Microsoft.SqlServer.Management.Collector.CollectionItemCollection, Microsoft.SqlServer.Management.Collector.CollectionSet…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)], [System.Runtime.Versioning.TargetFrameworkAttribute(".NETCoreApp,Version=v6.0", FrameworkDisplayName = ".NET 6.0")]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.Collector.dll
Modules             : {Microsoft.SqlServer.Management.Collector.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.XEvent.dll
FullName            : Microsoft.SqlServer.Management.XEvent, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.Management.XEvent.Action, Microsoft.SqlServer.Management.XEvent.ActionCollection, Microsoft.SqlServer.Management.XEvent.ActionInfo, Microsoft.SqlServer.Management.XEvent.ActionInfoCollection…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.Management.XEvent.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.Management.XEvent.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.XEvent.Action, Microsoft.SqlServer.Management.XEvent.ActionCollection, Microsoft.SqlServer.Management.XEvent.ActionInfo, Microsoft.SqlServer.Management.XEvent.ActionInfoCollection…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.XEvent.dll
Modules             : {Microsoft.SqlServer.Management.XEvent.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.XEventDbScoped.dll
FullName            : Microsoft.SqlServer.Management.XEventDbScoped, Version=17.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.Management.XEventDbScoped.Constants, Microsoft.SqlServer.Management.XEventDbScoped.DatabaseEventProvider, Microsoft.SqlServer.Management.XEventDbScoped.DatabaseSessionProvider, Microsoft.SqlServer.Management.XEventDbScoped.DatabaseTargetProvider…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.Management.XEventDbScoped.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.Management.XEventDbScoped.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.Management.XEventDbScoped.DatabaseXEStore}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.Management.XEventDbScoped.dll
Modules             : {Microsoft.SqlServer.Management.XEventDbScoped.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.XEvent.XELite.dll
FullName            : Microsoft.SqlServer.XEvent.XELite, Version=1.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.XEvent.XELite.IXEvent, Microsoft.SqlServer.XEvent.XELite.HandleMetadata, Microsoft.SqlServer.XEvent.XELite.HandleXEvent, Microsoft.SqlServer.XEvent.XELite.IXEventFetcher…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.XEvent.XELite.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.XEvent.XELite.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.XEvent.XELite.IXEvent, Microsoft.SqlServer.XEvent.XELite.HandleMetadata, Microsoft.SqlServer.XEvent.XELite.HandleXEvent, Microsoft.SqlServer.XEvent.XELite.IXEventFetcher…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.ExtensionAttribute()], [System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.XEvent.XELite.dll
Modules             : {Microsoft.SqlServer.XEvent.XELite.dll}
SecurityRuleSet     : None

CodeBase            : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.TransactSql.ScriptDom.dll
FullName            : Microsoft.SqlServer.TransactSql.ScriptDom, Version=16.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
EntryPoint          : 
DefinedTypes        : {Microsoft.SqlServer.TransactSql.ScriptDom.AbortAfterWaitType, Microsoft.SqlServer.TransactSql.ScriptDom.AbortAfterWaitTypeHelper, Microsoft.SqlServer.TransactSql.ScriptDom.AffinityKind, Microsoft.SqlServer.TransactSql.ScriptDom.AllowConnectionsOptionKind…}
IsCollectible       : False
ManifestModule      : Microsoft.SqlServer.TransactSql.ScriptDom.dll
ReflectionOnly      : False
Location            : C:\Users\t1-alive\Documents\PowerShell\Modules\dbatools.library\2024.4.12\core\lib\Microsoft.SqlServer.TransactSql.ScriptDom.dll
ImageRuntimeVersion : v4.0.30319
GlobalAssemblyCache : False
HostContext         : 0
IsDynamic           : False
ExportedTypes       : {Microsoft.SqlServer.TransactSql.ScriptDom.AbortAfterWaitType, Microsoft.SqlServer.TransactSql.ScriptDom.AffinityKind, Microsoft.SqlServer.TransactSql.ScriptDom.AllowConnectionsOptionKind, Microsoft.SqlServer.TransactSql.ScriptDom.AlterAction…}
IsFullyTrusted      : True
CustomAttributes    : {[System.Runtime.CompilerServices.CompilationRelaxationsAttribute((Int32)8)], [System.Runtime.CompilerServices.RuntimeCompatibilityAttribute(WrapNonExceptionThrows = True)], [System.Diagnostics.DebuggableAttribute((System.Diagnostics.DebuggableAttribute+DebuggingModes)2)], [System.Runtime.Versioning.TargetFrameworkAttribute(".NETCoreApp,Version=v6.0", FrameworkDisplayName = "")]…}
EscapedCodeBase     : file:///C:/Users/t1-alive/Documents/PowerShell/Modules/dbatools.library/2024.4.12/core/lib/Microsoft.SqlServer.TransactSql.ScriptDom.dll
Modules             : {Microsoft.SqlServer.TransactSql.ScriptDom.dll}
SecurityRuleSet     : None

[niphlod]

maybe dataplat/dbatools.library#15 fixes this, too.

[mattcargile]

Yeah I get

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: Access is denied. (0x80070005 (E_ACCESSDENIED))

in 5.1 and 7.5.0 on Windows 11 Pro and 2.1.28 of the module. I don't know what is different between this machine and my personal one running Window 11 though.

[S-dn-Y]

Hey all,

We're still getting this error a year later in our environment.

PS C:\Program Files\PowerShell\7> Get-Module DBA*,SQLServer

ModuleType Version    PreRelease Name                                ExportedCommands
---------- -------    ---------- ----                                ----------------
Script     2.1.30                dbatools                            {Select-DbaObject, Set-DbatoolsConfig, Add-DbaAgD…
Script     2024.4.12             dbatools.library                    Get-DbatoolsLibraryPath
Script     22.1.1                SqlServer

Edit: This sounds unfriendlier then I meant it to sound 😁
Any updates on this?
Has any been able to make any progress on this, or is this on the roadmap to fix? I feel like more people may want to import both of the modules in the same session?
With PowerShell 7 we're able to use a custom Assembly Load Context, seems like a solution here?

As a sidenote.
Loading the dependency externally seems to solve this, any downsides of using this besides from that it might break if the dll get's updated?

PS C:\Program Files\PowerShell\7> [System.Reflection.Assembly]::LoadFrom('C:\Program Files\WindowsPowerShell\Modules\dbatools.library\2024.4.12\core\lib\win-sqlclient\Microsoft.Data.SqlClient.dll')

GAC    Version        Location
---    -------        --------
False  v4.0.30319     C:\Program Files\WindowsPowerShell\Modules\dbatools.library\2024.4.12\core\lib\win-sqlclient\Mic…

PS C:\Program Files\PowerShell\7> Import-Module sqlserver,dbatools
WARNING: SQLPS or SqlServer was previously imported during this session. If you encounter weird issues with dbatools, please restart PowerShell, then import dbatools without loading SQLPS or SqlServer first.
WARNING: To disable this message, type: Set-DbatoolsConfig -Name Import.SqlpsCheck -Value $false -PassThru | Register-DbatoolsConfig
PS C:\Program Files\PowerShell\7> Get-Module DBA*,SQLServer

ModuleType Version    PreRelease Name                                ExportedCommands
---------- -------    ---------- ----                                ----------------
Script     2.1.30                dbatools                            {Select-DbaObject, Set-DbatoolsConfig, Add-DbaAgD…
Script     2024.4.12             dbatools.library                    Get-DbatoolsLibraryPath
Script     22.1.1                sqlserver                           {Add-RoleMember, Add-SqlAvailabilityDatabase, Add…

BTW, I'm loading the sqlserver module in compatibility mode now, as it's small and loads quickly, but rather have it native in PowerShell 7 alongside the dbatools.

Thank you in advance.
Best regards,
Sidney