CODEWITHSUNDEEP
asp.netvisual-studio-2012sql-server-2012webdeploydatabase-deployment
Mikhail
Mikhail

Reputation: 21749

Update database feature not working in Publish Web dialog in Visual Studio 2012

I'm developing an ASP.NET Web Forms application under Visual Studio 2012. I'm using Web Deploy and Publish Web dialog for application deploy. I'm trying to deploy a database schema using the Update database feature. I entered a connection string pointing to remote SQL Server. If I click the "Test connection" button Visual Studio says test connection is succeeded.

enter image description here

Then I go to Preview tab and click the Preview database link.

enter image description here

And in the opened window I have the message

Web deployment task failed. (Could not generate deployment script. Unable to connect to target server. Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_EXECUTING_METHOD.)

Other project files are deployed normally. I'm able to connect to SQL Server using SQL Server Management Service. But why the database could not be updated? I tried to disable server firewall - with no luck.

Update

All works fine if I use SQL Server Authentication with the sa login instead of Windows Authentication in connection string for DatabaseEntitiesRaw. But Windows Authentication works fine for SSMS, and I want to use it since I'm deploying only from computers within my company's domain. Is it true that dbDacFx doesn't work with Windows Authentication?

Upvotes: 4

Views: 4997

Answers (1)

Raiden
Raiden

Reputation: 31

Deploy script runs from AUTHORITY\LOCAL SERVICE user, so you have to add this user to SQL server. Do not foget to add db_owner role for the user.

Upvotes: 3

Related Questions