Unable to publish site with Microsoft Web Deploy
Microsoft WebMatrix -> New -> Empty Site -> Publish -> Import publish profile -> Validate Connection failed.
At the same time in the Windows Event Viewer in "Applications and Services Logs" ->"Microsoft Web Deploy" you could find an error event from 'Web Deploy' with the following content in the Event Data
A tracing deployment agent exception occurred that was propagated to the client. Request ID '63e3c480-7cc9-4b24-89dd-26e3cceae8a8'. Request Timestamp: '4/24/2014 5:05:48 AM'. Error Details:
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Data.Tools.Schema.Sql Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
The problem registry key is installed by MS SQL
Find the key in the Windows registry under the following paths that points the problem assembly and delete it: