Is there a way to connect LOCALHOST without using ComputerName in SQL Server?

Question

Is it possible to connect LOCALHOST DatabaseEgnine without providing the computer name like MyComputerName\LOCALHOST ?

(I use SQL Server 2012 - Standard Edition installed)

You can use . or (local) as identifier for local default SQL Server instance. — Bogdan Sahlean
– Bogdan Sahlean, Commented Feb 7, 2013 at 8:16
Your question isn't very clear: is your SQL Server instance default or named? And why exactly do you want to avoid providing the computer name? If you can tell us why you want to do that, someone may have a suggestion. — Pondlife
– Pondlife, Commented Feb 7, 2013 at 14:02

Remus Rusanu · Accepted Answer · 2013-02-07 12:27:02Z

2

MyComputerName\LOCALHOST is named instance called LOCALHOST on your computer. To connect to it you must either specify the instance name (and have the SQL Server Browser service running) or specify the listening port explicitly (and have the instance configured to listen to static port, non-default since default is dynamic ports). So any of the below will work:

.\LOCALHOST
localhost\LOCALHOST
local\LOCALHOST
127.0.0.1\LOCALHOST
machinename\LOCALHOST
.:<port>
localhost:<port>
127.0.0.1:<port>
etc

Is very unlikely you actually wanted to install a named instance called LOCALHOST. You probably didn't read the setup dialogs and misconfigured the instance name. My recommendation would be to install it again, choosing a default instance (ie. unnamed) or a more convenient and less confusing instance name.

answered Feb 7, 2013 at 12:27

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ankit · Accepted Answer · 2013-02-07 08:17:14Z

1

you can use . as servername e.g.

    .\mssqlserver 
    .\sqlexpress

answered Feb 7, 2013 at 8:17

Ankit

6904 silver badges17 bronze badges

Comments

Prabhat · Accepted Answer · 2013-02-07 10:39:56Z

1

For Default Instance:::

(local) or . (it is a dot)

Named Instance: (local)\InstanceName (or) .\InstanceName

answered Feb 7, 2013 at 10:39

Prabhat

4,2964 gold badges19 silver badges12 bronze badges

Collectives™ on Stack Overflow

Is there a way to connect LOCALHOST without using ComputerName in SQL Server?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related