Kristina Olson's Blog

In order to enable certain database functionality in the “Refresh” (v1.1) release of the Web Deployment Tool the Web Deploy UI in inetmgr took on a new dependency related to SQL Server Management Objects (“SMO”). In RTW (v1.0) you could do dbFullSql operations in the UI on a remote server when remote managing as long as the remote server had SMO installed, but with Refresh Web Deploy UI, SMO must be installed locally to do dbFullSql operations.

The Web Platform Installer (WebPI) and the Web Deployment Tool (Web Deploy) UI in inetmgr both provide a way for packages to support offering multiple data storage options (such as a choice between SQL and MySQL) in the same package. Package creators can use parameter tagging to access this functionality, which is then surfaced to the end-user as a drop-down choice.

New in the v1.1 release of the Web Deployment Tool (MSDeploy) is the ability to deploy .sql scripts which use SQLCMDs such as “:setvar” (a.k.a. TS Data scripts).  Additionally, when using such scripts during the import or export of a package in the UI, :setvar variables will be automatically parameterized.

Outlining how the Web Deployment Tool works for remote management using Inetmgr and what has changed between the v1.0 RTW release and the recent v1.1 “refresh” release.

The Web Deployment Tool provides a way to delegate application creation to non-Administrator Windows users or IIS users. This blog covers how to configure this particular delegated setting. If you have not yet set up some users, or are not familiar with remote administration, I highly recommend going through this walkthrough: http://learn.iis.net/page.aspx/159/configuring-remote-administration-and-feature-delegation-in-iis-70/ before trying out these steps.

This blog outlines the basic steps for setting up IIS Manager accounts so that they may be used for Web Deployment Tool delegation. 

Dynamic IP Restrictions (DIPR) was created to give users a tool to help mitigate the effects of DOS attacks and certain brute-force password breaking attempts. The Out-Of-Band (OOB) feature description is (perhaps more elegantly) outlined on this page: http://www.iis.net/extensions/DynamicIPRestrictions. In short, it is a handy tool that is easy to configure to protect a site/server from certain attacks.