A friend of mine requested an ASP.NET photo gallery and I thought the Personal Web Site Starter Kit could be one of the best case. Installation for the local host is not a big deal but the problem got started when I wanted to run the SQL script(Generic SQL Server Scripts for the Personal Site Starter Kit) on the server. Personal Web Site Starter Kit uses memberships and roles for creating users but you cannot execute the tables and SPs with the mentioned SQL script. There is a great tool called aspnet_regsql under %windir%\Microsoft.NET\Framework\v2.0.50727 folder that you can get rid of them problem. Scottgu has a great artilcle about this tool's interface and basic explanation of it.