The Angry Coder

In my life, whenever I attempt to install Team Foundation Server (TFS). I experienced some new issues, fixes, updates and work around and we are now again moving to TFS for source controlling and project management. So, this time I planned to put my installation experience on a blog.

In my knowledge TFS is the only Microsoft technology, that doesn’t work with Next Next stuff. You need to be sure what you are doing when you are installing things.

In this post I will explain you the process of installing TFS to the new machine.

Pre-Requirement:

1. SQL Server 2005 With Reporting and Analysis services. (Service Pack 2)
2. Install SharePoint Services 2007.
3. Once installed, go to administration tool and run SharePoint Product and Technologies Configuration wizard. Ignore the popup saying that
"The following services may have to be started or reset during configuration:
Internet Information Services
SharePoint Administration Service
SharePoint Timer Service".
Just press ok and let it go.

Once the the Wizard is finish, A browser will open containing the SharePoint site.
If it open up with the error, Go to IIS and see if there is an other site which is using SharePoint. If yes, then either you can change port of your site or you can also change SharePoint default port. For that see the following post.

http://www.theangrycoder.net/sharepoint/how-to-change-default-port-of-sharepoint.html

4. Now go to the Central Administration Site and see the Administration Task. And complete configure outgoing email settings and create new web applications task which will ensure your that SharePoint is successfully installed and able to create web sites with no problem.

I have no idea, what went wrong but my reporting services doesn’t create any database neither it was configures on my machine. So I waste some time to do it myself.

Configure Reporting Services:

1. Now go to Programs – SQL Server 2005 - Configuration Tools - Reporting Service Configuration.
2. Click on the Tab on the left called "Report Server Virtual Directory" and then simply press create button on the form. Give appropriate web site on the popup "Default Website" in my case.
3. Repeat the Step six for "Report Manager Virtual Directory".
4. Go to Database Setup Tab and if you cannot see any thing in database drop down. Click on new button. A screen will appear. Give correct credentials to create new database. Once your are done with new DB creation. Add user name and password on the main form and click apply.

I have not put the TFS DVD yet, all this was a pre-installation stuff.

Installation:

1. Now go to the TFS Installation screen and run Windows SharePoint Service Extension, but make sure you have successfully installed SharePoint before this.
2. At the end of the setup a popup will appear which will ask for the following URL.
SharePoint Site URL (Which will be your default SharePoint Site)
Reports
ReportServer

Last two are the virtual directories which will be find either under your default website in IIS, or under the website running on port 80. So, you have to check it manually and give the path.
3. Then Run Team Foundation Server Installation but before that make sure you have done following things.
   
   Create a user that has full rights on SharePoint Administration. In my case, I simply, create an admin user with different user id and password. You need to provide this user authentication information during installation.
   
   Set SQL Server Agent / SQL Server browser Services to Auto Start.

Yeah, this was the story of my last 1.5 days :). It is my thinking, that TFS always comes up with some unique problem. So you might face some thing that is not listed here. In that case, Create post on your blog and share with us.

Cheers everyone :)

Well, I only use Reporting Services (RS) with Team Foundation server (TFS) as yet, but blieve me either the integration of RS with TFS is not good or there is some great problem with RS. It create lots of problems, some days back when we move our server from WorkGroup to Domain. We start getting this error. TfsOlapReportDS Report Service ErrorSo, as usual it requires much try and lots of efforts to solved. I attemp following procedure to get ridd of it.Try 1

1. Open SQL Server Management Studio 2. Select Analysis Services from Server type3. Select your server. It will connect you and will show you object explorer.4. Drill Down to the database you will find TfsWarehouse 5. Select Roles - > Select TfsWarehouseDataReader6. A property popup will appear, Select Membership from the left panel.7. Verify that TFS Service account is listed here, as well as all the users who have access to the reporting services of TFS are listed here (Users might be in groups).

Try 2

1. Connect to http://reportserver/reports2. Click TfsOlapReportDS3. Check Enable this data source4. Select Connection Type to Microsoft Analysis Services 5. Verify the Connection string which is entered is correct, if it is not there. write it. Data source=name;initial catalog=TfsWarehouse6. Select Credentials stored securely in the report server and Add TFS Service Account user and password here. 7. Check "use as Windows credentials when connecting to the data source".8. Click Apply.

Both the tricks, didn't work really so I move to Event Log and there is another issue. Windows is regularly logging an error called

Microsoft.TeamFoundation.VersionControl.Adapter: Unable to access the following folder: C:\\Program Files\\Microsoft Visual Studio 2008 Team Foundation Server\\Web Services\\Warehouse\\VersionControl_Data

So to solve this issue Try 3

1. Go to C:\\Program Files\\Microsoft Visual Studio 2008 Team Foundation Server\\Web Services\\Warehouse2. See if you have any folder with the name of "VersionControl_Data".3. If there is not any folder then create one and Grant Read / Write Access to the TFS Service Account.

In my case the folder was not there, so I create one and Error Logging disappears. Atleast TFS is running fine but still the issue of Reporting Services is there. So I went back to the reporing portal Try 4

1. Connect to http://reportserver/reports2. Click TfsReportDS3. Check the same thing which we had for "TfsOlapReportDS" except that it will connect to Microsoft Sql Server rather Analysis Services. 4. In my case the connection string was empty, I just fill that Data source=name;initial catalog=TfsWarehouse5. Please make sure to re-enter password at the bottomg of page, as it gets expires when you change any thing in the form and press submit without entering the password again.

So, These four attempts restore our Reporting services from this error. Also, note in most of the cases when reporting services is not working fine, you will not be able to create new project in Team System. Don't take Reporting Services lightly, It is really important for Team System