How to find out if SQL Server is installed with default instance or named instance?

Asked 23/1, 2015 at 14:28 Answered 4/10 at 11:16

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.

Beatrizbeattie answered 23/1, 2015 at 14:28 Comment(1)

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

Bearskin answered 23/1, 2015 at 14:32 Comment(0)

It can be easily verified by using SSMS.

1.) Open SSMS>Connect> Database Engine

2.) Drill down Server name>Browse for more

3.) Local servers tab or Network servers tab lists the Sql Instances.

If item has not \ - slash then it is a default instance and all others are named instance.

Mima answered 4/10 at 11:16 Comment(0)