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?

Marko Oja · Accepted Answer · 2019-12-14 14:42:01Z

0

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.

answered Dec 14, 2019 at 14:42

Marko Oja

113 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hugh Lin Over a year ago

Really thanks for sharing your solution here, if so, would you please Accept your solution as an Answer ? So it would be helpful for other members who get the same issue to find the solution easily. Have a nice day:)

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related