7

I have a requirement where I need to find out whether SQL is installed with default instance or named instance.

Can someone please help me here how to find it?

Thanks in advance, Sasikumar.

RonC
  • 31,330
  • 19
  • 94
  • 139
Sasikumar
  • 101
  • 1
  • 1
  • 5

1 Answers1

11

Go to Start > All programs > SQL Server xxxx > Configuration Tools > Configuration Manager and have a look:

enter image description here

If the entry SQL Server has (MSSQLSERVER) after it --> it's the (unnamed) default instance.

Otherwise, you'll find the instance name in brackets after the SQL Server

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459