Solved

How to install and run SQL Server Management Studio Express

Posted on 2016-10-05
8
50 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 48

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 48

Expert Comment

by:Vitor Montalvão
ID: 41830173
It appear listed in "Control Panel" / "Program and Features"?
0
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)

 

Author Comment

by:codefinger
ID: 41830195
No.
0
 
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

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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 video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

856 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