We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Team Foundation Server 2010

Medium Priority
1,850 Views
Last Modified: 2012-06-27
I've configured my TFS 2010 for use with my VS2010 clients. I have all the updates and patches. Under the Application Tier, Reporting tab, I do the following:

Select "use" reporting. I drop down and select my stand alone SQL 2008 Server r2 instance. I tupe in TFS_Warehouse under the database tab and select test. The test states it sdoesn't exist but will be created and populated for use with TFS.

I then move to the Analysis tab. I then drop the tab down to my SQL server. Under database, I enter TFS_Anaylsis. for my username I enter "sa". As a note the TFS_Analysis doesn't exist on my SQL server.

Next, I continue to Reports. I select my SQL server and hit the populate URLs, They populate,
The reports look as to use HTTP. My SQL server doesn't have IIS installed. If I select the TFS server instead of my SQL server and hit populate, I get the foloowing SQL server Reporting services could not be found error. So I revert back to the SQL server and repopulate the URLs.

When I hit "ok", I get the error:  Could not load file or assembly"micorosoft.analysisservices.version 10.0.0.0,culture=neutral,publickeytoken=89845dcd8080cc91'or oe of its dependencies. The system could not find the file specified.

I have reinstalled several times. I am able to publich code to the server.

Can you assist.

Larry
Comment
Watch Question

CERTIFIED EXPERT

Commented:

Author

Commented:
The post states to install the client tools. I re-ran the install application and I did not see the client install option. Do I need to reinstall TFS? I already have code migrated from Source Safe.

LL
CERTIFIED EXPERT

Commented:
Do you have a separate install for sql server?

Author

Commented:
Yes. I have a full version of SQL Standard 2008 on Windows Server 2008 R2.
CERTIFIED EXPERT

Commented:
go through the install and only select the tools needed.

Author

Commented:
There are 4 tabs during the Install/Modify.

TFS (Checked)
Extentions for Sharepoint Products and Tech (Not Checked)
TFS Server Proxy (Checked)
TFS Build Service (Checked)

There isn't an option to drill down and select on the client tools.

CERTIFIED EXPERT

Commented:
Sorry If I wasnt clear. Not the TFS install. Run your SQL Server 2008 installation. When the setup comes up you will have multiple SQL server install options. One of them i believe is to modify your current installation. There you should have the option to install the tools.

Author

Commented:
I will give this a shot and post my results.

Best,

Larry

Author

Commented:
The tools are installed on my SQL server aready. Actually, i have all options installed.
CERTIFIED EXPERT

Commented:
maybe repair them?

Author

Commented:
I will try and schedule some downtime just in case.

Would it be easier to install a local instance of SQL on the local machine?
CERTIFIED EXPERT

Commented:
mm interesting idea. I would try that!! Good idea!!

Author

Commented:
Question. I will run the tfsconfig setup /uninstall:all command from the elevated dos prompt and reconfigure the application tier to point to the SQL local instance. Will this destroy my team collections that are already checked in?

We connect via VS2010 and not the web gui at the moment.
CERTIFIED EXPERT

Commented:
It looks like it will wipe the tfs database if you run that command.

Author

Commented:
Ok...I just got much closer. I installed the client tools from the SQL install disc on my local TFS host.

I get to the very end (The reporting TAB) to the reports.
I select my SQL server and hit the populate URLs, They populate,
The reports look as to use HTTP. My SQL server doesn't have IIS installed. If I select the TFS server instead of my SQL server and hit populate, I get the foloowing SQL server Reporting services could not be found error. So I revert back to the SQL server and repopulate the URLs.

My next question. Do I need IIS installed on my stand-alone SQL Server in order to complete the Reports configuration?
CERTIFIED EXPERT

Commented:
Team Foundation Server requires IIS

Author

Commented:
Sorry...Let me reacap.

I have a stand alone TFS 2010 and a stand alone full version of SQL 2088 R2.

I am able to publish code to my TFS. I'm trying to enable the reporting features of TFS.

After these posts I installed the SQL tools on my local TFS instance. I can now get past the Analysis page on the Reporting setup.

What I see now is this:

Warehouse: I drop down to my standlone SQL server and enter the database name. It doesn't find it but it says it will create it. Prior to installing SQL tools I was unable to get past this point. Test connection is succesful.

Reports: I drop down to my stand alone SQL server and populate URLs. It completes this. Once I select "ok" I get the error The report server cannot open a connection to the report server database.

I assume the reports database is on the SQL server.

My next question:  Do I need IIS on my Standalone SQL server in order for the Reports function to work? When I populate the URL's it only works when I drop down to my SQL server.

http://APP-SERVER:80/ReportServer
http://APP-SERVER:80/Reports

App-Server is my SQL server without IIS.

I am so close to getting this working.

Many thanks for your help.

LL


Analysis: I srop down to my stand alone SQL server and enter the database name. It doesn't
 
CERTIFIED EXPERT

Commented:
Can you check the event log for details? Maybe there is an authentication error?

Author

Commented:
It do see some things in the event viewer but I can make heads or tales of them.

I ran the SQL Server Profiler: attached are some of my results.

My TFS instance is Webtest4.
CERTIFIED EXPERT

Commented:
Where did you attach it?

Author

Commented:
It is a .TRC file. I can't zip it either. Here is a few screen shots.

- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed


-- network protocol: LPC
set quoted_identifier on
set arithabort on
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed

-- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed

I captured these after I entered all the report information and hit ok ond TFS.

Author

Commented:
Another few...

exec prc_QueryNotifications @lastEventId=4747

exec sp_reset_connection


CERTIFIED EXPERT

Commented:
Can you post the details from the Event Log, I think that would be more helpful. Basically attempt to connect to the Report server and when you get the error report what the event log says about the error.

Author

Commented:
It was a user/permission problem on my Stand-alone SQL server. I had to update the reporting module with another user and reset the reporting and analysis modules. I was able to get reporting and backups working properly.

My programmers move from VSS and love the TFS 2010.

This has been a challenge and I thank you for your help.

LL
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Updating...
CERTIFIED EXPERT

Commented:
:)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.