脚本的目的是登录到远程SQLSERVER和执行查询。 我用下面的代码来索要凭据，当连接是打开的，我会检查使用$ conn.state，当其打开，我必须执行查询。
甚至当我放弃无效的凭证，将控制进入交换机- >打开块 ，并得到了发言已记录in.The连接打开 。
clear
$servername = "Someserver";$databasename = "someDB";$c = Get-Credential
$connectionString = [string]::Format( "server={0};database={1};uid={2};pwd= {3};Integrated Security=True;", "$servername", "$databasename",$c.username,$c.GetNetworkCredential().password)
$conn = New-Object system.Data.SqlClient.SqlConnection
$conn.connectionstring = $connectionString
$conn.open()
switch ($conn.State)
{
"Open"{ write-host "Logged in.The connection is $($conn.State)"}
Default{ Write-Host "The connection is $($conn.State).Error connecting db."; }
}
$conn.close()
