PowerShell => MS SQL - just to verify that a connection is correctly setup.This is equivalent to "The UDL trick" #PowerShell #SQL #Windows

new_gist_file_0

# Open a connection to the SQL Server Database Engine
$sqlConnection = New-Object System.Data.SqlClient.SqlConnection
$sqlConnection.ConnectionString = "Server=SQLDB2016\SHAREPOINT;Database=master;Integrated Security=True"
$sqlConnection.Open()

# Query the master database
$sqlCommand = New-Object System.Data.SqlClient.SqlCommand
$sqlCommand.CommandText = "SELECT name FROM [master].[sys].[databases]"
$sqlCommand.Connection = $sqlConnection

$sqlDataAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$sqlDataAdapter.SelectCommand = $sqlCommand
 
$dataSet = New-Object System.Data.DataSet
$sqlDataAdapter.Fill($dataSet)

# Close the SQL Server connection
$sqlConnection.Close()

# Dump out the results
$dataSet.Tables