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.
- Click on HKEY_LOCAL_MACHINIE
- Expand SOFTWARE
- Expand Microsoft
- Expand Microsoft SQL Server
- Go to Instance name to find out the actual instance name.
- 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
Post a Comment