Installing Team Foundation Server (Single Server Deployment)…

crosspost from

Just had a VM setup for released version of Team Foundation Server (trial version). My last installation experience of TFS was at RC phase, and wasn't a very good one. the installation of dual server deployment required AD domain for user/service account sharing, and while the RC installation there were some errors came out also after the installation, the SQL Server in data-tier machine eats almost 800mb RAM at initial, and over 1gb while doing team project accesses.

The installation of final release TFS is a better experience. Since I was installing TFS for learning new MSF 4 Process, Active Directory is not that necessary for that. Referred to installation guide that now if using Single-Server Deployment, it is supported also on a non-domain environment (i.e. workgroup env.) therefore I decided to use a single VM for the whole TFS box, including SQL Server 2005.

Installation process was smooth. just follow the installation guide and do it step by step. Since it's a single TFS box, I used administrator account to behave as TFSSetup , and created TFSService and TFSReport accounts for the installation service account. Using VMWare Workstation 5 to create the VM, and set snapshots at each installation steps as follows (in case something went wrong):

  1. Create an empty VM and Install Windows 2003 R2 Server
  2. Install IIS6, related Windows Services (SMTP, ASP.NET, etc), as well as .NET framework 2.0
  3. Do a Windows Update to patch the system to up-to-date status. (create a snapshot here)
  4. Install SQL Server 2005 and SP1 (create a snapshot here)
  5. Install Windows SharePoint Service 2.0 (create a snapshot here)
  6. Install TFS Single-Server Deployment (create a snapshot here before start to use TFS)

Before installing TFS image, remember to start Reporting Service, SQL Browser, and Analysis Service system services or else the TFS installation healthy check will fail.

After installing TFS box, remember to install Team Explorer (at the same TFS iso image) at DevVM's VS2005 IDE in order to be able to access TFS inside the IDE.

the overall performance is better than RC stage, init status on the TFS box utilize about 800mb ram and still over 1gb while doing a single team project data access.

The next should be starting to put some projects into TFS to test the project management processes.

Technorati Tags: microsoft , vstudiomsf


CommunityServer 2.1 Tips: Gallery photo options, save to DB or save to file…

crosspost from

Just had a trace to the source code since I found some of my gallery photos were missing and not able to get them back while upgrading my blog site to CS 2.1 in my VM.

Later found that in .Text era, images were saving to DB only; later in CS 1.x era, images were changed to save to files to minimize DB space usage. now in CS 2.1 , it can now be set to either places, or both.

in CS 1.x , the default image saving location is at ~/photos/storage , while it's the same as in CS 2.1 , if you find your images missing to display on browser, remember to copy all the files in ~/photos/storage of CS 1.x web spaces.

in CS 2.1, now there are options to let you set where to save, DB or file, or both. refer to default CommunityServer.config file , like the following:

              enableFileSystemStorage="true" fileSystemStorageLocation="~/photos/storage"
              enableDataStoreStorage="true"  enableDirectLinks="false"
              extensions = "gif,jpg,jpeg,png,bmp,GIF,JPEG,JPG,PNG,BMP,Gif,Jpg,Jpeg,Png,Bmp" />
              enableFileSystemStorage="true" fileSystemStorageLocation="~/photos/cache"
              enableDataStoreStorage="false"  enableDirectLinks="false"

AttachmentSettings is the place to toggle where to save images to. if set both enableFileSystemStorage and enableDataStoreStorage to true, not only image files will be create and save in ~/photos/storage folder, but also will be saved to database record binary field (cs_PostAttachment table). Refer to GalleryPosts.cs file of CommunityServerGalleries20 project (started from line 387):

  //TODO: work on new save attachement patterns
  private static void CreatePictureData(GalleryPost galleryPost, PostAttachment pictureData)

   // Submit it to the database
   if (GalleryConfiguration.Instance().AttachmentSettings.EnableDataStoreStorage && pictureData.HasDateCreated)
    CommonDataProvider.Instance().AddPostAttachment(galleryPost, pictureData);
    PostAttachment noPictureData = new PostAttachment(pictureData);
    noPictureData.Content = null;
    CommonDataProvider.Instance().AddPostAttachment(galleryPost, noPictureData);

   // If file system storage is enabled, we need to save it.
   if (GalleryConfiguration.Instance().AttachmentSettings.EnableFileSystemStorage)
    CreateDataFile(galleryPost, pictureData);


basically this checks both flags to see if they are true, and then save to each places (DB and file). but if DataStoreStorage flag is false, then while saving the data record, will set Content binary field to null.

By default setting in CS 2.1 , it seems set both DB and file flags to true. To preserve the same usage as in CS 1.x , it's needed to change the enableDataStoreStorage to false.

CacheSettings also using the same setting pattern as AttachmentSettings, but actually DataStore support for Cache is currently not supported in this version, as stated in the comment of CommunityServer.config file.

Technorati Tags: communityserver , , programming


Tips: Installing sdk version of CommunityServer 2.1…

crosspost from

So I finally got some time to start the process of upgrading this blog site to CommunityServer 2.1. I downloaded the 2.1 SDK source, also requested a backup of currently running CS1.1 database from my web-hosting-provider, and started from here.

I had created a virtual machine as my development environment, with Windows 2003 R2 server and VisualStudio Team Suite  installed. as this website is currently running under ASP.NET 1.1, I am trying to start running it under ASP.NET 2.0. The goal is to preserve all my blog posts, photo images, and comments and do the technology upgrade and version-up reconstruction.

After unpack the SDK, and trying to open 2.0 solution file from VisualStudio, the first problem will be that VS2005 won't be able to open the web project since VS2005 now has a new non-project model for website solution. to solve this, I need to download the new Web Application Project (WAP) from ScottGu's website and install it. while the WAP installation it will require another VS2005 updates prior it. After the installation of WAP, CS2.1's ASP.NET 2.0 web project can be opened without problems.

For the IIS part, first editing the hosts file (on windows folder) to point my domain name to localhost, then create a virtual website to point to SDK's web folder, refering to the documentation to set proper read/write priviledges to folders.

For the database part, follow SDK's sqlscript folder's readme file to upgrade database schema from CS 1.1 to CS 2.1.

I did a full rebuild from the source code to regenerate all necessary binaries, and then trying to open my test site in browser. error happaned.

ERROR: Could not load file or assembly 'MemberRole, Version=, Culture=neutral, PublicKeyToken=b7c773fb104e7562' or one of its dependencies

Doing a search from google, found that I need to switch to 2.0 version's web.config file to avoid this error. the files is under "ASP.NET2_configs" folder of SDK source. I did the replace and trying to run again, another error occured.

Login failed for user ''. The user is not associated with a trusted SQL Server connection

Doing a search from google, found that it is something related to trusted connection to SQL server. since I am running CS database in different SqlServer 2005 machine other then web application machine, I decided to avoid this problem by not using trusted connection but using usual SqlServer authentication. just edit the web.config file and change the sqlserver connection string to set Trusted_Connection from yes to no.

By setting all those above, I can get a running instance of CS 2.1 site under my dev VM. the next is to modify the themes and skins of my blogs, also need to modify the source code to support non-keyword searching to be able to search Chinese and Japanese. also need to check about the new url rewrite model to see if it fits my requests (out-site url rewrite).

still need some time to finish my CS2.1 blog site, will post other tips if I found any.

Technorati Tags: communityserver , , programming


RealVNC server is not working on Vista RC2 (build 5744)…

crosspost from

Just installed Windows Vista Ultimate RC2 (build 5744) on my office PC, and trying to install several software that I often used to see if they can run ok on this platform.

Windows RDP is working ok without problem, although it will always show up a dialog saying that it can not verify and identify the host that's connecting to.

trying to install RealVNC 4.1.1, the installation did success, the VNC server also started ok, I did open the port 5900 in Windows Firewall settings. but fail to connect using VNC viewer on other hosts, the connection just disconnect unexpectedly.

VNC should not working on Vista for now.

Technorati Tags: microsoft , windows , vistarealvncvnc


Internet Explorer 7.0 released…

crosspost from

Yesterday (10/19) Microsoft just released Internet Explorer 7.0 . right now only English version is available for download. Asian languages are not released yet for now.

download from here. It will check if the installing machine has valid Windows OS installed, also take some time to install and will require a reboot.

Technorati Tags: microsoft , browser , internet explorer


Patterns and Practices Guidance Explorer…

crosspost from


[via ScottGu]

Saw from Scott's blog about Patterns and Practices Guidance Explorer project, which lets you browse guidances from MS PAG, organize your own pattern groups, or even writing your own guidance and sharing with others.

It's also having online version to browse those guidances online.

This should be good for dev teams to organize, manage, and share group-wide guidances and accumulate knowledge assets.

download here . channel 9 wiki

Technorati Tags: microsoft , pattern , programmingarchitectureguidance


Visual Studio Team Edition for DB Pros CTP6 released…

crosspost from

[via ScottGu]

Visual Studio Team Edition for Database Professionals just released CTP6, which included fixes and feedbacks to make it a better one.

It's necessary to uninstall CTP5 before installing CTP6.

Scott also mentioned some good db tools to help generating test data (MassDataHandler) or creating database documents (Data Dictionary Creator).

This should be a good platform for programmingly manipulating data and database while doing database related solutions.

Technorati Tags: microsoft , visualstudio , programmingdatabase