嗨,我正试图使用Azure Runbook在我的一个数据库上运行SQL查询。下面列出了我的设置。当我测试它时,我得到了错误The target principal name is incorrect. Cannot generate SSPI context."
,我四处查看了一下,没有发现任何与Azure设置相关的内容。有人有什么想法吗?
$myCred = Get-AutomationPSCredential -Name 'my-cred'
$userName = $myCred.UserName
$securePassword = $myCred.Password
$password = $myCred.GetNetworkCredential().Password
#Query to execute
# Invoke to Azure SQL DB
invoke-sqlcmd2 -ServerInstance $ServerName -Database $DatabaseName -Credential $SQLServerCred -Query $SqlQuery -Encrypt
如注释中所述,看起来您以前没有设置$SQLServerCred
。
尝试:
$myCred = Get-AutomationPSCredential -Name 'my-cred'
$userName = $myCred.UserName
$securePassword = $myCred.Password
$SQLServerCred = New-Object System.Management.Automation.PSCredential($userName , $securePassword)
#Query to execute
# Invoke to Azure SQL DB
invoke-sqlcmd2 -ServerInstance $ServerName -Database $DatabaseName -Credential $SQLServerCred -Query $SqlQuery -Encrypt