Azure SQL Database DevOps Release pipeline returns Error CREATE DATABASE permission denied

Question

I have created build and release pipelines for Azure SQL Database according to these instructions.

I am able to publish my database project directly from Visual Studio. My Build pipeline works without problems. However on release pipeline I am getting the following error:

Error SQL72014: .Net SqlClient Data Provider: Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'master'. Error SQL72045: Script execution error. The executed script: CREATE DATABASE [$(Datab aseName)] COLLATE SQL_Latin1_General_CP1_CI_AS;

Any idea what I may be doing wrong or how to find where the problem is?

Answer 1

Feeling a bit stupid right about now. I finally found how to debug the pipeline (variable system.debug = true) and it was telling me that it can't find the database defined. Which I had mistyped. However the error without the debugging option was NOT helpful :D So if anyone is getting this error they should recheck connection information.