Solved

Run command to open Sql management studio?

Posted on 2008-10-14
10
993 Views
Last Modified: 2012-08-13
Hi all,

Is there a "generic" run command to open Sql management studio?

Thanks,

Zee
0
Comment
Question by:zeeshanbutt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 22715317
sqlwb
0
 

Author Comment

by:zeeshanbutt
ID: 22715576
BrandonGalderisi,
Thanks. It looks that your run command is correct, since when I run it on my loacl machine it does open SQL Managment Studio.

Actually I need to check on our client's server if they have SQL Server 2005 (including reporting services) is installed or not. There, I dont see Sql Managment studio in start > Programs.
When I run "sqlwb" it gives erorr, that "Windows cannot find sqlwb".

Please see the attached image. As you can see there's only "Surface Area Configration", but where is the "SQL Managment Studio", and "SQL Server Business Intelligence Development Studio"? How to find out without asking the client if the above are installed on the client's server or not?

Please suggest
screenshot.JPG
0
 

Author Comment

by:zeeshanbutt
ID: 22715681
Can someone help please.
Thanks for the prompt help.

Zee
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22715697
That's because client tools are not installed on that box.  If you install client from the CD it will be there.
0
 

Author Comment

by:zeeshanbutt
ID: 22715710
BrandonGalderisi,

When you say client tools what exactly you mean. Please explain.

Thanks,

Zee
0
 

Author Comment

by:zeeshanbutt
ID: 22715738
BrandonGalderisi,

Also could that be possible that although client tools are installed, and I am maybe not an administrator on that server, and that is why I am unable to see "SQL Managment Studio", and "SQL Server Business Intelligence Development Studio"?  Please comment.

Also when you say client tools what exactly you mean. Please explain.

Thanks for your help.

Zee
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22715743
SQL Server Management Studio is a client tool used for accessing SQL Server and is not part of the engine itself.  For example, you wouldn't want people logging in to your DB server to run a query, so you install the client tools on a developers machine.  From there, they can attach to the SQL DB Engine running on the other server to run queries and such.
0
 

Author Comment

by:zeeshanbutt
ID: 22715762
Thanks BrandonGalderisi.
Now could that be possible that although client tools are installed, and I am maybe not an administrator on that server, and that is why I am unable to see "SQL Managment Studio", and "SQL Server Business Intelligence Development Studio"?  Please comment.
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22715763
Being an administrator on the server doesn't necessarily mean you wouldn't see items in the start menu.  That's separate from being an administrator as by default the client tools are installed into the all users profile.  It is most likely that client tools were not installed on that server to discourage people from using it as a location to run queries from.
0
 

Author Comment

by:zeeshanbutt
ID: 22715928
BrandonGalderisi,

Thanks for your valueable information.

Zee
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question