Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

You can open Server Explorer in View menu of vs 2010

enter image description here

create a new one

enter image description here

You can else open command prompt

type ssms sql server management studio will executed

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.