Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL and Windows Firewall

 
   Database Help (Home) -> Security RSS
Next:  How do I drop DBO access to a DB?  
Author Message
Serge Ayotte

External


Since: Nov 13, 2008
Posts: 2



(Msg. 1) Posted: Thu Nov 13, 2008 7:46 am
Post subject: SQL and Windows Firewall
Archived from groups: microsoft>public>sqlserver>security (more info?)

Hello all.

I have a client that I need to enable the Windows firewall since he's
on a University network, but having delt only with secure network
before, I have never really taken any time to research the WF (I know,
my bad in a way, but like I said, I have always dealt with network
BEHIND a firewall).

Is there any docs out there on what to do to keep the SQL running
correctly and accessible to those that needs to access it (they use
the same AD as the university), and communication with the CRM server
and a Sharepoint one.

Thanks for any help, tips and pointer!!! (now I need to repeat this
message for Sharepoint and CRM Very Happy )

 >> Stay informed about: SQL and Windows Firewall 
Back to top
Login to vote
Uri Dimant

External


Since: Aug 24, 2003
Posts: 1744



(Msg. 2) Posted: Sun Nov 16, 2008 3:25 am
Post subject: Re: SQL and Windows Firewall [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi
http://www.sql-server-performance.com/articles/dba/Configure_Windows_F...wall_fo



"Serge Ayotte" wrote in message

> Hello all.
>
> I have a client that I need to enable the Windows firewall since he's
> on a University network, but having delt only with secure network
> before, I have never really taken any time to research the WF (I know,
> my bad in a way, but like I said, I have always dealt with network
> BEHIND a firewall).
>
> Is there any docs out there on what to do to keep the SQL running
> correctly and accessible to those that needs to access it (they use
> the same AD as the university), and communication with the CRM server
> and a Sharepoint one.
>
> Thanks for any help, tips and pointer!!! (now I need to repeat this
> message for Sharepoint and CRM Very Happy )

 >> Stay informed about: SQL and Windows Firewall 
Back to top
Login to vote
"Rick Byham,

External


Since: Feb 06, 2008
Posts: 47



(Msg. 3) Posted: Mon Nov 17, 2008 10:28 am
Post subject: Re: SQL and Windows Firewall [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

A long list of ports that might be needed is in Books Online.
http://msdn.microsoft.com/en-us/library/cc646023.aspx
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Uri Dimant" wrote in message

> Hi
> http://www.sql-server-performance.com/articles/dba/Configure_Windows_F...wall_fo
>
>
>
> "Serge Ayotte" wrote in message
>
>> Hello all.
>>
>> I have a client that I need to enable the Windows firewall since he's
>> on a University network, but having delt only with secure network
>> before, I have never really taken any time to research the WF (I know,
>> my bad in a way, but like I said, I have always dealt with network
>> BEHIND a firewall).
>>
>> Is there any docs out there on what to do to keep the SQL running
>> correctly and accessible to those that needs to access it (they use
>> the same AD as the university), and communication with the CRM server
>> and a Sharepoint one.
>>
>> Thanks for any help, tips and pointer!!! (now I need to repeat this
>> message for Sharepoint and CRM Very Happy )
>
>
 >> Stay informed about: SQL and Windows Firewall 
Back to top
Login to vote
Serge Ayotte

External


Since: Nov 13, 2008
Posts: 2



(Msg. 4) Posted: Tue Nov 25, 2008 7:43 am
Post subject: Re: SQL and Windows Firewall [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you to the both of you, at least I have some starting point!!

My regards!
Serge

On Nov 17, 1:28 pm, "Rick Byham, \(MSFT\)"
wrote:
> A long list of ports that might be needed is in Books Online.http://msdn.microsoft.com/en-us/library/cc646023.aspx
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Uri Dimant" wrote in message
>
>
>
>
>
> > Hi
> >http://www.sql-server-performance.com/articles/dba/Configure_Windows_...
>
> > "Serge Ayotte" wrote in message
> >
> >> Hello all.
>
> >> I have a client that I need to enable the Windows firewall since he's
> >> on a University network, but having delt only with secure network
> >> before, I have never really taken any time to research the WF (I know,
> >> my bad in a way, but like I said, I have always dealt with network
> >> BEHIND a firewall).
>
> >> Is there any docs out there on what to do to keep the SQL running
> >> correctly and accessible to those that needs to access it (they use
> >> the same AD as the university), and communication with the CRM server
> >> and a Sharepoint one.
>
> >> Thanks for any help, tips and pointer!!! (now I need to repeat this
> >> message for Sharepoint and CRM Very Happy )- Hide quoted text -
>
> - Show quoted text -
 >> Stay informed about: SQL and Windows Firewall 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Firewall and Ports - Hello I would like to know which ports need to be open to enable SQL server 2000 connectivity by default. Thanks

SQL Server Enterprise Manager blcoked by Firewall? - I can't connect to the SQL Server instance on my own machin (XP SP2), form other machines, even when I've logged into that machine as myseldf nor can colleagues, who are also Domain Admins. The Domain Admins have admin rights to my SQL server instance...

ICF, SQL SERVER 2000 and Windows 2003 - Is it possible to configure a W2K3 server's ICF (internet connection firewall) to allow remote connection of EM (enterprise manager) to SQL Server 2000? I tried creating 2 new "applications" on port 1433 TCP and 1433 UDP, and was unable to c...

How to implement Windows Authentication? - I want to create an application which can work with SQL Server 2005/2008 using Windows Authentication or SQL Authenticaton. If the application is configured to use SQL Authentication (SQL Server is configured to use SQL Server and Windows..

Confused about Windows Authentication - Hi, I read in the help file for MSSQL 2005 that Windows Authentication is better than SQL Server authentication. Okay. So here's my scenario and what I think I should do. Hopefully, you can offer me some advice. I have an application that interfaces...
   Database Help (Home) -> Security All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]