web.config for dotnetnuke

1.to change database from sql server 2k to access,modify <data defaultProvider="AccessDataProvider" > in web.config the item of defaultProvider="AccessDataProvider" from "SqlDataProvider".

this meets some error--D:\DRIVERS\develop\language\dotnet\DotNetNuke\faq\Domain Name -localhost_dotnetnuke Does Not Exist In The Database.htm

2.Two database types of web.config

a)Access

unchanged after unzip the dotnetnuke,read readme.txt of D:\DRIVERS\develop\language\dotnet\DotNetNuke\DotNetNuke_2.0.3\Documentation

    second,according to the question of 对路径“N:\Inetpub\wwwroot\test\portal\Nuke_Access\verify”的访问被拒绝。
    the answer is as below:
    Using Windows Explorer, browse to the root folder of the website ( C:\DotNetNuke by default ). Right-click the folder and select Sharing and Security from the popup menu ( please note that if you are using Windows XP you may need to Enable Simple File Sharing before these options are displayed ). Select the Security tab. Add the appropriate User Account and set the Permissions.

If using Windows 2003 - IIS6
- the {Server}/NetworkService User Account must have Read, Write, and Change Control of the virtual root of your website

b)sql server 2k

-------
    <appSettings>
  <add key="connectionString" value="Server=rr-zpu9fk7zudgd;Database=DotNetNuke;uid=sa;pwd=;" />
</appSettings>
   --------
   <data defaultProvider="SqlDataProvider" >
            <providers>
    <clear/>
                <add name = "SqlDataProvider"
                        type = "DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
                        connectionString = "Server=rr-zpu9fk7zudgd;Database=DotNetNuke;uid=sa;pwd=;"
                     providerPath = "~\Providers\DataProviders\SqlDataProvider\"
                        objectQualifier = ""
                        databaseOwner = "dbo"
                />
   ------------

3)For dotnetnuke 4.0 installation, change release.config as follows:2005年11月26日
1.if use sql server 2005 Express, just change release.config's name to web.config. i don't try further installation .

2.if use sql server 2k/2005,need to change <connectionstrings> setting and <appSettings>,to do these,first change
comment mark to uneffect connectionStrings or appSettings for sql server 2005 Express, and to effect for
sql server 2k/2005, the result should be as below:
<connectionStrings>
    
    <add
      name="DotNetNuke"
      connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
      providerName="System.Data.SqlClient" />

</connectionStrings>
<appSettings>
    <add key="DotNetNuke" value="Data Source=.\SQLExpress;Database=DotNetNuke_4;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Website.mdf;" />
    
    <add key="DotNetNuke" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>