Initialize Deployment faulted when using dacservices.Deploy #435
Unanswered
HarryHaworth
asked this question in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Within my .NET v4.8 web application, I am receiving the following exception:
Exception thrown: 'System.AggregateException' in Microsoft.SqlServer.Dac.dll
Deployment exception: The number of retries has exceeded the maximum of 3 attempt(s).
Deployment exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBName" requested by the login. The login failed.
Login failed for user 'USER'.
Here are the message logs:
Deployment Pending: Initializing deployment
Deployment Pending: Analyzing deployment plan
Deployment Pending: Updating database
Deployment Pending: Creating deployment plan
Deployment Pending: Verifying deployment plan
Deployment Pending: Deploying package to database
Deployment Running: Creating deployment plan
Deployment Running: Initializing deployment
[Message] SQL: Initializing deployment (Start)
Deployment failed: Initializing deployment
[Message] SQL: Initializing deployment (Failed)
Deployment failed: Creating deployment plan
Deployment failed: Verifying deployment plan
Deployment failed: Deploying package to database
This error doesn't throw on a previously working branch, using the same exact method of deployment, credentials / connection & dacpac file to be deployed. I believe this connection error is masking the actual issue, which I believe lies within the package dependencies. I have reverted all package / dependencies to the correct version (microsoft.SqlServer.DacFx v162.2.111) yet still no luck.
Any ideas?
Beta Was this translation helpful? Give feedback.
All reactions