Brief installation of dotnetnuke SQL

Recently, there have been more and more people studying dotnetnuke in the blog Park. I have read a series of introductions about it and gained a lot from it :)
I have also studied it some time ago, but I am not interested in it any more. I have no place to talk about it. I don't know how to solve it when I encounter any problems :)
Now I have read the introduction of Chinese rainbow and the source of inspiration, and have a strong interest in research (PS: The functions you mentioned are becoming more and more attractive to me, and the other point is Code It's VB, better suited to my appetite)

Last night, with Kingsoft 2003, I simply read several documents in the built-in documentation folder and got a rough idea (just a guess ). Dotnetnuke uses the ACCESS database by default, so I will only talk about the brief installation of SQL database.

1. Create a database named dotnetnuke
2. Modify the database configuration of Web. confing<Appsettings>
<AddKey= "Connectionstring"Value= "Server = localhost; database = dotnetnuke; uid = sa; Pwd = ;" />
</Appsettings>

Server: SQL Server Name
Database: Database Name
UID: Login Name
PWD: Password   < Data Defaultprovider = "Accessdataprovider"   >
< Providers >
< Clear />
< Add Name = "Sqldataprovider"  
Type = "Dotnetnuke. Data. sqldataprovider, dotnetnuke. sqldataprovider"  
Connectionstring = "Server = localhost; database = dotnetnuke; uid =; Pwd = ;"  
Providerpath = "~ Providersdataproviderssqldataprovider"  
Objectqualifier = ""  
Databaseowner = "DBO"
Upgradeconnectionstring = ""
/>
< Add Name = "Accessdataprovider"  
Type = "Dotnetnuke. Data. accessdataprovider, dotnetnuke. accessdataprovider"  
Connectionstring = "Provider = Microsoft. Jet. oledb.4.0 ;"
Providerpath = "~ Providersdataprovidersaccessdataprovider"  
Objectqualifier = "Dotnetnuke"  
Databasefilename = "Dotnetnuke. MDB. Resources"
/>
</ Providers >
</ Data >

Above Defaultprovider = "Accessdataprovider" the default database is access. Change it to defaultprovider =" sqldataprovider " ,
In addition, set connectionstring = "Server = localhost; database = dotnetnuke; uid =; Pwd =; " modify it based on your SQL statement, and set it to objectqualifier =" "write short for, such as obje Ctqualifier = "dnn"
simplified, configure the virtual directory named dotnetnuke for IIS and direct it to your dotnetnuke folder.
enter http: // localhost/dotnetnuke for the browser, and then open your SQL database, dotnetnuke table, found? The table and stored procedure have been automatically created.
well, I will study the table and stored procedure in the future. I hope to talk with you later.
note:
yesterday, it seems that when someone installed SQL, the Program RUN error:
dotnetnuke upgrade error
the assembly version ([assemblyversion]) does not match the database version ([databaseversion])

error: cocould not connect to database specified in connectionstring for sqldataprovider
the user name or password of your connectionstring to connect to the SQL string is incorrect, you only need to change the user name or password to solve this problem