Can default SQLServer instance name be empty string?

Question

Can default SQLServer instance name be empty string? Client argues he has ".\" as server\instance name. There are two kinds of instances: default and named instance and it seems logical that not named has no name. But MSDN says: default name is MSSQLSERVER.

The service name for the default instance is MSSQLSERVER, but the instance name is empty - so you connect to your default instance using ., or (local), or machinename (without any further instance name) .... — marc_s
– marc_s, Commented Apr 20, 2016 at 4:54

Kyle Stoflet · Accepted Answer · 2016-04-21 17:08:45Z

4

As you stated, MSDN does state that the default instance name is MSSQLSERVER. It also states that an instance name does not need to be specified for a default instance to make a connection.

So to answer you question, the default instance name isn't empty, but the reference to it can be. Reference using the server / pc name.

More info related to default and named instances can be found here.

answered Apr 21, 2016 at 17:08

Kyle Stoflet

1,2344 gold badges18 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Can default SQLServer instance name be empty string?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related