blog.atwork.at

news and know-how 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