Microsoft has launched the SQL Server 2016. We can download and install it from here link. However, when we start installation of SQL Server 2016, we can see some installation changes there. Prior to SQL Server 2016, “SQL Server Management Studio (SSMS)” was a part of the feature list of main SQL Server installation (which starts after clicking on “New SQL Server stand-alone installation or add features to an existing installation“) but now it is available on a separate install. Below is the screen shot of the feature selection list of SQL Server 2016 and SQL Server 2014:
In above image, we can see that the management tools was a feature of the core SQL Server installation process in SQL Server 2014 (right side image) but in SQL Server 2016 (left side image), it is not available in the feature list of SQL Server installation process. So, even if we will do a full installation of SQL Server 2016 by selecting all features, we would not be able to get SQL Server Management Studio installed on our machine.
Let’s have a look on the first screen of SQL Server 2016 and SQL Server 2014 installation process which comes after opening the setup.exe file:
In this image we can see that the SQL Server Management Studio is now available on a separate line in SQL Server 2016. We can download and install it from here.
Once we click on the above link, we will get a web page with a download link to SQL Server Management Studio (SSMS)
We can download and install the “SSMS-Setup-ENU” file from here. Once the download gets completed, we can open the installer file & follow the steps to install SQL Server Management Studio on our machine.
SQL Server 2016 brought tons of new features which we can start exploring once we install it.
I hope my effort of making you aware on 'SQL Server 2016 is now available, It’s time to install SQL Server 2016' helped you in your journey of SSIS. If you feel any queries, please post them as comments below. Also, your feedback will be well appreciated as it helps us to improve better and better every time.
I hope my effort of making you aware on 'SQL Server 2016 is now available, It’s time to install SQL Server 2016' helped you in your journey of SSIS. If you feel any queries, please post them as comments below. Also, your feedback will be well appreciated as it helps us to improve better and better every time.
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in MSBI, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on in MSBI. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/
Very Good informative Article msbi Online Training Hyderabad
ReplyDeleteThe article was very clear and it's usefull information msbi Online Training Hyderabad
ReplyDeleteThankyou for posting this blog. Your blog is so interesting. Read this also..
ReplyDeleteBiztalk Online Training Hyderabad
I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts msbi Online Training Hyderabad
ReplyDeleteExcellent post...! MSBI Online Training Hyderabad
ReplyDeleteThis is really very nice blog to read, thanks for sharing wonderful information. keep share content on MSBI Online Training Hyderabad
ReplyDeleteThanks for sharing the descriptive information on MSBI Tutorial.It’s really helpful to me since I'm taking MSBI Training. Keep doing the good work and if you are interested to know more on MSBI Tutorial, do check this MSBI Tutorial.:-https://www.youtube.com/watch?v=V5gXTb4QO-g&t=3s
ReplyDelete