question

arielman2304-0180 avatar image
0 Votes"
arielman2304-0180 asked SeeyaXi-msft commented

sqlpackage publish action permissions issue

Hi,
I'm running the below sqlpackage command against my sqlserver:

 sqlpackage /action:Publish /SourceFile:"Database Services\bin\Release\Database Services.dacpac" /TargetConnectionString:"Data Source=${Env};Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;Initial catalog=${Target}"

It contains one predeploy script with one alter.
However, I see in the error it tries to alter the whole DB (one level up) instead just doing the alter. any idea why? does it related to some flags I need to add?
https://docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-publish?view=sql-server-ver15#properties-specific-to-the-publish-action

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @arielman2304-0180,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it dosn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @arielman2304-0180,

Is there any error detail, please post it.
Here is a blog of deployment common problems and solutions.
https://stackoverflow.com/questions/57370013/azuredevops-azure-sql-server-deployment-problems-and-solution

Once I tried to deploy it against sqlserver prod server it stuck (the jenkins job is already running 30 minutes) with

Automatically restart the Jenkins Windows Service if it crashes or is accidentally shut down. Ensure that your integration environment achieves 100% uptime.

Best regards,
Seeya

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.