Sample Header Ad - 728x90

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. 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` Running Invoke-DbcCheck   backuppathaccess, UserFull,FailedJob, olainstalled, Storage I need to run without providing credential manually. It looks like the dbachecks module is up to date: Dbachecks Version
Asked by kedar (23 rep)
Feb 3, 2023, 04:09 PM
Last activity: Feb 3, 2023, 07:55 PM