Dbatools Credential issue ?

• Steven.Grzybowski

  Hall of Fame

  Points: 3214

  More actions

  July 11, 2018 at 8:38 am

  #373492

  I am trying to use the Dbatools powershell module, but when I try to pass an AD credential, it is not seeming to work for me. I tried using both Invoke-Sqlcmd2 and Invoke-DbaSqlquery. I am passing a Pscredential object to them as an argument. The $Cred Variable is where I am storing my PSCredential
  Invoke-SqlCmd2 -SqlInstance "DEV01" -Query "SELECT SYSTEM_USER" -Credential $cred
  results in a login failed for the correct user ($cred.UserName)
  Invoke-DbaSqlQuery -SqlInstance "DEV01" -Query "SELECT SYSTEM_USER" -SqlCredential $Cred
  results in a failed login for the user I am using in powershell (not the user from $cred)
  I have checked to make sure that the $cred variable is a valid credential, and I can start a new PowerShell session as the user from $Cred without any issue, and any process I start using start-process runs correctly as the user from $cred. Am I invoking the command(s) incorrectly?

• e 33291

  Grasshopper

  Points: 19

  More actions

  September 13, 2018 at 6:41 am

  #2005572

  In case anyone else comes here from Google, it took some time before I finally figured out what was going on

  It's this issue, still open, in dbatools: https://github.com/sqlcollaborative/dbatools/issues/3780

  Until it gets resolved in a later version, I was able to get my scripts functioning again by installing version 0.9.342:

  Uninstall-Module dbatools
Install-Module dbatools -RequiredVersion 0.9.342