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.
This question is related to
sql-server
ssms
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.
Generally if the installation went smoothly, it will create the desktop icons/folders. Maybe check the installation summary log to see if there's any underlying errors.
It should be located C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log(date stamp)\
Source: Stackoverflow.com