Solved

How to install and run SQL Server Management Studio Express

Posted on 2016-10-05
8
45 Views
Last Modified: 2016-10-06
Downloaded from here https://www.microsoft.com/en-us/download/details.aspx?id=7593

Used file called SQLManagementStudio_x86_ENU.exe  on a Windows 7 32 bit computer.

Warning message says I must apply SQL Server 2008 Service Pack 1 (SP1) before you run SQL Server 2008 on this version of Windows.

But I am only interested in the management tools so I can connect to an existing SQL database on another computer (server).

Installation says it was successful, but from this point I don't see how to start the program.

Please advise...
0
Comment
Question by:codefinger
  • 4
  • 2
  • 2
8 Comments
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41830136
You should see the Management Studio from Windows Start menu / Programs / SQL Server
0
 

Author Comment

by:codefinger
ID: 41830165
I don't.  

Also search for "SQL" only showed the original downloaded file.

--Al
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41830173
It appear listed in "Control Panel" / "Program and Features"?
0
 

Author Comment

by:codefinger
ID: 41830195
No.
0
Zoho SalesIQ

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

 
LVL 26

Accepted Solution

by:
Zberteoc earned 500 total points
ID: 41830318
SQL Server Management Studio 2016 full version is now free for download and to install. I would recommend to use that:

https://msdn.microsoft.com/en-us/library/mt238290.aspx
0
 

Author Comment

by:codefinger
ID: 41830345
That worked!  Thanks!
0
 
LVL 26

Expert Comment

by:Zberteoc
ID: 41830743
Which one worked?
0
 

Author Comment

by:codefinger
ID: 41831513
2016
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

937 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

10 Experts available now in Live!

Get 1:1 Help Now