File: D:/HostingSpaces/HKemperman1/osthoes.nl/wwwroot/Documentation/StarterKit/SQLServer2005Config.html
<html>
<head>
<title>DotNetNuke</title>
<link rel="stylesheet" type="text/css" href="Documents.css">
</head>
<body bottommargin="5" leftmargin="5" topmargin="5" rightmargin="5" marginwidth="0"
marginheight="0">
<img src="logo.gif" border="0">
<h1>Configuring SQL Server 2005 for DotNetNuke</h1>
<p>This section includes more detailed information on how to create and configure a SQL Server 2005 database for use with DotNetNuke.</p>
<p>1. In SQL Server Management Studio, in the Object Explorer, Select Databases for
the SQL Server instance you wish to use, right-click and select the New Database
option.</p>
<p style="text-align:center"><img src="images/New2005Database.jpg" align="middle" /></p>
<p>2. In the New Database dialog give the Database a name (in the example below the
Databse is called Website), and click OK.</p>
<p style="text-align:center"><img src="images/Database2005Properties.jpg" align="middle" /></p>
<p>3. If you decide to use SQL Server Authorization then you will need to use a SQL
Server Login. If you do not already have one created then you can create one
by selecting Logins under Security, right click and select New Login.</p>
<p style="text-align:center"><img src="images/New2005Login.jpg" align="middle" /></p>
<p>4. Once you have created a Login you need to add that "Login" as a User for your new Database. To do this select the Database you just created, select the
Users section, right click on Users and select the New Database User option.
In the example shown below we are using the Database - DotNetNuke.</p>
<p style="text-align:center"><img src="images/New2005User.jpg" align="middle" /></p>
<p>5. Enter the Login name in the text box, or choose the login name by clicking the
elipsis button (...), make sure that the db_owner role, and Schema are selected, and click OK</p>
<p style="text-align:center"><img src="images/User2005Properties.jpg" align="middle" /></p>
<p>Your database is now ready to be installed.</p>
<p>Back to <a href="Welcome.html#Step1">Welcome page</a>.</p>
<hr />
</body>
</html>