goranpaver

Thank you angelfreire !

@Jonathan Lafontaine - yes, I'm on windows, tried both Windows 11 and Server 2019

Hi, its Integrated Security (active directory) and my user can access the database - test database is successfull

Hi,

I have upgraded PS to:

<15:46:46 30.03.23> $PSVersionTable

Name Value

---- -----

PSVersion 7.3.3

PSEdition Core

GitCommitId 7.3.3

but I'm still getting the same error.

Hi, we have installed the latest version of Devolutions.Powershell (2023.1.0.4) and PS version 7.2.9.

Running Get-RDMDatasource results in this:

<14:42:31 30/03/23> PS D:\RBAGit\win-rbhr-powershell> get-rdmdatasource

ID : e01aee5a-4d6e-4bb1-bf07-f5356c6485e4

IsConnected : False

IsOffline : False

Name : Local Data Source

Type : SQLite

ID : 2a2f67a7-c3ae-4821-8174-a4fedbd8d35b

IsConnected : False

IsOffline : False

Name : TEST

Type : SQLServer

But when trying to do this:

$se = Get-RDMDataSource -Name "test"

Set-RDMCurrentDataSource $se

I get an error:

The type initializer for 'NetSecurityNative' threw an exception.

at Interop.NetSecurityNative.ImportPrincipalName(Status& minorStatus, String inputName, Int32 inputNameByteCount, SafeGssNameHandle& outputName)

at Microsoft.Win32.SafeHandles.SafeGssNameHandle.CreatePrincipal(String name)

at System.Net.Security.SafeDeleteNegoContext..ctor(SafeFreeNegoCredentials credential, String targetName)

at System.Net.Security.NegotiateStreamPal.EstablishSecurityContext(SafeFreeNegoCredentials credential, SafeDeleteContext& context, String targetName, ContextFlagsPal inFlags, SecurityBuffer inputBuffer, SecurityBuffer outputBuffer, ContextFlagsPal& outFlags)

at System.Net.Security.NegotiateStreamPal.InitializeSecurityContext(SafeFreeCredentials credentialsHandle, SafeDeleteContext& securityContext, String[] spns, ContextFlagsPal requestedContextFlags, SecurityBuffer[] inSecurityBufferArray, SecurityBuffer outSecurityBuffer, ContextFlagsPal& contextFlags)

at Microsoft.Data.SqlClient.SNI.SNIProxy.GenSspiClientContext(SspiClientContextStatus sspiClientContextStatus, Byte[] receivedBuff, Byte[]& sendBuff, Byte[][] serverName)

at Microsoft.Data.SqlClient.SNI.TdsParserStateObjectManaged.GenerateSspiClientContext(Byte[] receivedBuff, UInt32 receivedLength, Byte[]& sendBuff, UInt32& sendLength, Byte[][] _sniSpnBuffer)

at Microsoft.Data.SqlClient.TdsParser.SNISSPIData(Byte[] receivedBuff, UInt32 receivedLength, Byte[]& sendBuff, UInt32& sendLength)

The type initializer for 'NetSecurityNative' threw an exception.....

What could be the cause?