ASP.NET 2.0 Personalization and Membership under Windows Vista

If you are have issues getting 2.0 membership and personalization running under Vista then you are not alone: there seems to be security issues dynamically creating the database.

Luckily the workaround is pretty straight forward, all you have to do is:

1.  Install SQL Server 2005 Developer edition

2. Create a Database

3. Run the ASPNET_REGSQL utlity 

4. Tell ASP.NET 2.0 to use this database with


<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=aspnet;Persist Security Info=True;User ID=sa;Password=Pwd;Pooling=False"/>


Luckily ScottGu has documented these steps  at:

Skip to main content