test for condition of prateek .net hello

Preparing your SQL Server Database

Setup is still a little bit rough, but easy enough to do if you are familiar with Microsoft SQL Server. The first thing you need to do is to create the data structure. You can put the BlogEngine.NET tables in a new database or create them in an existing database.

The script to create the tables and initial values is included in the setup folder of the web project. You will need to run this script against the database you want to create the tables in. Once the script has completed, you should have a number of new database tables with names beginning with be_ (e.g. be_Posts, be_Settings, etc). The script also inserts some initial data into some of the tables.

Now that you you have the tables setup and the initial values in place, you should think about security while you are here. (How will you connect to the database?) One method is to create a SQLUser and give it access. The database user will only need basic access. Adding the database user to the db_datareader and db_datawriter roles will be sufficient.

Setting up BlogEngine.NET for SQL Server

There are two basic changes that need to be made in BlogEngine.NET.

First, you need to open the web.config file in the root folder. Find the BlogEngine section:

<machineKey decryptionKey="AutoGenerate,IsolateApps"/>

<membership defaultProvider="MSSQLMembershipProvider">
  <providers>
    <clear />
    <!--<add name="XmlMembershipProvider"
             type="BlogEngine.Core.Providers.XmlMembershipProvider, BlogEngine.Core"
             description="XML membership provider"
             passwordFormat="Hashed" />-->
    <add name="MSSQLMembershipProvider"
         type="System.Web.Security.SqlMembershipProvider"
         connectionStringName="BlogEngine"
         applicationName="BlogEngine.NET" />
  </providers>
</membership>

<roleManager defaultProvider="MSSQLRoleProvider" enabled="true"
 cacheRolesInCookie="true" cookieName=".BLOGENGINEROLES">
  <providers>
    <clear />
    <!--<add name="XmlRoleProvider"
             type="BlogEngine.Core.Providers.XmlRoleProvider, BlogEngine.Core"
             description="XML role provider" />-->
    <add name="MSSQLRoleProvider"
         type="System.Web.Security.SqlRoleProvider"
         connectionStringName="BlogEngine"
         applicationName="BlogEngine.NET" />
  </providers>
</roleManager>