Solved

Run command to open Sql management studio?

Posted on 2008-10-14
10
990 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Suggested Solutions

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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

829 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