Credentials using Invoke-Sqlcmd against sql azure

Vote count:

0

I'm attempting to run a powershell build script against a sql azure database but receiving Login failed for user ''.

I'm fairly convinced the credentials are correct as they were taken straight from the live application config.

This is the command I'm using:

Invoke-Sqlcmd -InputFile "Build.sql" -ServerInstance $server -Database $database -WarningAction SilentlyContinue -OutputSqlErrors $false -Username $username -Password $password -EncryptConnection

I had this working with sqlcmd in a batch file so I'm wondering if it's got anything to do with the way the credentials are being sent, trusted_connection=false doesn't appear to be an option I can try.

asked 3 mins ago

Phil Cooper

640

Credentials using Invoke-Sqlcmd against sql azure