Solution layout

First off, download the current stable version. The project should be a Microsoft Visual Studio 2010 solution.  The solution should contain 3 solution folders “_SETUP”, “Core” and “Shared”. It also contains a sample website. The Core solution folder has a project called Core as well. The Shared solution folder has 3 projects: Exceptions, Web.DTO and Web.UI. The _SETUP folder contains the installtion files.

Database setup

The solution is based around 2 databases; one for the system and one for users. Currently the database service that has been tested, is Microsoft Sql Server 2008 (so not the express edition).

Installing is not very difficult. Create (by using the management studio tool) a database for the system: Oplaco_SYS (you can give it any name you like) and one for your users: Oplaco_USR. Next create 2 user accounts (Under Security, Logins): dbUsr_Opl_Sys and dbUsr_Opl_USR. Use SQL Server authentication and create a good password. Currently the project does not use password expiration.

Go back to the databases and link the created users to the databases. (Databases, Oplaco_SYS, Security, Users, right mouse click “new user”). For now it is OK to make both user db_owner. (Best is not to do this in production environments).

When this is all done, open the web.config in Visual Studio. Modify the <connectionSttrings> nodes. There is one for the system, called oplacoConnection and one for the members, called oplacoMembersConnection. Modify both entries with the right database (Initial Catalog), usernames and passwords.

When this is done, go back to the management studio and open the sql scripts, located in the _SETUP solution folder. Run the oplaco-ad.sql and after that the classifieds-categories on the Oplaco_SYS database.

For the users database, there are some additional steps to be taken. These are default procedures that belong to the .Net membership provider. Go to C:\Windows\Microsoft.NET\Framework\v2.0.50727 and run aspnet_regsql. Be sure to select the Oplaco_USR database and not the Oplaco_SYS database!

Almost done! One last step is needed, create an admin user. In visual studio select the website project and click on the ASP.Net configuration icon or on the Website menu, click ASP.NET Configuration. Start off with testing your database connections. Click on Provider Configuration, select a different provider for each feature and click on test with the selected radio buttons. Do not change the radio buttons!

If all connections are tested create 3 roles: Administrators, Users and Guests. Located under the security tab. Next create one user, called Admin and assign this user to the Administrators role.

That’s it!



Last edited Apr 5, 2011 at 2:29 PM by chefdog, version 13


No comments yet.