Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this community
I have Windows 8 and have installed full-pack Microsoft Visual Studio 2010 Ultimate Edition. There was no error while installing Visual Studio 2010 Ultimate Edition.
I exactly don't know which edition and version of SQL Server it installed.
Therefore, please help me to determine, which edition and version of SQL Server it has installed and also how to start SQL Server Management Studio.
You can open Server Explorer in View menu of vs 2010
create a new one
You can else open command prompt
type ssms sql server management studio will executed
The simplest and quickest way to see if and what edition was installed is to run SERVICES.MSC and check for the installed service. To get to SERVICES.MSC, open
Control Panel ➮ Administrative Tools ➮ Services
then scroll down the list looking for SQL Server.
I have installed both Full and Express editions of SQL, side-by-side. The screenshot below shows what to look for. The Express edition is denoted by an instance name of SQLEXPRESS.
Notice at the right, I have SQL Express Disabled and MSSQLSERVER is Running. You can start SQL Express here if it's not running. You can also set it to start automatically on boot.
To launch SQL Server Management Studio, you'll want to look for it on your Start screen. It may look something like:
If it's not there, you can get the 2005 version directly from Microsoft here, or the 2008 version from here. You'll probably want the 2008 version.
Finally, you could also go for SQL Server 2012 Express here, which includes Management Studio Express, however, you'd probably have to uninstall whatever Express edition you have installed now.
I hope I haven't muddied that water for you. I'd be happy to clarify or answer any additional questions you have.
