Sql Server Connect error when firewall is on

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

General SQL Server Forums

New to SQL Server Administration

Sql Server Connect error when firewall is on

Author

Topic

chakotay2
Starting Member

2 Posts

Posted - 2011-06-11 : 11:15:02

I am running Server 2008 Standard with SQL 2008 R2 Express.

When trying to connect to my SQL DB from a client machine, I am getting a [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

If I turn the firewall completely off on the server, it connects from the remote client just fine. I have opened the following ports:
1433 TCP
1434 UDP
2383 TCP
4022 TCP

and added:
C:\program files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\sqlservr.exe

as an exception. I still can't get it to connect. Any ideas?

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-06-13 : 03:23:57

exclude your or client IP in the Firewall too

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

chakotay2
Starting Member

2 Posts

Posted - 2011-06-13 : 12:19:19

Can that be done by group policy? And if so and can it use a range? DHCP will hand out the address within a scope so the ip can change.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources