I am developing an ASP.NET Web Forms application in Visual Studio 2012. I am using the Web Deploy and Publish Web dialog to deploy the application. I am trying to deploy a database schema using the Update Database feature. I entered a connection string pointing to the remote SQL Server. If I click the Test Connection button, Visual Studio will report that the test connection was successful.
Then go to the "Preview" tab and click on the "View Database" link.
And in the window that opens, I have a message
Failed to complete network deployment task. (Failed to create deployment script. Unable to connect to target server. Find out more: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_EXECUTING_METHOD .)
Other project files are deployed normally. I can connect to SQL Server using the SQL Server Management Service. But why can't the database be updated? I tried disabling the server firewall - no luck.
- Visual Studio Professional 2012
- SQL Server 2012
- Web Deployment 3.0
Update
, SQL Server sa Windows DatabaseEntitiesRaw. Windows SSMS, , . , dbDacFx Windows Authentication?