No Management Studio After Installation
-
Hi
I Installed SQL Server 2014 SP2 Evaluation. Have not received any error during installation, but when i try to run SQL Server, i found that there is no Management Studio. What have i done wrong and how can it be corrected?
Thanks!
-
Most likely you didn't select it as part of the Installation items. SSMS was removed from the Install process from SQL server 2016 and and SSMS 2017 is free to download from the Microsoft website.
Just download and install that.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
It is SQL SERVER 2014!
-
Re-iterating what Thom said: Most likely you didn't select it during the install process.
Either start the installer and choose add features / components and select "Management Tools - Complete" or download the current SSMS (17.X) and install that. - yrstruly - Wednesday, October 4, 2017 11:26 AM
SSMS 2017 is compatible with all currently supported versions of SQL Server (2008 - 2017). SSMS is back compatible but not forward; so SSMS 2012 would not work with SQL Server 2014 onwards. There was no need to SHOUT that you have 2014, I could see that from your post, and the sub forum you have posted in.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Thank You!
-
One way of finding if you selected SSMS while installing the instance is go to - (Drive where sql is installed)C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\
Here the time when you installed SQL instance a timestamped folder is created. Look for file named 'ConfigurationFile.ini'. Here under features parameter you can find which features were selected.Regards,
Nikhil Kadi
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply