Hello Im testing the runbook, but i get the next message. I have already enable the firewall rules and created the user in the database
Invoke-Sqlcmd : Cannot open database "********.database.windows.net" requested by the login. The login
failed.
Login failed for user '******'.
At line:6 char:16
+ ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException
+ FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand
Invoke-Sqlcmd :
At line:6 char:16
+ ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ParserError: (:) [Invoke-Sqlcmd], ParserException
+ FullyQualifiedErrorId : ExecutionFailureException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand
Any ideas
Thanks in advance