How to Install DotNetNuke 4.3.x
|1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11|
|7. Create your database. We are installing for SQL 2000, but the process is essentially similar for SQL 2005. |
a. First, open Enterprise Manager, and create a new database. I am calling mine dnn_fingerfuel, but you can call the database anything you want:
b. Once you’ve added the database, create a user with the proper permissions for DotNetNuke. The user needs to have a minimum of db_owner of the database (in this case, ‘dnn_fingerfuel’). Navigate to the ‘Security’ folder (on same level as the ‘Databases’ folder above), click open the ‘Security’ folder, and right-click on the ‘Logins’ node. Select the ‘New Login’ menu item.
I named the database ‘dnn_Fingerfuel’, but again, you can name it anything you want. Make sure you make the default database for this user the DNN Database you created. In my example, the default database I assigned was ‘dnn_Fingerfuel’…
As you can see in the picture above, I have selected SQL Authentication. I have created a username: dnn_ff_dbo and a password: mypassword. We will be adding these details to the web.config file (uid and pwd). You can also select Windows Authentication if you wish.
Make sure that your user for the DNN Database (in my example, ‘dnn_Fingerfuel’) has db_owner privileges: