I had SQL Server 2008 R2 và Visual Studio 2008 & 2010 on my laptop. I"ve installed Squốc lộ Server 2012 và have finally got Squốc lộ Server Data Tools lớn show up, so that I can create SSRS reports in Visual Studio 2010.

Bạn đang xem: Download microsoft sql server 2012 sinhvienit

Although I"ve installed Management tools - many times - on two separate instances of Squốc lộ Server 2012, I can"t find them in Programs & can"t run them. The only SSMS program I can find runs SSMS 2008 R2.

I realise that comtháng advice is lớn install SQL Server before Visual Studio, but I really don"t want to uninstall Visual Studio, as this will bring a host of other problems.

How can I fix this problem?


ssms sql-server-2012
Share
Improve sầu this question
Follow
edited Jul 2 "15 at 17:03
*

Dan Beaulieu
18k1515 gold badges9292 silver badges126126 bronze badges
asked May 4 "12 at 16:39
*

Andy BrownAndy Brown
4,86133 gold badges3030 silver badges3535 bronze badges
2
Add a comment |

17 Answers 17


Active sầu Oldest Votes
119
You can get SSMS Express tools from here or full SQL Server Eval tools from here. MSDN/TechNet Downloads is currently the only place lớn get RTM versions (non-eval) of the SSMS 2012 toolmix.


Share
Improve this answer
Follow
edited Dec trăng tròn "17 at 2:10
*

gg89
37233 silver badges1111 bronze badges
answered May 4 "12 at 19:17
*

SliverNinja - MSFTSliverNin-Ja - MSFT
29.2k1010 gold badges9898 silver badges162162 bronze badges
12
| Show 7 more comments
147

Share
Improve sầu this answer
Follow
edited Jul 24 "13 at 18:50
community wiki
5 revs, 3 users 73%Michal Minich
6
| Show 1 more comment
87
I just ran inkhổng lồ this problem. I had to open back the installation for SQL Server & click Installation -> New Squốc lộ hệ thống installation or add features to existing installation. Then when we follow the instruction until we reach feature selection, just kiểm tra the Squốc lộ Management tools checkbox và continue.

I have no idea why this software is considered a feature và hidden lượt thích this. It should be a stand-alone software installation.


Share
Improve sầu this answer
Follow
edited Oct 19 "14 at 11:00
*

Peter Mortensen
28.6k2121 gold badges9595 silver badges123123 bronze badges
answered Jul 22 "12 at 1:06
Shawn McleanShawn Mclean
54.2k9292 gold badges266266 silver badges402402 bronze badges
4
Add a comment |
19
I"ve found that the commvà line is my friend in these situations.

I installed the Squốc lộ Server 2012 Enterprise Management Tools, including Management Studio, off the DVD (mounted ISO actually), without installing anything else using this command:

e: hiết lập.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /FEATURES=ToolsRun the commvà prompt with elevated privileges. And be patient, as it has to unpaông chồng the installation files. Don"t try to lớn install the MSI files directly, as you thua the dependency checking packaged with the main installer.

Again, this is to install the full version off the Enterprise or Developer truyền thông media, if you have it, và bởi vì not wish lớn settle for the không tính tiền Express edition.


Share
Improve this answer
Follow
edited Aug 3 "14 at 23:16
answered Jun 13 "13 at 3:46
Amir SoofiAmir Soofi
38633 silver badges33 bronze badges
1
Add a comment |
13
Full or"Complete Management Studio" as opposed khổng lồ "Express".I was very confused at a perceived laông xã of Management Studio on a newly provisioned SQL Server 2012 SP1 standard & enterprise edition on Azure running on Windows Server 2012.

Normally it would be found from the Start Button Shortcuts or at least in C:Program Files somewhere.

Eventually, I located C:SQLServer_11.0_Full, the image install path - executed and confirmed Management Studio was in fact installed by mặc định even although it could not been seen via Add Remove sầu Programs.

In short, if you provision an Squốc lộ Server 2012 VM on Windows Server 2012 on Azure simply run PowerShell & then enter ssms.exe to access Management Studio.

Xem thêm: Conjunctivitis Là Gì - Viêm Kết Mạc Dị Ứng (Allergic Conjunctivitis)

C:Program Files (x86)Microsoft Squốc lộ Server110ToolsBinnManagementStudiossms.exe pháo
Share
Improve this answer
Follow
edited Jun 20 "đôi mươi at 9:12
Community♦
111 silver badge
answered Oct 17 "13 at 13:02
scott_lotusscott_lotus
2,9852020 gold badges4343 silver badges6666 bronze badges
1
Add a bình luận |
10
On the Official SQL Server 2012 ISO that"s for tải về, just navigate to x64Setup (or x86Setup) and you will find "sql_ssms.msi". It"s only about 60 MB, and since it"s an .MSI you can probably provision it to be installed automatically (say for a large lab or classroom environment).


Share
Improve sầu this answer
Follow
answered Oct 24 "12 at 5:08
BrainSlugs83BrainSlugs83
5,58055 gold badges4646 silver badges5252 bronze badges
1
Add a comment |
8
Late answer but could be of use khổng lồ other readers

Although SQL Server Management Studio installation is user friendly (more or less) people still seem lớn bump inkhổng lồ different issues. There are lots of tutorials và instructions online, & I personally followed the ones found in this article: http://www.sqlshaông chồng.com/sql-server-management-studio-step-step-installation-guide/

It explains installing a standalone SSMS, but you can also install SSMS along with SQL Server – just make sure that you have sầu selected Management Tools in the Feature selection screen.

It can help if you’ve just installed Visual Studio 2010 but also want lớn install Squốc lộ Server Management Studio.


Share
Improve this answer
Follow
answered Dec 17 "15 at 8:37
TodorSTodorS
40644 silver badges44 bronze badges
Add a comment |
6
After going baông chồng inkhổng lồ the installer và checking off "Management Tools", ssms.exe was available under "C:Program FilesMicrosoft SQL Server110ToolsBinnManagementStudio" (thanks to everyone for pointing out where lớn find it).

*


Share
Improve this answer
Follow
answered Feb 1 "14 at 17:38
Jeffrey KnightJeffrey Knight
5,69966 gold badges3636 silver badges4747 bronze badges
Add a bình luận |
5
Direct MSDoanh Nghiệp liên kết to lớn Management Studio 2012 ONLY: Squốc lộ Server 2012 Express Management Studio with Service Pack 1 (x64) - (English)


Share
Improve this answer
Follow
answered Aug 5 "13 at 16:06
JOATMONJOATMON
15.8k3131 gold badges100100 silver badges189189 bronze badges
Add a phản hồi |
4
I found it here:http://www.microsoft.com/en-us/download/details.aspx?id=29062

This did not require any TechNet rigamarole or the use of their horrible Java 7 based tải về manager.


Share
Improve sầu this answer
Follow
answered Feb 13 "13 at 21:39
MordachaiMordacnhì
8,71744 gold badges5252 silver badges9898 bronze badges
3
Add a phản hồi |
4
I uninstalled all parts of Squốc lộ Server 2012 using Control Panel in Windows and then reinstalled (choosing "All Features"). Now it works!


Share
Improve sầu this answer
Follow
edited Oct 19 "14 at 10:58
Peter Mortensen
28.6k2121 gold badges9595 silver badges123123 bronze badges
answered May 7 "12 at 13:57
Andy BrownAndy Brown
4,86133 gold badges3030 silver badges3535 bronze badges
Add a comment |
3

Share
Improve sầu this answer
Follow
edited Jul 19 "14 at 14:00
Peter Mortensen
28.6k2121 gold badges9595 silver badges123123 bronze badges
answered Jun 11 "13 at 6:16
NaturalBornCamperNaturalBornCamper
3,28455 gold badges3030 silver badges4949 bronze badges
Add a bình luận |
2
I downloaded it from here (named "Microsoft SQL Server Data Tools"). In this version you will get a VisualStudio2012 installation with the functionality lớn manage the SQL Server 2012 hệ thống.


Share
Improve this answer
Follow
edited Jul 19 "14 at 14:11
Peter Mortensen
28.6k2121 gold badges9595 silver badges123123 bronze badges
answered Feb 8 "14 at 22:46
MohaMoha
18111 silver badge44 bronze badges
Add a bình luận |
0
Install SQLEXPRADV_x64_ENU for x64 bit version from here và choose lớn install all components. This installs Squốc lộ Server Management Studio. You can also install Reporting Services with this installation.

/Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)/

Download Link: http://www.microsoft.com/en-us/download/details.aspx?id=29062


Share
Improve this answer
Follow
answered Oct 14 "13 at 0:19
user2063329user2063329
37511 gold badge44 silver badges1212 bronze badges
Add a comment |
0
Select Squốc lộ Management Studio from the dropdown in Download SQL Server 2012 Express.


Share
Improve this answer
Follow
edited Jul 19 "14 at 14:02
Peter Mortensen
28.6k2121 gold badges9595 silver badges123123 bronze badges
answered Jul 25 "13 at 1:49
Cesar DuranCesar Duran
36733 silver badges88 bronze badges
Add a bình luận |
0
I found what seems lớn be the latest 2014 and 2012 SQL Server Management Studio releases here Previous SQL Server Management Studio Releases


Share
Improve this answer
Follow
answered Nov 19 "15 at 17:26
jamesjames
49855 silver badges88 bronze badges
Add a phản hồi |
0
Run PowerShell và type:

gci -Path "C:Program Files*Microsoft SQL Server" -Recurse -Include "Ssms.exe" | Select -ExpandProperty FullName
Share
Improve sầu this answer
Follow
answered Jun 28 "17 at 14:24
emekmemekm
60455 silver badges88 bronze badges
Add a phản hồi |

Your Answer


Thanks for contributing an answer lớn Staông chồng Overflow!

Please be sure to answer the question. Provide details and mô tả your research!

But avoid

Asking for help, clarification, or responding khổng lồ other answers.Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Xem thêm: Hướng Dẫn Tải Imindmap 7 Full Crack Sinhvienit, Tải Imindmap 9 Full Crack


Draft saved
Draft discarded

Sign up or log in


Sign up using Google
Sign up using Facebook
Sign up using E-Mail & Password
Submit

Post as a guest


Name
E-Mail Required, but never shown


Post as a guest


Name
Email

Required, but never shown


Post Your Answer Discard

By clicking “Post Your Answer”, you agree lớn our terms of service, privacy policy và cookie policy


Not the answer you're looking for? Browse other questions tagged ssms sql-server-2012 or ask your own question.


The Overflow Blog
Featured on Meta
Linked
92
How lớn install SQL Server Management Studio 2012 (SSMS) Express?
60
SQL Server tệp tin names vs versions
1
Configure AdoJobStores of Quartz with LocalDb
0
Where is SQL Server Management Studio 2012
0
ssms.exe pháo /resetsetting not a valid command
Related
1974
How to lớn kiểm tra if a column exists in a SQL Server table?
227
How lớn connect to local instance of SQL Server 2008 Express
665
What is the best way khổng lồ auto-generate INSERT statements for a SQL Server table?
497
Aukhổng lồ increment primary key in SQL Server Management Studio 2012
404
Enable remote connections for Squốc lộ Server Express 2012
16
SQL Server Management Studio crashes after opening or creating database diagram
172
How to find server name of SQL Server Management Studio
125
The VPS principal is not able to access the database under the current security context in Squốc lộ Server MS 2012
56
Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?
Hot Network Questions more hot questions

Question feed
Subscribe to lớn RSS
Question feed To subscribe lớn this RSS feed, copy và paste this URL inkhổng lồ your RSS reader.


lang-sql
Staông chồng Overflow
Products
Company
Stachồng Exchange Network
site thiết kế / hình ảnh © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev2021.7.16.39771


Staông xã Overflow works best with JavaScript enabled
*

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device và discthua trận information in accordance with our Cookie Policy.

Bài viết liên quan

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *