blog.atwork.at

news and infos about microsoft, technology, cloud and more

Using Web Platform Installer with remote database support

Web Platform Installer (WPI) is awesome. You get the installer as download from http://www.microsoft.com/web/ . WPI enables the installation of a server feature or a ready-to-use product with some mouse clicks!

If you want to install a product like f.e. Umbraco CMS, WPI installs all the necessary components on your local machine. Well, that´s great.

image

But – if you need SQL Server – maybe you already have an extra machine for your databases?

The problem: WPI does not know anything about outside of your local machine. So WPI tries to install all components or necessary products locally. In most cases that´s ok. But not if you don´t want an extra instance of SQL Server Express on your webserver.

The real problem in that case is: Without known SQL server you can´t install solutions with WPI which need SQL Server. So there´s no way without installing a local version of SQL Express… or?

The solution to that is so simple that it´s often not seen!

Before installing the selected product, go to “Options” in the WPI screen.

image

Enable “Remote Database server” and fill in your remote database server (or IP-address).

image

Now install your application. The configuration wizard now knows your remote database server.

image

Of course you need SQL Server credentials, in a domain or in mixed mode for authenticating against the server. WPI asks for the credentials in the next steps.

image

Cool and easy – Go on and try your apps with WPI!

Loading