CODEWITHSUNDEEP
sql-serversql-server-2008
Sasikumar
Sasikumar

Reputation: 101

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

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.

Upvotes: 7

Views: 11988

Answers (2)

Fevzi Kartal
Fevzi Kartal

Reputation: 254

It can be easily verified by using SSMS.

1.) Open SSMS>Connect> Database Engine

enter image description here

2.) Drill down Server name>Browse for more

enter image description here

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. enter image description here

Upvotes: 0

marc_s
marc_s

Reputation: 755237

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

Upvotes: 11

Related Questions