Deployment to IIS (XP and Windows Server)

· This procedure assumes integrated security method is used.
· In physical folder properties give permission to user ASPNET
· Browse to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and give permission to DB and its log file there.
· Go into Sql server management studio, select security folder -> logins folder ...choose most of the
· Required logins especially ASPNET and NETWORK SERVICE, select properties, choose User Mapping and select the db in question and then select 'db_datareader' and 'db_datawriter' role memberships.
· To prevent firefox from asking for authentication…go into IIS manager and select properties of the virtual directory...choose directory security...press edit...click browse on anonymous access...specify an admin password for the current pc...put its password..uncheck allow iis to control password...press ok. Troubleshooting: Make sure to set it to anonymous password or reset the password if system administrator password is changed.
· Conn. Str in web.config <add name="Lungar ProjectConnectionString" connectionString="Data Source=(local);Initial Catalog=LP;User Id=sa; Password=admin;Persist Security Info=True;Min Pool Size=5" providerName="System.Data.SqlClient" /> (only for Windows Server 2003)
· Change DB Name to LP in SSMS (only for Windows Server 2003)
· Select version 2.0 in IIS website or Virtual Directory properties ASP.NET tab.
Make sure file permissions of the directory are given to child objects as well if contents in the directory is copied again.