Solved

Run command to open Sql management studio?

Posted on 2008-10-14
10
985 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
 
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

914 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now