Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am extremely new to SQL server. I am running the SQL Server 2008 R2 setup wizard and following a tutorial that I found online. Nowhere am I able to configure my instance, even after completing installing and going back to 'New Sql Server or Add Services...'

Having installed this, am I correct to assume that a default instance has been created for me? How do I found out what this is called, so that I can connect to it. Also, how am I able to configure this instance?

I'm sure this is something very obvious, but everything I've found online seems to be something like 'oh just go to the configure instance tab..etc', but I seriously don't see that in the setup that's running and I don't think I'd be able to configure this via the console.

share|improve this question
Do you know what edition of SQL Server you installed? Express, Standard, Eterprise? – squillman Jul 30 '12 at 21:00
developer edition – eikkaj Jul 30 '12 at 21:08

During setup, you should have seen this screen:

SQL Instance Configuration

Assuming you left everything with their default settings, you'll have a default instance known as MSSQLSERVER. One way of checking the instance name is by looking in your services console (services.msc). There will be a service called 'SQL Server (<INSTANCENAME>)'

If your instance has been installed as the default, you can connect to it via SQL Server Management Studio running on the machine itself by using '.' (a period, by itself), localhost or your machine name as the server name.

If it's a named instance, you can connect to it by using .\INSTANCENAME, localhost\INSTANCENAME or HostName\INSTANCENAME.

share|improve this answer

Your Answer


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.