Connections to Azure SQL DW failed due to login issue

[giri9949]

I've got a sql-db instance on the same server as my azure data warehouse.

When executing the below query:

mssql-scripter -S server.database.windows.net -d sqldw -U not-server-admin --target-server-version AzureDW -f C:\Users\somewhere --file-per-object --exclude-use-database --display-progress --exclude-headers

I get the below error, about connecting to a database unrelated to the command.

Error details: Microsoft.SqlServer.Management.SqlScriptPublish.SqlScriptPublishException: An error occurred while scripting the objects. ---> Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server server.database.windows.net. ---> System.Data.SqlClient.SqlException: The server principal "not-server-admin" is not able to access the database "an-azure-sql-db" under the current security context. Cannot open database "an-azure-sql-db" requested by the login. The login failed. Login failed for user 'not-server-admin'.

[bbct]

When connecting to an Azure db, try using --connection-string parameter instead of -S, -d, -U, and -P parameters.