?
Solved

Team Foundation Server 2010

Posted on 2011-04-25
27
Medium Priority
?
1,794 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
0
Comment
Question by:lanek2
  • 14
  • 13
27 Comments
 
LVL 48

Expert Comment

by:Mikal613
ID: 35476092
0
 

Author Comment

by:lanek2
ID: 35476368
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
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35476396
Do you have a separate install for sql server?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:lanek2
ID: 35476421
Yes. I have a full version of SQL Standard 2008 on Windows Server 2008 R2.
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35476443
go through the install and only select the tools needed.
0
 

Author Comment

by:lanek2
ID: 35476681
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.

0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35476725
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.
0
 

Author Comment

by:lanek2
ID: 35476740
I will give this a shot and post my results.

Best,

Larry
0
 

Author Comment

by:lanek2
ID: 35476820
The tools are installed on my SQL server aready. Actually, i have all options installed.
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35477611
maybe repair them?
0
 

Author Comment

by:lanek2
ID: 35477633
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?
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35477705
mm interesting idea. I would try that!! Good idea!!
0
 

Author Comment

by:lanek2
ID: 35479345
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.
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35479517
It looks like it will wipe the tfs database if you run that command.
0
 

Author Comment

by:lanek2
ID: 35479718
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?
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35480447
Team Foundation Server requires IIS
0
 

Author Comment

by:lanek2
ID: 35482868
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
 
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35483432
Can you check the event log for details? Maybe there is an authentication error?
0
 

Author Comment

by:lanek2
ID: 35483729
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.
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35483769
Where did you attach it?
0
 

Author Comment

by:lanek2
ID: 35483834
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.

0
 

Author Comment

by:lanek2
ID: 35483866
Another few...

exec prc_QueryNotifications @lastEventId=4747

exec sp_reset_connection


0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35484766
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.
0
 

Author Comment

by:lanek2
ID: 35487689
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
0
 
LVL 48

Accepted Solution

by:
Mikal613 earned 2000 total points
ID: 35487768
Seems like "Can you check the event log for details? Maybe there is an authentication error?" was the answer. You can just click Accept as solution to close the question.
0
 

Author Comment

by:lanek2
ID: 35487787
Updating...
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 35487796
:)
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question