Issue #1 - Please Read
I strongly recommend using the Standard security for your connection string in your DotNetNuke web.config file for example:
connectionString="Server=sqlserver;Database=PHDnet;uid=sa;pwd=password"
providerName="System.Data.SqlClient" />
It is much faster to program by doing a "build page" and then "refreshing" your page on your browser. This works using Standard Security only.
Otherwise:
name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient"
You will have the following annoying problems:
While in the Visual Studio 2005 IDE, Always detach the Database in Server Explorer before opening IE and browsing to your local developer site.
Alternately, you can just "Ctrl-F5", but this takes longer if compiling many things. This works only because inside Visual Studio 2005, the IDE detaches the database automatically when "Ctrl-F5" is entered. Your "ASPNET" User can then open the database using the single "User Instance". If you leave it attached in the IDE, your browser will find that ASP.net cannot get it open because it was still open inside the IDE, and consequently, DotNetNuke will give you a bunch of errors about it.
Issue #2 -
You Hit Ctrl-F5 or Refresh your Browser and your browser gives you
HTTP Error 403 - Forbidden error.
- Open Control Panel >> Administrative Tools
- Choose "Internet Information Services"
- Navigate down to your "Web Site" which will be under the "Web Sites" folder.
- Right-click the folder and choose "Properties".
- Select the Tab named "Documents"
- Click the "Add" Button and add the file name "default.aspx". and save.
Now your page having your portal can automatically be opened.