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
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.