Hi,
I read many people screaming for help when I also came across the same problem.
It took around 2 hours to crack the problem but finally it was done. Here is the solution for you guys…
My system configuration is: XP + VS2005 + SQL Server 2005 Express
Let’s start solving problem with few checks.
- You have unzipped the directory let’s say in d:\dnn
- Virtual directory let’s say dnn is created in IIS which points to d:\dnn\website
- Virtual directory has enough rights in IIS e.g. Read, Write, Execute….
- ASP.Net framework version number is 2.0.50727 in Asp.Net tab of IIS.
- In Directory Security tab of IIS we have Integrated Windows Authentication “checked”.
Now let’s check rights on the d:\dnn:\website directory
1. Network full rights (in case d drive is NTFS).
2. Network services full rights (in case d drive is NTFS).
3. ASPNET account full rights.
4. SQL Server (All 3 services) full rights.
Right click folder -> Properties -> security -> Add -> Advanced -> Find Now.
You will find 3 services starting with SQL. All should be given full rights.
One important thing to note is: I have database.mdf in my App_Data folder.
Log into SQL server and detach database.mdf file.
Make sure that while detaching “Drop connection” and “Update Statistics” checkboxes are checked.
Now, make sure that
d:\dnn:\website\app_data has above mentioned rights as well.
Now go to d:\dnn:\website\app_data \database.mdf file and apply all above mentioned rights.
Same for d:\dnn:\website\app_data \database_log.ldf.
If they already have those rights then.. it’s fine.
Bingo…. You are done…
have patients… it will take some time…
Wait… still if it’s not done ? …. Go to command prompt…. And type “iisreset”
This solution worked for me … if you have Windows 2003 then you might have to look for some more settings…
I hope, I have not forgotten any steps in hastiness… J
If so… write me back …
Cheers!
Sraddhan.