Secure and encrypt usernamae/password in PowerShell

Question

Trying to secure/encrypt password in PowerShell.

Right now I have a script that goes through several servers and invoke SQL command.

I used to have the password and username hard coded and I would like to encrypt them due to security purposes.

  $query = @'
 SELECT TOP 10 FROM [dbo].[TABLE]
   '@

 $SERVERS = LIST OF SERVERS

(Get-Credential).Password | ConvertFrom-SecureString | Set-Content "C:\ Password.txt"

$passWord1 = Get-Content "C:\ Password.txt" | ConvertTo-SecureString 
$credential = New-Object System.Management.Automation.PsCredential ('username',$passWord1)

$SQLCredentials = @{
    server = $server
    database = 'databasename'
    Query= $query
    Credential = $credential
}

 $Results  = Invoke-SqlCmd @SQLCredentials 
 $Results | Select-Object -Property * -Skip 1

Also I tried the following but does not seem to work Invoke SQL Command with Secure Creds

error: Invoke-Sqlcmd : A parameter cannot be found that matches parameter name 'Credential'.

Goal is to run Invoke-SqlCmd using secured username and password.

Try `Credential = $credential` instead of `Username = 'username'; Password = $credential`. And change `(''username'$passWord1)` to `('username', $passWord1)`. — Ansgar Wiechers, Sep 16 '19 at 15:20
A parameter cannot be found that matches parameter name 'Crendetial'. Doesn't work. How could I encrypt username as well — usertestREACT, Sep 16 '19 at 15:25
A parameter cannot be found that matches parameter name 'Credential — usertestREACT, Sep 16 '19 at 15:31
I saw my mistake before, I corrected but still not going through — usertestREACT, Sep 16 '19 at 15:32
Then you need to use `Password = $credential.GetNetworkCredential().Password`. — Ansgar Wiechers, Sep 16 '19 at 15:34
I tried that as well and did not work , as I mentioned on my question - the link — usertestREACT, Sep 16 '19 at 15:35
There's still a comma missing in the `PSCredential` object creation. — Ansgar Wiechers, Sep 16 '19 at 15:35
where would I implement Password = $credential.GetNetworkCredential().Password ? — usertestREACT, Sep 16 '19 at 15:36
In the `$SQLCredentials` hashtable, obviously. And now `$password1` in the credential object creation is missing the `$`. Please pay attention. — Ansgar Wiechers, Sep 16 '19 at 15:43
That is exactly what I have right now on my code - and still not going through. The question is not edited correctly — usertestREACT, Sep 16 '19 at 15:52
To be clear, please [edit] your question and show a [mcve] of the code you *currently* have as well as the full error you're getting from that code. — Ansgar Wiechers, Sep 16 '19 at 16:04
Some versions of invoke-sqlcmd *don't* have the -credential parameter. — js2010, Sep 16 '19 at 17:21
If it's "all there", then why do I see a "Credential" value instead of the "Username" and "Password" values I told you to use (since the former apparently doesn't work)? — Ansgar Wiechers, Sep 16 '19 at 20:08

score 1 · Accepted Answer · answered Sep 16 '19 at 17:21

1

Some versions of invoke-sqlcmd don't have the -credential parameter: PowerShell: invoke-sqlcmd with Get-Credential doesn't work (Actually, I don't either.)

answered Sep 16 '19 at 17:21

js2010

23,033
6
64
66

What's the error message for the one that has a -credential parameter? – js2010 Sep 16 '19 at 18:04
A parameter cannot be found that matches parameter name 'Credential' – usertestREACT Sep 16 '19 at 18:15

Secure and encrypt usernamae/password in PowerShell

1 Answers1