Visual Studio 2005 Team Foundation Server: "Cannot create a file that already exists. The system cannot find the file specified"

FIX: Error message when you run the "tf get" command together with the "/force" option in Visual Studio 2005 Team Foundation Server: "Cannot create a file that already exists. The system cannot find the file specified"

SYMPTOMS
loadTOCNode(1, 'symptoms');
When you run the tf get command together with the /force option in Microsoft Visual Studio 2005 Team Foundation Server, you receive the following error message:
Cannot create a file that already exists. The system cannot find the file specified.The process cannot access the file because it is being used by another process.This problem occurs if the following conditions are true:
•
You use the Open from Source Control command in Visual Studio 2005 to open a large solution that contains many ASP.NET projects that have interrelated references.
•
You open another instance of Visual Studio 2005 Team Foundation Server and then use the Open from Source Control command to open another large solution.
•
You open a third instance of Visual Studio 2005 Team Foundation Server and then use the Open from Source Control command to open a third large solution.
Back to the top
RESOLUTION
loadTOCNode(1, 'resolution');
Hotfix information
loadTOCNode(2, 'resolution');
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

DOWNLOAD HERE:

http://code.msdn.microsoft.com/KB935274/Release/ProjectReleases.aspx?ReleaseId=800

SSRS Cannot create a connection to data source 'dataSource1' Report builder

Symptoms:

In report builder getting Error message when trying to run a report :

Login for user XXX failed Cannot create a connection to data source 'dataSource1'

Solution:

This error is caused by the executing user account (in the SSRS) not having permissions to run the report.

The datasource1 is an internal datasource so don't bother looking for it.

To sort out the problem:

1. Open Report Manager (http:\\localhost\reports)
2. Navigate to Home > Data Sources
3. Make sure Connection string is using Integrated Security=True
4. Select Credentials stored securely in the report server
5. Fill in the Username and password with an admin account on the machine that hosts SSRS
6. Tick Use as Windows credentials when connecting to the data source (to keep your user accounts setup like user folder premisions) working OR just Select credentials are not required

Make sure you unselect Windows integrated security if you are using a windows account that is not an administrator to connect to SSRS server

7. Click apply

Setting up new user in SSRS so that they can see their own folder

Setting up new user in SSRS so that they can see their own folder

First you need to setup user account access to SSRS in two places:

Edit Role Assignment

1. Properties
2. click edit next to user
3. Add Report builder role

Site Wide Security

1. site settings
2. configure site wide security
3. new role assignment
4. fill in username and check System User role
5. ok

Second you have to Create a folder specific for this user

open it / properties / security / add the user account to it

Now each user have their own account that only them and the Admin account can see

SSRS report print date in Report builder

To create a Print date field on a report in SSRS report builder:

1. right click the report Insert\textbox
2. double click it to select its contents
3. set its text to =now.ToString("dd/MM/yyyy hh:mm:ss")
4. run the report