Andri Yadi

My First Post - How to get started with Community Server 2007 SDK using VS 2008 and IIS in Windows Vista

OK, I know for quite long time I wasn't involved in .NET community by online. I have my reasons; someday I'll share with you.

For this first post, I'll share to you about How to get started with Community Server 2007 SDK using VS 2008 and IIS in Vista. This topic I and Reza presented in MSDN Day - Web Application Framework yesterday afternoon (Nov 30, 2007). Here we go...

• Download the SDK from: http://get.communityserver.org/download/cssdk
• Extract the downloaded file, e.g.: CS2007.1_3.1.20917.1142.sdk.zip
• Database preparation:
  • Open SQL Server Management Studio/Express, then create new database, for example: CS2007SDK
  • Create a SQL Server login and grant login access to CS2007SDK database. At minimum, following db roles are required: db_securityadmin, db_ddladmin, db_datareader, db_datawriter
  • Execute cs_3.1_CreateFullDatabase.sql against CS2007SDK database. You'll find that file in the SqlScripts directory in the SDK
  • Create a new community by running the cs_system_CreateCommunity stored procedure like this:

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

    Where:

    localhost/cs = CS URL

    dev = Application Name

    admin@example.org = Admin email

    admin = Admin username

    admin = Admin password

    0 = Password is stored as plain (0) or encrypted (1)

    0 = Sample blog and gallery are not created (0) or created (1)

• IIS Preparation:
  • Create a virtual directory in IIS (e.g: cs2007sdk) pointing to the Source\Web directory, so you have a complete URL: http://localhost/cs2007sdk. It should have Read & Run Scripts permissions. Make sure IIS runs ASP.NET 2.
  • If you use IIS 7 in Vista, you need to create Application instead of virtual directoy. And use Classic .NET AppPool as Application Pool, if not, you'll be told there're some invalid configs in web.config
• Development preparation:
  • Now it's time for fun stuffs. You can open provided VS solution file (Community Server 20.sln) with VS 2005 or VS 2008. I'll use VS 2008 in Vista
  • First, Open VS 2008 as Administrator, so you should right click at the shortcut, then Run As Administrator. If not, you won't able to work with IIS in Vista
  • After VS 2008 displayed, open the solution file. First time, you'll be prompted VS Conversion Wizard since the solution file is in VS 2005 format. Proceed the wizard until finish.
  • You'll notice CommunityServerWeb20 project is failed to load. What the h**l happened?
  • Find CommunityServerWeb20 (Internal).csproj file under CS2007.1_3.1.20917.1142.sdk\source\Web folder, and open it using text editor
  • Find following section:

    <ProjectExtensions>
        <VisualStudio>
          <FlavorProperties GUID="{349c5851-65df-11da-9384-00065b846f21}">
            <WebProjectProperties>
              <UseIIS>True</UseIIS>
              <AutoAssignPort>True</AutoAssignPort>
              <DevelopmentServerPort>15157</DevelopmentServerPort>
              <DevelopmentServerVPath>/</DevelopmentServerVPath>
              <IISUrl>http://cs2007</IISUrl>
              <NTLMAuthentication>False</NTLMAuthentication>
            </WebProjectProperties>
          </FlavorProperties>
        </VisualStudio>
      </ProjectExtensions>

  • Change http://cs2007 with your URL previously registered in IIS, for example: http://localhost/cs2007sdk. Save the file, then reload the project from VS. Viola, the project is loaded
  • Build the solution, then open the URL from browser. You're ready to play with CS 2007 SDK

Some of those steps are found in several other blogs, but some are tricky b*st**d steps. So, please if you have more systematic steps, post a comment or post a blog and tell me the link, because it's quite painful J

Hopefully useful.

Share this post: | | | |