Menu
So I downloaded Microsoft SQL Server 2008 R2 on a new computer I have to be using and when I go to Start -> Programs -> Microsoft SQL Server 2008 R2 I don't see SQL Server Management Studio. I followed the step by step installation and configuration. Why can't I find the program? What am I missing?
I can't wait for 3 hours more before answering my own question. I should have been asleep hours ago. Here is the answer:
Thought you guys' comments were really helpful. But the solution I had to find by Google searching around. It appears that SQL Server 2008 R2 can be downloaded with or without the management tools. I honestly have NO IDEA why someone would not want the management tools. But either way, the options are here:
http://www.microsoft.com/sqlserver/en/us/editions/express.aspx
and the one for 64 bit WITH the management tools (management studio) is here:
http://www.microsoft.com/sqlserver/en/us/editions/express.aspx
From the first link I presented, the 3rd and 4th include the management studio for 32 and 64 bit respectively.
Guys, thanks a lot for your insight. It was cool to learn that stuff.
398
Go to Control Panel -> Programs -> Program and Features -> Select your current version of Microsoft SQL Server. Right Click, select Change/Uninstall. Click Add features. Select the backup copy folder.
To start SQL Server Management Studio On current versions of Windows, on the Start page, type SSMS, and then select Microsoft SQL Server Management Studio. When using older versions of Windows, on the Start menu, point to All Programs, point to Microsoft SQL Server, and then select SQL Server Management Studio.
How to access “Management Studio.” Now, we're ready to open “Management Studio. Go To Start Menu>Programs>Microsoft SQL Server Tools 18> Microsoft SSMS 18. Below 'Connect to Server' screen will appear.
Note: If you do not have SQL Server 2012 installed on your machine, select ENU\x64\SQLEXPRWT_x64_ENU.exe (or ENU\x86\SQLEXPRWT_x86_ENU.exe for 32-bit) to download and install both SQL Server 2012 and Management Studio in a bundle. After the download is completed, run the .exe file as Administrator.
It appears that SQL Server 2008 R2 can be downloaded with or without the management tools. I honestly have NO IDEA why someone would not want the management tools. But either way, the options are here:
http://www.microsoft.com/sqlserver/en/us/editions/express.aspx
and the one for 64 bit WITH the management tools (management studio) is here:
http://www.microsoft.com/sqlserver/en/us/editions/express.aspx
From the first link I presented, the 3rd and 4th include the management studio for 32 and 64 bit respectively.
196
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
