Solved

Run command to open Sql management studio?

Posted on 2008-10-14
10
989 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article I will describe the Copy Database Wizard 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.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

776 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