Need to open SQL Server Management Studio 2008 from “Run” menu

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

I tried to open SQL Server Management Studio 2008 by typing ssms in "Run" menu.

But it wont open.

It shows

windows cannot find 'ssms'. make sure you typed the name correctly, and try again".

But it works from start-> program->sql server 2008.

Posted 6-Jun-13 21:12pm

Venkat Kumar chigulla

Add a Solution

6 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

yourfriendaks · Answer 1 · 2013-06-06T21:40:00

Solution 4

do on thing
go to program files
then micrisoft sql server 2008
then click on program shortcuts
then crick on properties
in properties click on find target
its show u to exe file.
check the name of that and typed in run menu

Posted 6-Jun-13 21:40pm

yourfriendaks

amnk.info · Answer 2 · 2013-06-06T23:26:00

Solution 6

http://social.msdn.microsoft.com/Forums/en-US/silverlightdevtools/thread/c0c3b018-da4e-42f8-a48f-7cfdc145dcb8[^]

Posted 6-Jun-13 23:26pm

amnk.info

Anoop Kr Sharma · Answer 3 · 2013-06-06T21:28:00

Solution 1

Try this in run menu SSMS.exe

Posted 6-Jun-13 21:28pm

Anoop Kr Sharma

Comments

Venkat Kumar chigulla 7-Jun-13 3:31am

Not Working,got the same error

windows cannot find 'ssms.exe'. make sure you typed the name correctly, and try again".

Anoop Kr Sharma 7-Jun-13 3:35am

I have tried it just 2sec ago and it works in my pc.

Anoop Kr Sharma 7-Jun-13 3:37am

hey try this first go to start-> program->sql server 2008 and then right click on sql server management studio--->click on properties and check the last words of path

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

look something like as above.try the last few words like in above example there is Ssms.exe and run this in run menu

Venkat Kumar chigulla 7-Jun-13 3:39am

In my pc it's not working

Anoop Kr Sharma 7-Jun-13 3:40am

try the things that i have said to you in my previous reply hope it works

Venkat Kumar chigulla 7-Jun-13 4:56am

I went to that location It's ssms.exe but it is not working.... I found the solution for this in another way now it is working

yourfriendaks · Answer 4 · 2013-06-06T21:34:00

Solution 2

type this
in rum menu
ssmsee.exe

Posted 6-Jun-13 21:34pm

yourfriendaks

Comments

Venkat Kumar chigulla 7-Jun-13 3:37am

not working, got the same error

uspatel · Answer 5 · 2013-06-06T21:38:00

Solution 3

See your System32 folder.
is it have ssms.exe?

if not,then copy ssms.exe from

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

and paste it in system32 and then try.

Posted 6-Jun-13 21:38pm

uspatel

Updated 6-Jun-13 21:39pm

v2

Comments

Venkat Kumar chigulla 7-Jun-13 4:07am

done what you said, it opens SQL server Managment Studio at the same time it opens a dialog box that contains "Package 'Microsoft SQL Managment Studio package' failed to load" when i click OK button it closes SSMS.

uspatel 7-Jun-13 4:32am

then you can try another trick create shortcut of C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe and paste it in system32,I hope it should work

Venkat Kumar chigulla · Answer 6 · 2013-06-06T22:21:00

Solution 5

Thank you for your support.....

I found the solution for this do one thing

"you have to add the path to ssms.exe to your PATH environmental variable, and then you can just type SSMS in the Run window"

Its working................

Posted 6-Jun-13 22:21pm

Venkat Kumar chigulla

Updated 6-Jun-13 23:48pm

v2

Comments

CHill60 7-Jun-13 5:31am

Or you could have typed in the fully pathed name as per "yourfriendaks" solution above

Venkat Kumar chigulla 7-Jun-13 5:37am

No not like that you have to type the .exe file name in "Run" window.
for example:
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

type ssms.exe in "Run" window

Venkat Kumar chigulla 7-Jun-13 5:52am

If it does not work let me know