Solved

MSSQL Server 2008 R2 on SBS 2011 STD - Firewall problems

Posted on 2013-01-13
1
811 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
ID: 38772806
Ok, I added TCP 2382 and UDP 1434 to Inbound domain and now it seems to work....

phew...
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

773 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