Menu
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.
928
Go to the tab IP Address and look for the property TCP Dynamic Ports. This is the port to which the SQL browser will listen. It will determine which instance the client tries to reach. The Default Instance of SQL Server will always be listed under port 1433.
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).
Finding the SQL Server version with query We can use the @@VERSION function to find out all version details of the SQL Server instance. The @@VERSION function returns a one-line string output and this output also provides all the necessary information about the SQL Server.
One instance can be the default instance. The default instance has no name. If a connection request specifies only the name of the computer, the connection is made to the default instance. A named instance is one where you specify an instance name when installing the instance.
Go to Start > All programs > SQL Server xxxx > Configuration Tools > Configuration Manager and have a look:
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
118
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
