Missing SSMS shortcut on Start menu

If for any unfathomable reason you find that the SQL Server Management Studio is missing from your start menu, don’t be afraid! It’s easy as creating a new shortcut on the desktop and moving it back – you just have to know the location of the correct .exe file. And the location of where to move it to. This second part can be a bit tricky with the latest versions of windows (i can’t even imagine how Windows 8 Server will be without the start menu), so let’s make life a little easier and share the default file locations, shall we?

SSMS executable:
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

Start menu for "All Users" location (on Windows 2008 R2):
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008 R2

Start menu for specific user:
C:\Users\_USER_\AppData\Roaming\Microsoft\Windows\Start Menu\Programs

If you put the shortcut on YOUR start menu, it will go to your user folder. Please be kind and put it in the “All Users” start menu location. Why is it located on c:\ProgramData instead of c:\users\AllUsers ? Well, thats one of the unfathomable things, like the reason that the original shortcut is missing in the first place.



About mauriciorpp

Hi, I am Piccolo - but not the one from Dragon Ball. I'm from a highly competitive and fast-paced world too, the IT industry, and this space will be used to share some challenges I face daily on my career. As you will see, I don't do brawls but I need to be a fighter! Stay tuned.
This entry was posted in Windows and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s