How Do I Determine Which SQL Server Instance I Am Using?
Article ID
ias-6177
Article Name
How Do I Determine Which SQL Server Instance I Am Using?
Created Date
28th April 2008
Product
Problem
If you are running an SQL Server it may be necessary to set an exclusion for the instance you are using in Windows Firewall.
Resolution
Following the steps below will help you identify the SQL Server Instance you are using.
- Click Start
- Click Programs
- Click Microsoft SQL Server 2008 or 2012
- Click SQL Server Configuration Manager
- In SQL Server Configuration Manager
- Click SQL Server Browser Service in the right hand pane
- Right-Click the instance name in the main window
- Click Properties
- On the SQL Server Browser Properties page
- Click Advanced and locate the instance ID in the property list and then click OK
To Open Windows Firewall please refer to KB IAS-6217
To Create An Exception for SQL Server in Windows Firewall please refer to KB IAS-6183
To Create An Exception For SQL Server Browser Service in Windows Firewall please refer to KB IAS-6184
Share This Page
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.
