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