title: How can I connect to SQL through PowerShell using Windows authentication other than my local one?
body: <p>Here's my current code:</p>
  
  <pre><code>[string] $Server= "server"
  [string] $Database = "database"
  [string] $UserSqlQuery= $("SELECT * FROM [dbo].[User]")
  [string] $UserID = "userid"
  [string] $Pass = "pass"
  
  $resultsDataTable = New-Object System.Data.DataTable
  $resultsDataTable = ExecuteSqlQuery $Server $Database $UserSqlQuery $UserId $Pass
  
  # executes a query and populates the $datatable with the data
  function ExecuteSqlQuery ($Server, $Database, $SQLQuery, $UserID, $Pass) {
      $Datatable = New-Object System.Data.DataTable
  
      $Connection = New-Object System.Data.SQLClient.SQLConnection
      $Connection.ConnectionString = "server='$Server';database='$Database';trusted_connection=true;User ID = '$UserID';Password='$Pass';"
      $Connection.Open()
      $Command = New-Object System.Data.SQLClient.SQLCommand
      $Command.Connection = $Connection
      $Command.CommandText = $SQLQuery
      $Reader = $Command.ExecuteReader()
      $Datatable.Load($Reader)
      $Connection.Close()
  
      return $Datatable
  }
  
  #validate we got data
  Write-Host ("The table contains: " + $resultsDataTable.Rows.Count + " rows")
  </code></pre>
  
  <p>So I realize I can replace UserID and Password with Integrated Security=true in order to use Windows authentication.  The problem is I'm trying to use a Windows authentication other than my current one to get on SQL.  Is there any way to do this?  Thanks.</p>