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: ERROR_FAILED_TO_DESERIALIZE ..... ..... 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. at Microsoft.Data.Tools.Schema.MsDeploy.MsDeployProviderBaseProviderFactory..cctor() ...
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:
HKLM\Software\Microsoft\IIS Extensions\msdeploy\3\extensibility HKLM\Software\Wow6432Node\Microsoft\IIS Extensions\msdeploy\3\extensibility