SQL - Identify the name of SQL instance

It is very simple to identify the name of the installed instances. I have installed SQL server 2008 R2 express edition in my system and was not able to find out the name exactly. I know that SQL by default gives the name as SQLExpress but we can make sure the name from registry value.

- go to start -> run and give regedit there which will open the Registry editor window.

Fig 0.1













- Click on HKEY_LOCAL_MACHINIE
- Expand SOFTWARE
- Expand Microsoft
- Expand Microsoft SQL Server
- Go to Instance name to find out the actual instance name.


      
Fig 0.2

Comments

Popular posts from this blog

Hadoop - Hive - Load data from csv/xls files

Microsoft BI Implementation - Cube back up and restore using XMLA command