Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Firewall Issue

Author  Topic 

spleewars
Starting Member

1 Post

Posted - 2012-06-04 : 07:41:06
I apology if a similar question might lurk in many forums with many work arounds but i'm having a hard time to understand whats wrong.

Running Win Server 08 with SQL express 08. When the client connect to the domain controller and tries to connect to the SQL, i receive an ODBC connection error. I do know the problem is coming from the windows server firewall because when i turn off the 'domain firewall', the error disappears and connection is established correctly.

Researching i found this link and followed instructions [url]http://support.microsoft.com/kb/968872[/url]. Problem still remains however: when firewall is off, connection works, and when domain firewall is on... connection failure.

Any help please?

Sachin.Nand

2937 Posts

Posted - 2012-06-04 : 14:09:15
Did you open the ports on firewall for the sql instance on which it is running ? If yes then can you Telnet it ?

After Monday and Tuesday even the calendar says W T F ....
Go to Top of Page
   

- Advertisement -