Setting Up a New Database for Community Server 2008

This procedure describes the manual setup of a new database for Community Server 2008 with ASP.NET 2.0.

Procedure

1. Download Community Server 2008 to your server.
2. Use SQL Server to create a new database called CommunityServer.
3. Specify the login access to the CommunityServer database.  
   • If you are using Windows Authentication, enabled Integrated Security. If you are setting up your database on a development or test machine, you can run the user.sql file.
   • If you are using SQL Authentication, use Enterprise Manager to grant your SQL login access to the database.

   At a minimum, you should create the following database roles for Community Server:

   • db_securityadmin
   • db_ddladmin
   • db_datareader
   • db_datawriter
4. Copy the cs._4.0_CreateFullDatabase.sql file to the CommunityServer database.
5. Execute cs._4.0_CreateFullDatabase.sql.
6. Create a new community by running the cs_system_CreateCommunity stored procedure:

exec dbo.cs_system_CreateCommunity 'localhost/cs', 'dev', 'admin@example.org', 'AdminUserName', 'AdminPassword', 0, 0

Where localhost/cs = your URL, and admin info = your values.

You can create a sample blog and media gallery by running the following script:

exec dbo.cs_system_CreateCommunity 'localhost/cs', 'dev', 'admin@example.org', 'AdminUserName', 'AdminPassword', 0, 1

For example:

exec dbo.cs_system_CreateCommunity 'localhost/cs', 'dev', 'admin@example.org', 'AdminUserName', 'AdminPassword', 0, 1