MIssing functions like "Set-CVSQLInstance"

[joaval]

We're using SQL Server agent.
I want to set

• SQL Server Property (SQL Agent authentication)
  and/or
• SQL Server:InstanceName (Accounts)

Override Higher Level Settings -> Impersonate User -> User Name = xxxx
Override Higher Level Settings -> Impersonate User -> Password = xxxx

There is the cmdlets 'Get-CVSQLInstance' but no 'Set-CVSQLInstance'
Example:
$sqlallprop = Get-CVSQLInstance -ClientName xxxxxx -AllProperties
$sqlallprop.auth
UseLSA Override credential

---

 1        0 @{password=; userName=}

$sqlallprop.auth.credential
password userName

---

If setting in the GUI it might look like:

$sqlallprop.auth.credential
password userName

---

sjshfshfkhfkhdsfr23498r09faohofhohkjedhy2ewewe he= XXXX\yyyyyyyy

Would like to set username & password perhaps by a Credential object.

Or is there another way to set SQL Server Properties like described.

[JnaneshD05]

Will check this and get back.