dbatools, DbcCheck Does not use Saved credential
1
vote
0
answers
159
views
Last week I deployed **dbccheck** on the production environment. I found strange thing and have no idea what the problem is.
We have 40 db vm's which are not domain joined. Each of db vm's have same windows login credential and DB with sql server authentication having sysadmin privilege and
are configured as below.
I need to run without providing credential manually.
It looks like the dbachecks module is up to date:
Set-DbcConfig -Name policy.storage.backuppath -Value \\backup\userfull
Set-DbcConfig -Name app.sqlinstance -Value 10.1.1.1
Set-DbcConfig -Name app.computername -Value DB-22
Set-DbcConfig -Name app.sqlcredential (Get-Credential Username)
`Set-DbcConfig -Name policy.ola.userfullretention -value 47
`
Whenever I run the below command with manually passed credentials, it works fine but if I remove the (-SqlCredential (Get-Credential username))
and run.
it fails.
`Invoke-DbcCheck backuppathaccess, UserFull,FailedJob, olainstalled, Storage -SqlCredential (Get-Credential username) -Show Summary -PassThru | Update-DbcPowerBiDataSource -Environment Production
Start-DbcPowerBi`


Asked by kedar
(23 rep)
Feb 3, 2023, 04:09 PM
Last activity: Feb 3, 2023, 07:55 PM
Last activity: Feb 3, 2023, 07:55 PM