1

I have a question that I am confused about. I am also new to database stuff as well so this question may be basic.

For example, at my work, we use SSMS to connect to our server's databases.

When connecting from SSMS, we enter in (server_name\instance). Like for example PC100\SQLexpress.

But for some, only the server is entered and not the instance along with it. How does this work? I thought in order to connect, we always need to type an instance after the server name?

Like for example, some we need PC100\SQLexpress in order to connect to the server's databases. And then for others we just need to type in PC200 to connect, and not needing to type the instance.

Can anyone explain?

4

For SQL Server the default instance of a is SQLServerName\MSSQLSERVER. However, since MSSQLSERVER is the default instance name that is never displayed.

A SQL Server using the default instance is only referenced by the SQLServerName.

Actually, you can install SQL Server Express and give it the instance name of MSSQLSERVER and you will get the default instance. Of course, any server can only have one default instance.

That is probably most useful when installing a SQL Server Express and you do not want to have SQLExpress for the part of the name.

When installing a default instance of SQL Server Express at the Instance Configuration page, you must choose the Named Instance radio button and type in the default instance name of MSSQLSERVER.

Just take the steps to name the default instance name MSSQLServer (which will not appear). Any other instance name on the computer needs a unique name, such as SQLServerName\Alpha, SQLServerName\Beta, et cetera.

Note: Installing SQL Server Express will, by default behavior, put the SQLExpress into the server name. But that is not the default name. Whenever there is \Sometext name, then that is called a named instance.

  • Oh ok I see, so that explains why. Is it recommended to rename the instance instead of using the default MSSQLSERVER instance? Or does it really depend on the situation really? – bingaloman Jan 6 '17 at 3:46
  • There is not a right or wrong decision on instance names so it depends on your situation and what standard you want to use. If you have more than one SQL Server installed on a computer then you can have one default instance and as many named instances as the machine can support. – RLF Jan 6 '17 at 4:00
  • Awesome, thank you for helping to clear that up for me, definitely makes a lot more sense to me now as I was confused in the beginning. – bingaloman Jan 6 '17 at 4:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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