Test a given connection string and provide details about the connection.
Test-ConnectionString.ps1 [-ConnectionString] <String> [-Details] [-ProgressAction <ActionPreference>]
[<CommonParameters>]
Test-ConnectionString.ps1 'Server=(localdb)\ProjectsV13;Integrated Security=SSPI;Encrypt=True'
ServerName : SERVERNAME\LOCALDB#DCCC9EEC AppName : Core Microsoft SqlClient Data Provider LocalRunAsAdmin : False ConnectingAsUser : SERVERNAME\username SqlInstance : (localdb)\ProjectsV13 LocalWindows : 10.0.19045.0 InstanceName : LOCALDB#DCCC9EEC DatabaseName : master AuthType : Windows Authentication Integrated Security : True Data Source : (localdb)\ProjectsV13 ConnectSuccess : True Workstation ID : SERVERNAME AuthScheme : NTLM ComputerName : SERVERNAME Encrypt : True LocalCLR : TcpPort : 1433 LocalPowerShell : 7.3.9 NetBiosName : SERVERNAME Edition : Express Edition (64-bit) IPAddress : 192.168.1.223 ServerTime : 2023-11-10 12:14:09 DomainName : WORKGROUP Server : [(localdb)\ProjectsV13] IsPingable : True LocalEdition : Core Pooling : True LocalDomainUser : False MachineName : SERVERNAME SqlVersion : 13.0.4001 LocalSMOVersion : 17.100.0.0
Type: String
Parameter Sets: (All)
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.