[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 864
  • Last Modified:

MSSQL Server 2008 R2 on SBS 2011 STD - Firewall problems

When trying to connect to the SQL Server I get this error on all client pc's:

Microsoft SQL Server Login
Connection failed:
SQL State: 01000
SQL Server Error: 67
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
Connection failed:
SQL-status: 08001
SQL-Server-error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL-server does not exist or access denied

Turning off firewall on server for Domain and it works!! However I want that turned ON so here's what I've done so far:

In sql server config manager I've manually set the port on the sql instance tcp/ip protocol to 1433 and deleted the 0 next to dynamic (and restarted the instance)
I've made a Inbound rule on firewall 1433 TCP Domain Allow
I checked in netstat (with firewall off) that the client acually uses 1433
Tried to delete the 1433-rule in firewall and reapply
Tried to "add program" sql srv instance path to "sqlservr.exe"
Have also rebooted both client and server several times

It clearly has to be firewall related on the server since the client can connect when I turn the firewall off (domain). But I am out of ideas on how to fix this so any help would be greatly (500points) appreciated... :)
0
tsnirone
Asked:
tsnirone
1 Solution
 
tsnironeAuthor Commented:
Ok, I added TCP 2382 and UDP 1434 to Inbound domain and now it seems to work....

phew...
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now