Team Foundation Server's workspace machine names

After the machine name change mentioned in an earlier post, I also found that Visual Studio could no longer find the projects saved in my local Team Foundation Server workspace. Thanks to Google and this post by Buck Hodges, I was able quickly correct the problem by updating the machine name stored by TFS.

CRM Offline Client Connection String

Recently I was getting a SQL connection error when attempting to go offline in the CRM Outlook client (3.0). After scratching my head for little bit trying to figure out a possible cause, it dawned on me. Earlier in the week, our network administrator had changed my pc's machine name (long story). The client must not be able to find the local database due to the machine name change. I popped open regedit and sure enough there were three references to local databases with the incorrect machine name. In the unlikely event that this happens to someone else, they are located in HKEY_CURRENT_USER\Software\Microsoft\MSCRMClient and the keys are:

database
Provider=SQLOLEDB;Data Source=machinename\CRM;Initial Catalog=MSCRM_MSDE;Integrated Security=SSPI

metabase
Provider=SQLOLEDB;Data Source=machinename\CRM;Initial Catalog=METABASE;Integrated Security=SSPI

OfflineQueueDBConnection
Provider=SQLOLEDB;Data Source=machinename\CRM;Initial Catalog=MSCRM_MSDE;Integrated Security=SSPI

Just correct the machine name for each, and everything should be back to normal.
Off course, the usual cautions apply about being careful when modifying the registry.

Welcome!

Hello and welcome to my new blog. I dabble in a variety of technologies ranging from ASP.NET, AJAX, SQL, Java, C#, VB.NET, Oracle, Sharepoint, Microsoft CRM, Photoshop, and 3D CAD software (such as SolidWorks). As you can see that is a long list. As such, I don’t consider myself an expert in any one area. This means that each day presents new challenges. My intention for this blog is to list the tidbits of useful information that I learn during daily activities, in hopes that it will be helpful to other developers out there. If nothing else, it gives me a place to refer back to when my brain runs out of storage space and I can’t remember how something was accomplished.

I may also occasionally post more personal information about my hobbies such as family, pets, music, nature, drag racing, and Jeep rides.

Stay tuned for more info in these areas.