U4-232 - Wish: Integrated Security Database Option in Installer

Created by Sebastiaan Janssen 16 Aug 2012, 06:52:35 Updated by Sebastiaan Janssen 24 Jul 2013, 08:36:48

Is duplicated by: U4-2332

For SQL Server installations, it would be great if it were possible to choose Integrated Security instead of a standard flat text username and password. Perhaps a radio button for Integrated or Standard?

As far as web.config is concerned, it would simply change the umbracoDbDSN setting from: .;database=umbraco;user id=user;password=pass

To: .;database=umbraco;Integrated Security=true

In many environments, it's best practice to have a single worker account applied to the relevant App Pool in IIS, and give it permission to all parts it will touch including the file system and database.

This is the way we set up all our web apps, including umbraco installations. Currently I am required to set up temporary SQL Server accounts for the sake of umbraco installation / upgrade, and then revert those settings after installation and manually alter web.config.

''Originally created on CodePlex by [Qube|http://www.codeplex.com/site/users/view/Qube]'' on 9/3/2010 1:09:51 AM [Codeplex ID: 28768 - Codeplex Votes: 10]


Michiel van Oosterhout 10 Oct 2012, 21:50:55

Pull request: http://umbraco.codeplex.com/SourceControl/network/forks/michielvoo/UmbracoU4232/contribution/3466

Michiel van Oosterhout 28 Jun 2013, 08:56:25

I have created a pull request for this issue: https://github.com/umbraco/Umbraco-CMS/pull/42

Sebastiaan Janssen 19 Jul 2013, 11:33:47

Pull request accepted and merged into 6.1.3. Thanks! Revs: 8740848aac40258319a4205afb9d4f0bec4382bd / 61d072c8d68149080f689a5254bafc1287a87f37

Priority: Normal

Type: Feature (request)

State: Fixed


Difficulty: Normal


Backwards Compatible: True

Fix Submitted: Pull request

Affected versions:

Due in version: 6.1.3


Story Points: