Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MSSQL Server 2008 R2 on SBS 2011 STD - Firewall problems

Posted on 2013-01-13
1
Medium Priority
?
838 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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

730 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