Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using SQL Server 2008 R2, when I looked into the services for SQL Server I saw there are two different services with different instances.

  1. SQLEXPRESS
  2. MSSQLSERVER

Can anyone help me to get clear the difference between #1 and #2?

Thanks in advance

share|improve this question
    
In VS2010 you will access the instance with localhost/SQLEXPRESS. –  johnye2e Apr 15 '13 at 10:59
add comment

migrated from stackoverflow.com Aug 9 '12 at 21:59

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 9 down vote accepted

You can install multiple copies of SQL Server onto the same machine. To keep them apart, all "copies" (called instances) except the first (default) one have to be named.

So by default, when you install your first instance of SQL Server, you won't give it any instance name - it'll be the default instance that you connect to use the server name of ., (local) or your machine name (or IP address).

Any further instance you want to install needs to get a separate, unique instance name.

Visual Studio will by default install SQL Server Express onto your machine (unless you explicitly tell it not to), and that will be called the SQLEXPRESS instance on your machine (hence the service name also is called SQLEXPRESS). You connect to that named instance using .\SQLEXPRESS or (local)\SQLEXRPESS.

So most likely, in your case, you installed a "full" version of SQL Server onto your machine (as the default instance - service is called MSSQLSERVER), and Visual Studio installed a second copy of SQL Server - an Express version - as SQLEXPRESS

share|improve this answer
add comment

MSSQLSERVER is the default instance (accessed via localhost) and SQLEXPRESS is a named instance (accessed by localhost/SQLEXPRESS)

Did you install twice?

share|improve this answer
    
no i just wanted to know when i install VS2010 he will allow me to create tables etc.. in Data Source. so what instance he will creates. if i installed VS2010. –  Vikrant More Aug 3 '12 at 5:53
add comment

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.