0

SOLVED (Mostly): MTM Hangs When Opening a Shared Step in the Desktop Client

by Angela 1. September 2015 09:57

This was a real head scratcher, and like many others who have run into this, I spent MANY hours digging through trace logs, event logs, dump files trying to figure out what the heck was going on. It ended up being a really obscure issue with Text Display size.

Anyway, let’s back up. The issue I am describing is one where from within the Microsoft Test Manager client you attempt to open a Shared Step – either from a test case or from the Shared Steps Manger. In either scenario, the shared step opens and before the actual steps load MTM greys out, you see the spinning blue circle of doom, and see the dreaded (Not Responding) message in the title bar:

image

Somewhere in the distance, a sad trombone plays softly…   I was seeing this issue across multiple versions of MTM, multiple operating systems, and against multiple TFS instances. But not everyone was seeing it. Only certain people with a wide variety of versions, update levels, and OSs. So I dig through the event log, looked at MTM trace logs, dump files from the Task Manager, repair MTM, clear cache files, etc. No change.

Then I turned to the MSDN forums.  After about 45 minutes of reading unrelated posts about various ways to hang up MTM, I finally ran across this. I though “No way! It couldn’t be something that obscure”. But I tried it, and lo and behold MTM stopped hanging. Truth be told I don’t even remember changing the text size, but I must have.  It’s so weird that this is the only thing it seemed to have hosed for me.

In case you’re seeing something similar and like me could not remember where the heck to make that change, right click the desktop and choose Screen Resolution then go to Make Text and Other items Larger or Smaller:
clip_image001


Make sure you choose smaller - 100%, and perhaps buy some bifocals because now we are going to go blind trying to read tiny, tiny font. Be sure to log off and then log back in like the operating system tells you to.
clip_image003

Now everything works as expected. I worked from home the next day, and CANNOT reproduce the issue. Making me wonder if it is because at home I do not have a second monitor. But other people running in second monitors cannot repro. Oy.

I have been working with the MTM product team to try to figure out the root cause, as this has been hard to pin down. I have a number of people who have different OS, MTM, and TFS versions, some of whom also run MTM in a second monitor – and ability to repro is inconsistent ::HEAD DESK::  If you feel like trying to reproduce this issue, leave me a comment and let me know what happened for you, and your OS/MTM/TFS version, if your text size is 100% or not, and if you are using a second monitor. Would love some more data points to throw at the debugging efforts.

Tags:

ALM | Application Lifecycle Management | Microsoft Test Manager | MTM | TFS | TFS 2015 | TFS 2013 | TFS 2012 | TFS 2010 | Test Case Management

0

Remote Desktop Connection Manager – Making this TFS Admin Smile Every Day

by Angela 3. August 2015 12:49

So I regularly have a handful of RDC sessions open to administer the various servers that make up TFS on-premises instances including the application tier, data tier, build server, test controller, agents, etc. Doing this with the build in Remote Desktop Manager can be a bit cumbersome when you need to have quick and easy access to multiple servers at once. Sure there are lots of little tricks you can do with saved profiles and desktop shortcuts, but I needed something better. A coworker of mine turned me onto a free Microsoft tool called Remote Desktop Connection Manager. Maybe you already knew about it, if so keep reading anyway because I’ve discovered a few configuration settings that were totally necessary for making the tool really useful, particularly with multiple monitors where you can run into wacky issues with resolution.

First thing I did was create a profile, only this profile can save all of the settings for all of the servers you need to connect to for a given client. Need to switch clients, no problem, just choose a new profile and suddenly the view refreshes and the tree view has a whole new set of servers at your fingertips. Below is an example of my current client environment, complete with AT/DT, build, test controllers, and both automated and manual lab environment machines.

image

Each server has its own settings including things like logon credentials, display settings, encryption, etc. Your best bet is to set most of these things at the root level, which then applies those same settings to all servers beneath it. HUGE for things like AD credentials where *generally* you are always logging in as you. Nice thing is, there’s a checkbox on every settings tab where you can turn inheritance on or off, in the cases where you may want to save a server profile with alternate credentials.

This does happen to me when I am troubleshooting controllers and agents, and need to login with a different level of permissions. In that case, I may have the same server in the tree multiple times, but each one uses different credentials to connect. And my alternate login profile will NOT inherit Login Credentials from the root. Super convenient, just double-click and you’re in!

image

A few other handy things that I recently learned are how to get it to ACTUALLY full screen. Again I set this at the root and inherit because I want all of my servers to act the same. Because I have a second monitor that is unfortunately not capable of the same resolution as my laptop, with the default settings I can’t really ever full screen mode the remote server, AND if I drag the remote viewer from one monitor to the other it freaks out. To prevent this, and keep the server window docked at full screen in whatever monitor it is in, setup your Display Settings like the following (the first two settings need to be checked):

image

The other thing I was constantly struggling with was navigating Servers running Win 8.0clients + or Server 2012. I use a track pad, and getting those charms to pop up and switching between the desktop and the tiles when you can’t just use the native keyboard windows key or charms menu could be really frustrating. If you want to make your life easier, make sure keystrokes are always sent to the remote computer. So in this case go to Local Resources, and make sure that Windows Key combos is set to “on the remote computer”.

image

I need to bring some donuts to my friendly local sysadmin for that nugget. I’m sure it’s well documented somewhere, but I had missed this one and it made a big difference for me!

 

That’s it. Hope that makes your life easier, whether you are a TFS admin or not Smile

Tags:

Application Lifecycle Management | ALM | TFS | TFS 2008 | TFS 2010 | TFS 2012 | TFS 2013 | TFS 2015 | TFS Administration | Team Foundation Server | Productivity

0

Still Running TFS 2010? It’s Aging Out of Support Next Month. Polaris Solutions Can Help You Upgrade Quickly

by Angela 4. June 2015 12:04

You heard me correctly, mainstream support for TFS 2010 ends on July 14th, less than 6 weeks from today! So if you’re thinking “it still WORKS, why should I upgrade?” Consider these points…

  • Any issues arising with your server will NOT be patched or serviced by Microsoft support, and it will be harder and harder to find experienced people to work on it (well, who WANT to work on it)
  • Your infrastructure team may be chomping at the bit to stop supporting the old operating systems and SQL Server versions that TFS is running on
  • You’re missing out on some amazing new capabilities that it would take me hours to cover and that I promise will revolutionize the way you develop and deliver software
  • You attract great new talent by offering robust and modern development environments, trust me on this
  • I can tell you from a LOT of personal experience, that the longer you wait to upgrade, the harder and more time consuming it is!

The good news is that you may qualify for up to $5,000 worth of free services to help you plan and prepare for your upgrade through the Microsoft Deployment Planning Services program (DTDPS)! Wondering what that is? Below is a quick FAQ that I created to explain the program:

Now what exactly IS DTDPS? Well first of all it’s a Microsoft offering, so expect MANY acronyms to follow. DTDPS stands for Developer Tools Deployment Planning Services. Specifically, the development tools that these services are meant to be used in conjunction with are the Microsoft Visual Studio ALM platform - Team Foundation Server, Visual Studio, and Microsoft Test Manager (TFS, VS, and MTM for good measure). 

So what does this really do for me? While most people are already very familiar with Visual Studio from a .NET development perspective, many people who own the other tools within the TFS platform are not taking full advantage of them. DTDPS is the solution to this problem, connecting customers with the right partners to make sure they are getting the full value of their ALM investment. Software that sits on the shelf is a huge waste of money.  And from Microsoft’s perspective is something you’re not likely to buy again, so it is of course in their interest to offer such a program.

What kinds of services are included in DTDPS? Currently there are 4 DTDPS offerings available: TFS deployment planning assessment, Visual Studio Quality Tools assessment, Visual Studio Agile Deployment Assessment, and Visual Studio DevOps Deployment Assessment. You’ll notice a theme here, the word “planning”. These engagements are not meant to be used to implement the tools. Instead, they are short, fixed-length (3 and 5 days) engagements for gathering data and analyzing your current environment and needs in order for us to help you build a plan for implementation and adoption of Visual Studio and TFS ALM tooling. It’s a great kickstart and will drastically accelerate your ALM initiatives.

But what if I don’t need one of those services, but need other assistance with TFS? Well, it depends. I know, I know, typical consulting answer. These programs can be expanded upon to assist customers with other ALM related concerns, so drop me a line at the email I provide below, and I’ll be happy to discuss it with you in more detail. 

Who delivers the engagement? DTDPS is a program delivered through certified and experienced ALM partners like Polaris Solutions to help customers with SA (Software Assurance) benefits to take full advantage of the tools they own.  We have delivered dozens of these engagements over the past few years and every customer we have worked with has been extremely happy with the valuable roadmaps that we delivered. You will benefit from a wealth of relevant experience and proven ALM practices that only comes from us having deployed and leveraged the tools in a large number of different environments and business verticals.

OK, I’m intrigued, but how expensive is it? It is FREE. Seriously, and absolutely.  This benefit is available to customers who purchase Microsoft products with SA, think of it as a rewards program. In fact, you may have DTDPS credits without knowing it!  Many of the customers I work with did not know they had DTDPS credits available until I turned them onto the program.

I want in! How do I sign up?  Start at the DTDPS site. Here you can peruse the various services available and see which ones are right for you and your organization.  Then check out the DTDPS QuickStart guide which walks you through the steps of accessing your benefits.  Then you just pick a partner to work with, like us, and you’re on your way to a better way of doing ALM!

 

If you are interested in learning more about DTDPS, or if you would like to find out more about getting a free quick assessment of the effort required to upgrade and the benefits that your team would enjoy, please contact me at Angela@PolarisSolutions.com. And if you know anyone still using an older version of TFS (anyone running TFS 2013 or earlier qualifies) help them out and point them to this blog!

0

The Many Templates of TFS

by Angela 23. January 2014 15:41

If you are a TFS user, especially if you are a TFS administrator, then you know that with every release of Team Foundation Server that there is a rev of the process templates. And if you work on a TFS server that has gone through a number of upgrades, it is possible that your Process Template Manager dialog will start to look like this:

image

So many choices!! Which one to choose? Ahhhhhhhhhhhhhhhhhhh… ::cough, cough:: Back in the early days, there were only 2 out of the box templates. I know, craziness! How did people survive with only Agile and CMMI? Well, there were always the custom templates that you could get off the internet, but that is a can of worms I am not opening in this post.  For now I want to focus solely on the OOB templates.

Over the years, the templates grew up, work item types got added, fields got renamed, workflows got streamlined, and in 2010 a new template was born. But who can remember which one came out with which version of TFS? Usually it’s not a big issue until you are working on a server with lots of legacy team projects, and you need to know what the original base template was. Pro tip, the TFS Team Project Manager can really help you to answer this question AND we found a bug that they recently fixed allowing you to compare 2013 templates all the way back to 2008 templates! Well, I started keeping track, and I get asked questions about this often enough that I figured I would just share my reference.

TFS Version CMMI Agile Scrum
2005 MSF for CMMI Process Improvement 4.0 MSF For Agile Software Development 4.0 N/A -- 3rd party
2008 MSF for CMMI Process Improvement 4.2 MSF For Agile Software Development 4.2 N/A -- 3rd party
2010 MSF for CMMI Process Improvement 5.0 MSF For Agile Software Development 5.0 Visual Studio Scrum 1.0
2012 MSF for CMMI Process Improvement 6.0 MSF For Agile Software Development 6.0 Visual Studio Scrum 2.0
2012.1 MSF for CMMI Process Improvement 6.1 MSF For Agile Software Development 6.1 Visual Studio Scrum 2.2
2012.2 MSF for CMMI Process Improvement 6.2 MSF For Agile Software Development 6.2 Visual Studio Scrum 2.2
2013 RC MSF for CMMI Process Improvement 7.0 MSF For Agile Software Development 7.0 Visual Studio Scrum 3.0
2013 RTM MSF for CMMI Process Improvement 2013 MSF For Agile Software Development 2013 Visual Studio Scrum 2013
2013 Update 2 MSF for CMMI Process Improvement 2013.2 MSF For Agile Software Development 2013.2 Visual Studio Scrum 2013.2

 

Now, I don’t *think* I have missed any versions here.  All of the major TFS releases, and some minor releases, have been covered.  But I’d love some feedback if you notice any minor versions that I may have missed. And I’ll come back and update this when TFS inevitably gets another update, and another rev of the templates :)

Tags:

Agile | Application Lifecycle Management | ALM | Scrum | Process Methodology | SDLC | Team Foundation Server | TFS | TFS 2008 | TFS 2010 | TFS 2012 | TFS 2013 | TFS Administration | TFS Power Tools | CMMI | Process Templates

0

Quick Tip on Debugging TFS30139 Issues

by Angela 12. December 2013 17:27

I’ve had a few people I know run into this recently, and there does not seem to be a lot of guidance out there about process template customization, in terms of troubleshooting or tips and tricks. While running through process template updates to move clients from TFS 2005/2008/2010 to TFS 2013 I would occasionally encounter one of the annoyances of working with XML by hand:

clip_image002

Oh THAT is helpful.  And if you’ve ever seen the contents of a process template you know this could be one of about a million different problems in hundreds of files.

Now if you do a lot of template customizations, well just stop it, right now, please. The more you customize the more you need to maintain, the more you potentially have to upgrade by hand when you move to a new version of TFS.  There are times when heavy customization is necessary, but I often find people customize without understanding what the OOB template does in the first place. Unless you are checking your templates into source control, being very methodical about isolating changes and testing, and commenting your changes just like you do with your application code, you’re going to run into problems during upgrading. But chances are you’ve already gone down the path and here you are…

Enter TFS consultants. I prefer to do most of my process template editing directly against the XML using Notepad when I can. I know, it’s a bit old school, but there are a lot of us out there so I figured why not share? Inevitably, you misspell something, miss a closing bracket, enter an errant blank space where it does not belong, the common XML “bugs” that can be really difficult to track down.  And as you know, Notepad does not have a debugger.  So like me, I’m sure at some point you’ve tried to upload an updated process template using the TFS Process Template manager and seen the dreaded “TFS30139: The process template is not configured properly.” ::SIGH:: Now what? Well, if you followed my previous advice and were methodically checking in distinct changes, you know what you last changed. Kind of like CI for process templates :)

Enter the power tools. The TFS Power Tools contains a great process template editor that you can use in place of a lot of the command line tools for importing and exporting work item type definitions. You’ll need to install it on a machine running Visual Studio Professional or better, FYI.

clip_image002[5]

It gives you some great visualization tools, allowing you to edit fields, configure the forms, visualize and edit workflows, states, and transitions, and an easy way to open and dig through all the nitty gritty details of everything else that a process template entails too.  As an added bonus, it will give you MUCH better error diagnosis information if something is wrong. So for the previous error, I attempted to open the process template. But this time I got a much more friendly message, pointing me at the issue:

clip_image002[7]

Because I knew that the last thing I changed before my last successful upload of the template was the ProcessTemplate.xml file. I knew exactly where to look and lo and behold, I’d left off a closing bracket at the exact location specified by Visual Studio. So I made the quick fix, successfully imported the updated template to the collection, and checked in the updated template file to SCM. Much better!

clip_image002[11]

There are lots of potential tools and editors out there for process template editing, and everyone develops their own style. I often find myself leveraging several different tools in conjunction during a process template upgrade, it can be a lot of trial and error.  They all have advantages and disadvantages, I’ve tripped over a few myself (like this little quirk with the Team project Manager extension if you’re trying to compare 2008 and 2013 templates). I should blog about some of those adventures too :)

Hopefully this gave you some new options you may not have been aware of before.

0

Say Hello to Chicago’s Newest ALM MVP

by Angela 3. October 2013 20:35

I’m totally stoked to be the latest Chicagoan to be named an ALM MVP. There are currently only 114 ALM MVPs worldwide (that I see on the site anyway), and I am proud to be counted amongst these awesome folks. Sadly, the site is not quite updated so you won’t see yours truly listed just yet.

Wait, “what the heck is an ALM MVP you say?” I know, that is a lot of acronyms there.  In case you’re not hip to Microsoft lingo, that’s an Application Lifecycle Management Most Valued Professional.  This essentially means that in the areas of ALM (TFS, Visual Studio, Microsoft Test Manager, SDLC, etc.), I’ve made significant enough contributions to the community at large to get some serious props. And it’s been a fun ride, and I certainly don’t plan to slow down :)

This is not to say I know EVERYTHING there is to know on the topic of ALM, oh how I wish there were enough hours in the day.  But on any given day you’re likely to find me Installing/upgrading/customizing TFS, scouring MSDN forums, leading a class through the ropes of agile development, or perhaps giving a talk at a local user group on adopting a new ALM strategy in the real world.  I’m definitely passionate about what I do.

Anyway, that’s it for now! Just a little update on the latest excitement in my professional life.  Hope to catch you at a conference or user group near you soon! And don’t forget to stop by the Chicago ALM User Group sometime.  We will be posting details on out October meeting soon!

 

And because I’m always striving to do thing my mom can brag about, here is a picture of me being all giddy about my award :)

V__7802

Tags:

ALM | Application Lifecycle Management | VS 2013 | VS 2012 | VS 2010 | Visual Studio 2013 | Visual Studio 2012 | Visual Studio | TFS Upgrade | TFS 2013 | TFS 2012 | TFS Administration | TFS 2010 | TFS 2008 | TFS | SDLC | Process Methodology | MSDN

0

Receiving Random 403 Forbidden Errors on Your TFS SharePoint site? I Was.

by Angela 24. September 2013 16:57

So let’s start by explaining what was happening. I had just unraveled a mess of TFS/SharePoint/Reporting security that rivaled improperly-put-away-Christmas-lights levels of tangled.  All kinds of duplication, broken inheritance because of inexperienced admins adding individuals (instead of the AD groups I had setup) at every level of the SharePoint hierarchy, you name it!  So one day I get a head-scratcher of an issue from a business user who is customizing a TFS SharePoint portal for a project.

They were trying to edit the queries behind a couple of custom TFS web parts and were getting “403 Forbidden” errors at seemingly random times.  It would work on Monday but be broken on Tuesday and work again Wednesday.

image

I was not getting that error, but of course I am god of everything as the TFS admin, so there is little I cannot do.  But I also noticed not many other folks were experiencing the issue, well, to be precise not one other person was receiving the error.  In the same AD groups, in different AD groups, nada.  I verified all of the groups this person belonged to, checked and rechecked his AD group membership, made sure SharePoint still had all the correct security inheritance in place. Nothing was out of place. And every once in a while the user would be able to complete that same action again without the error. Seemingly, whenever I went in and performed the action he was being denied. What the WHAT?!? Now I was *really* intrigued. 

Needless to say, we did fix the issue, but not without some serious internet scouring. I was about to post to MSDN forums when i stumbled upon the issue.  This obscure Microsoft Support post fixed our problem.  So I should note for background purposes that this TFS instance began as a 2008 installation running against a super old version of WSS.  It has been upgraded twice, by me, and we are now happily running on TFS 2012.3 with WSS 3.0, and hopefully soon to be TFS 2013 and the latest release of SharePoint Server. The server had SURELY gone through the security updates described in the Support post.  But since no one used the TFS SharePoint sites until I came along and fixed all of the security, no one had encountered this super old issue until very recently. Luckily I was on-site when it did, because while frustrating, it was also fun to troubleshoot.  I am weird that way :)

Tags:

Application Lifecycle Management | ALM | TFS 2012 | TFS 2010 | TFS 2008 | TFS 2013 | Team Foundation Server | TFS | TFS Administration | TFS Upgrade

0

DTDPS, What It Is and Why You’ll LOVE it

by Angela 19. July 2013 19:18

It sounds like an STD, I know, but I promise it’s not. and after you’ve given your customers a DTDPS, they will thank you for it Smile  So hopefully I’ve intrigued you enough to read a bit more about this mysterious program. I’ve created a short FAQ to walk you through it:

Now what exactly IS DTDPS? Well first of all it’s a Microsoft offering, so expect MANY acronyms to follow. DTDPS stands for Developer Tools Deployment Planning Services. Specifically, the development tools that these services are meant to be used in conjunction with are the Microsoft Visual Studio ALM platform - Team Foundation Server, Visual Studio, and Microsoft Test Manager (TFS, VS, and MTM for good measure). 

So what does this really do for me? While most people are already very familiar with Visual Studio from a .NET development perspective, many people who own the other tools within the TFS platform are not taking full advantage of them. DTDPS is the solution to this problem, connecting customers with the right partners to make sure they are getting the full value of their ALM investment. Software that sits on the shelf is a huge waste of money.  And from Microsoft’s perspective is something you’re not likely to buy again, so it is of course in their interest to offer such a program.

What kinds of services are included in DTDPS? Currently there are 3 DTDPS offerings available: TFS deployment planning, Visual SourceSafe migration planning, and Microsoft Test Professional deployment planning. You’ll notice a theme here, the word “planning”. These engagements are not meant to be used to implement the tools. Instead, they are short, fixed-length (3 and 5 days) engagements for gathering data and analyzing a customer’s current environment in order to help them build a plan for implementation and adoption of TFS and/or MTM.

But what if I don’t need one of those services, but need other assistance with TFS? Well, it depends. I know, I know, typical consulting answer. These programs can be expanded upon to assist customers with other ALM related concerns, so drop me a line and I’ll be happy to discuss it with you in more detail. Also, the programs being offered may be changing soon so check the site occasionally to see if a program was added to fit your needs.  

Who delivers the engagement? DTDPS is a program delivered through certified and experienced ALM partners like Polaris Solutions to help customers with SA (Software Assurance) benefits to take full advantage of the tools they own.  This means customers benefit from a wealth of relevant experience and established best practices that only comes from having deployed and leveraged the tools in a large number of environments.

OK, I’m intrigued, but how expensive is it? It is FREE. Seriously, and absolutely.  This benefit is available to customers who purchase Microsoft products with SA, think of it as a rewards program. In fact, you may have DTDPS credits without knowing it!  Many of the customers I work with did not know they had DTDPS credits available until I turned them onto the program.

I want in! How do I sign up?  Start at the DTDPS site. Here you can peruse the various services available and see which ones are right for you and your organization.  Then check out the DTDPS QuickStart guide which walks you through the steps of accessing your benefits.  Then you just pick a partner to work with, like us, and you’re on your way to a better way of doing ALM!

2

Installing TFS 2012 on SQL 2012? You might run into some problems

by Angela 9. January 2013 05:27

So, like all TFS upgrade projects I work on, I got a last minute request that added a major wrinkle to our neat little TFS upgrade plan. “Can we just use SQL 2012 SP1 instead of SQL 2008 R2 SP1 for TFS 2012? It shouldn’t change anything right?”  FAMOUS. LAST. WORDS. Notice they were not MY words. I had the foresight to say that no, it absolutely WOULD change things because I hadn’t based any of my estimates or my plan of attack on upgrading the DT software to a new major release. And I also stated that while it was a supported configuration for TFS 2012, since no one here had validated that SQL Server 2012 SP1 would work on their custom VMWare implementation, anything could happen and so my estimate and plan was out the window. It was supposed to be a quick, neat, in-place upgrade that required almost no patching or updating OTHER than TFS itself. And then they decided they wanted to be on the latest and greatest everything all at once. Awesome. That always goes well.

So as I expected, everything went smoothly UNTIL we got to the part where I upgraded SQL Server 2012. So let me back up in case you are wondering how I got to that point… I pinged some colleagues on the TFS product team to verify that I could more or less follow my original plan, but work in an upgrade of the SQL Backend to SQL 2012 along the way. We came to the conclusion that to minimize risk and isolate sources of potential issues, that I should follow my original plan and upgrade to TFS 2012 on SQL 2008 R2 *first*.  Then after I verified that configuration was working properly, I would upgrade the database to SQL Server 2012.  I had a plan, and lots of caffeine. I also had this awesome blog post to reference from Martin Hinshewood with some helpful nuggets in it too.  This might even work…

The upgrade to TFS 2012 on SQL Server 2008 R2 went without a hitch. In case you are curious, they are on SQL Standard x64. I was able to hit the server, fire up the collections, connect to Team projects, SharePoint and reporting.  I followed the advice of many blog posts and started with the SQL 2012 Upgrade Advisor.  The only issue I ran into there was that I had to install .NET 4.0 and a specific prerequisite. I love, LOVE when error dialogs give you links that you cannot click on or copy and paste into a browser too. So helpful SQL dudes! So here you go:

clip_image002

http://go.microsoft.com/Fwlink/?LinkID=216742

Once I thought I had all my prerequisites in order (wait for it), I ran the upgrade advisor tool, counted my green check marks, and started the upgrade to SQL Server 2012. Somehow the Upgrade Advisor DIDN’T make sure that SQL 2008 R2 SP1 was installed before it let me waste 30 minutes walking through dialogs

image

Once I got past that installation, the SQL Upgrade finished without another hitch.You will need to restart the server again, but since TFS has been down the whole time anyway it’s not like it matters at this point. Then I started the SQL 2012 SP1 install and it got 99% of the way through the install and ::insert sad trombone:: “The NT service ‘MsDtsServer110’ could not be started”. Who did what again? I searched on it exactly as stated, and SHOCKINGLY got nothing useful back. Again, AWESOME.

image

 

After a bit more digging I found some telling information in the event log under System Events:

image

The service account does not have the required user right “Log on as a service.” So the NT Service\MsDtsServer110, which I have no knowledge of through past experiences, is missing a permission and so SSIS keeps failing. I was unfamiliar with the Service account “NT Service\MsDtsServer110” so did some digging around to see what popped up in regards to SQL 2012 installs.  Finally hit a TechNet post that described my exact issue.  For whatever reason, most of the SQL Services run as Network Service, (or some other known service account), but the SSIS service runs as this new guy in SQL 2012, and due to local domain security policy here at this client (just like the article warned), my Setup account was not allowed to provision that account properly.  So we followed the article’s advice for a workaround, reset the logon account to a known service account, started up all the services for SQL Server, and was able to complete the TFS 2012 DT upgrade. WHEW!

So, lots of potential gotchas, none of which were TFS or SQL’s fault, but since most of my friends work for large corporations with complicated rules about access and domain policies coming out of their ears, I thought this might be helpful. Hope it was!

Tags:

ALM | Application Lifecycle Management | MSDN | SDLC | SQL Server 2012 | Team Foundation Server | TFS 2010 | TFS 2012 | TFS Administration | TFS Upgrade | Visual Studio 2012 | VMWare

0

Untangling TFS Connectivity to SSRS Snafus

by Angela 5. December 2012 08:55

So, as you may know, SSRS cannot host up reports for multiple instances of TFS, or for other applications period.  IOW, TFS SSRS instances MUST be dedicated. The reason is pretty obvious once you dig around in the properties of the reporting databases on your report server, but trust me on this unless you really WANT to know how it all works under the covers.

Long story short, we accidentally configured two different TFS application tiers (TFS1 running TFS2012 and TFS2 running TFS2010) to use the same instance of SSRS, doh!  We only need reporting on TFS1, for the record. After some troubleshooting we found that the connection strings for the TFS2010OlapReportDS and TFS2010ReportDS databases on the report server pointed to TFS2 and not the original one any more (TFS1). But oddly, the reports on the new TFS instance don't work either, I would have assumed that ONE of the instances would have had reporting that worked. I went to the Reports folder, and could see all of the reports for all of the team projects across the both TFS1 and TFS2 but always received this error, on every single report:

  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for dataset 'dsIteration'. (rsErrorExecutingCommand)
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors

 

Anyway, I digress. 

I figured a good first step was turning off Reporting on TFS2, and then reconfiguring SSRS for TFS1 in an effort to "reset" the connection.  But I could turn off reporting on TFS2.  I assumed that normally I *should* be able to do this, just un-check the "Use Reporting" feature and it's gone right? Maybe there is something amiss with the TFS 2010 instance? It is brand new, so not sure how it could already be corrupted.  Here is the error I receive when I try to "turn off" reporting on TFS1:

 

I did a lot of searching of MSDN and forums and couldn’t find anything that seemed to help.  I got desperate and tried a different order of operations, a "Hail Mary" if you will, and it worked!

I could not turn off reporting on TFS2 for some reason, but it occurred to me that the error message I was getting ("the database is not properly configured") was rather generic and could mean a LOT of things. And alas I do not have remote login access to the SSRS instance (don't get me started on the why or what of that!), so I couldn't even do research on it.  So instead I focused on getting TFS2 WORKING with SSRS even through the end goal was turning off reporting.  I went to the TFS1 app tier that had been connected to SSRS successfully originally, went into the Admin Console and unchecked "Use Reporting" to break the connection. That worked great, of course.

Next I went back to TFS2, and via the Admin Console verified the SSRS configuration information to hit the report server was all correct (it was), re-started all the jobs, and rebuilt the warehouse. Once reporting was working again on TFS2, I tried to turn it off again, and this time when I unchecked "Use Reporting" it was successful.  So apparently if reporting is broken, you cannot turn it off. Great.

Anyway, next I went back to TFS1, reconfigured reporting through the admin console and now all is well with the world again. Oy, I need a drink.

Tags:

ALM | Application Lifecycle Management | MSDN | SDLC | TFS 2010 | TFS 2012 | TFS Administration | TFS Power Tools | Team Foundation Server | Visual Studio 2012 | Visual Studio

Powered by BlogEngine.NET 2.7.0.0
Original Design by Laptop Geek, Adapted by onesoft