title: Connect to SQL Server using powershell
body: <p>I am using this powershell script below to connect to an instance of sql server. I am pretty sure that my username and password are correct. </p>
  
  <blockquote>
    <p>$connectionString = "server={0};database={1};uid={2};pwd={3};"</p>
  </blockquote>
  
  <pre><code>$c = Get-Credential
  Write-Host($ipAddress)
  Write-Host  $c.username 
  Write-Host  $c.GetNetworkCredential().password
  
  $connectionString = [string]::Format( "server={0};database={1};uid={2};pwd={3};", "servername", "databasename",$c.username,$c.GetNetworkCredential().password) 
  #open database connection to SQL Server
  
  Write-Host  $connectionString
  $conn = New-Object system.Data.SqlClient.SqlConnection
  $conn.connectionstring = $connectionString
  $conn.open
  
      switch ($conn.State)
  {
  "Open" { Write-Host "Do some work"; }
  Default { Write-Host "The connection is $($conn.State).  There has been an error connecting to the database."; }
  }
  </code></pre>
  
  <p>It is always falling to the default statement. </p>