My Attempt To Install SSMS on Citrix….Pass (Part Two)

SQLGator — Fri, 17 Feb 2012 15:55:34 +0000

Yesterday I told you about my failed attempt to install SSMS for SQL Server 2008 R2 as a Citrix application and the failure that ensued. My apologies for making you wait a day for the solution, but I was rushed with another production issue yesterday and decided to break this into two posts for dramatic effect.

Drumroll please!

I found the following solution on several websites including Microsoft:

You need to change the following registry key locations:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0\RED\1033
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033

Change the values of SP and SPIndex to 1 and SPName to SP1. The original values in my case were 0 and RTM, respectively. This is a strange issue because Visual Studio 2008 was never installed on this machine.

I hope this helps! Enjoy!

My Attempt To Install SSMS on Citrix….Fail

SQLGator — Thu, 16 Feb 2012 18:52:10 +0000

I had a goal in mind: install SSMS on Citrix so that if I had to look at one of my SQL servers, I would not need to remote desktop into my desktop or the server itself, in case I needed to look at multiple servers. I wanted just to set up SSMS on the Citrix server as an application so that I could quickly assess problems and avoid redecorating my three monitors when the icons get squished down into one RDP session.

I downloaded the 2008 R2 SSMS installer from Microsoft instead of using my media. After running the installer, I get the following error:

SSMS Error

" data-medium-file="https://sqlgator.com/wp-content/uploads/2012/02/citrix.png?w=300" data-large-file="https://sqlgator.com/wp-content/uploads/2012/02/citrix.png?w=490" class="wp-image-463 " title="Citrix Error" src="proxy.php?url=https://sqlgator.com/wp-content/uploads/2012/02/citrix.png?w=300&h=84" alt="" width="300" height="84" srcset="https://sqlgator.com/wp-content/uploads/2012/02/citrix.png?w=300 300w, https://sqlgator.com/wp-content/uploads/2012/02/citrix.png?w=150 150w, https://sqlgator.com/wp-content/uploads/2012/02/citrix.png 490w" sizes="(max-width: 300px) 100vw, 300px" />

SSMS Install Error

When I run Windows Update, there are no updates available for Visual Studio.

Has anyone seen this before? My Citrix administrator does not know how to proceed. I have never seen this before. Any ideas?

I will blog the solution tomorrow! Enjoy!

Error – SQL Swampland

My Attempt To Install SSMS on Citrix….Pass (Part Two)

My Attempt To Install SSMS on Citrix….Fail