Solved

MSSQL Server 2008 R2 on SBS 2011 STD - Firewall problems

Posted on 2013-01-13
1
809 Views
Last Modified: 2013-12-02
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
Comment
Question by:tsnirone
1 Comment
 
LVL 3

Accepted Solution

by:
tsnirone earned 0 total points
Comment Utility
Ok, I added TCP 2382 and UDP 1434 to Inbound domain and now it seems to work....

phew...
0

Featured Post

Why spend so long doing email signature updates?

Do you spend loads of your time carrying out email signature updates? Not very interesting are they? Don’t let signature updates get you down. Let Exclaimer Cloud - Signatures for Office 365 make managing email signatures a breeze.

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now