Figure 2-8: Enabling anonymous access in the Web Site Properties dialog box in .NET framework

Encoder Denso QR Bar Code in .NET framework Figure 2-8: Enabling anonymous access in the Web Site Properties dialog box

One of the requirements to run DotNetNuke is access to a database Although you can run DotNetNuke by using various database server systems, the recommended database server is Microsoft SQL Server You can use either version 2000 or version 2005, but any version prior to 2000 is not supported There are other options available such as Microsoft s Database Engine, also referred to as MSDE for short, which is part of the Microsoft Office suite, but this is normally only used in a Web development environment In addition to the somewhat costly Microsoft SQL Server versions 2000 and 2005, the free option of Microsoft SQL Server Express 2005 is also available to you

The first step in creating the database is making sure that you have the database server program installed This chapter assumes this has been installed and is properly configured for you to create new databases and database users After the program is installed and running, you can access the administrative interface by clicking Start All Programs Microsoft SQL Server Enterprise Manager With Enterprise Manager open, click the plus icons until you see folder icons available for your database server name When you can see the folders, right-click the Database folder and select New Database, as shown in Figure 2-9 (Note that if you are using SQL Server 2005, you will be using SQL Server Management Studio rather than Enterprise Manager Aside from that, setup for both SQL Server 2000 and the 2005 version are very similar)

Clicking the new database opens a new window that allows you to give your new database a name It is a good idea to name the database something that allows you to easily identify it, such as the name of the site A very important note here is that you cannot use any periods in the name of the database Doing so causes all calls to the database to look for it in the wrong place

There are several ways to log in to a Microsoft SQL Server database The way you do it depends on how your Microsoft SQL Server is configured, but the most common and secure method is to create a new user in Microsoft SQL Server for each database you want to access To create a login for your

database, you need to expand the Security folder of your database server instance within Enterprise Manager This displays the Login section Rightclick it and select New Login, as shown in Figure 2-10

In the SQL Server Login Properties screen that appears when you select New Login, you need to assign an account name This is the username to log in to Microsoft SQL Server for DotNetNuke Below that section is the Authentication area, where you are presented with two possibilities: Windows Authentication and SQL Server Authentication Sticking with the more common and secure method, select SQL Server Authentication and assign a password This password is also required later on to install DotNetNuke After assigning the username and password, click the OK button You see a new window that asks you to confirm the password you previously entered Click OK in that window as well With the new database user created, all that is left is to give that user proper access and permissions to your DotNetNuke database To do this, right-click your database s Users node in Enterprise Manager Select New Database User from the menu that appears Within the new window that appears, you can select your previously created login by using the Login Name drop-down list box After you select the login, the username is populated and you have to assign the proper DBO (database owner) permissions by choosing the db_owner check box in Figure 2-11 Please be aware that DBO permissions are important because they allow various database calls such as insert and delete to be executed by the DotNetNuke framework and its modules