Friday, June 14, 2013

Newly Created Named Instance in SQL Server 2008 R2 cannot be accessed by "Servername\instancename"

This SQL instance can be accessed by port number but not with named instance

To view the instance port
1. Launch SQL Server Configuration Manager
2. Expand SQL Server network Configuration
3. Select one of the instances (e.g) Protocols for CMIS
4. Under 'Protocol Name' right click TCP/IP and select properties
5. Go to I P Addresses tab and find the port number

Configure it to open a port for inbound traffic:

To access the firewall: Press Start -> Type in "Firewall" -> Click on "Windows Firewall With Advanced Security"

You need to configure an inbound traffic rule, like so:

1. Right click "Inbound Rules" on the left pane
2. Choose "New Rule"
3.  Choose "Program"
4. Under "This program path" enter "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe"
5. Action "Allow Connection" continue with Next
6. Profile --> check "Domain" continue with Next
7. Enter the Name "SQL Browser"

Check if your port is now accessible - you might need to restart the Windows Firewall service (under "Services").

No comments:

Post a Comment