I'm building a package for a Web App Gallery. One of the testing conditions is to be able to publish the web site from the WebMatrix via Web Deploy. So I deployed a test Windows Server 2008, configured Web Management Service (WMSvc) and now try to validate
the conection. The connection to the Web Deploy Handler is successful, but WebMatrix informs, that it can't access the database. Database connection string is 100% valid, the computer has access to the SQL Server and I can manage this DB in WebMatrix, but
still get this strange warning. What could be the problem? [img]http://dl.dropbox.com/u/11817160/webmatrix.png[/img]
This usually means that the Web Deploy delegation rules (set up on the server) are not allowing the
web server to talk to the database. Instead of trying to configure these manually, I believe there is now UI inside IIS Manager to configure this for you and generate a .publishsettings file you can use in the WebMatrix publish settings dialog.
justonce
1 Post
The remote server connection succeeded, but Microsoft WebMatrix cannot access databases.
Jun 15, 2011 07:55 AM|LINK
database WebMatrix Web deploy
simtan
282 Posts
Microsoft
Re: The remote server connection succeeded, but Microsoft WebMatrix cannot access databases.
Jun 16, 2011 05:08 AM|LINK
This usually means that the Web Deploy delegation rules (set up on the server) are not allowing the web server to talk to the database. Instead of trying to configure these manually, I believe there is now UI inside IIS Manager to configure this for you and generate a .publishsettings file you can use in the WebMatrix publish settings dialog.
Please see this article:
http://learn.iis.net/page.aspx/984/configure-site-for-web-deploy-publishing/
Program Manager
Web Platform and Tools