CODEWITHSUNDEEP
sql-serverconnection-string
Vlad
Vlad

Reputation: 2165

Can default SQLServer instance name be empty string?

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.

Upvotes: 5

Views: 8757

Answers (1)

Kyle Stoflet
Kyle Stoflet

Reputation: 1234

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.

Upvotes: 4

Related Questions