Go Back   TechArena Community > Technical Support > Computer Help > Windows Server > Windows Server Help
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Windows Server 2008 firewall permission with SQL Server

Windows Server Help


Reply
 
Thread Tools Search this Thread
  #1  
Old 23-02-2008
Flomo Togba Kwele
 
Posts: n/a
Windows Server 2008 firewall permission with SQL Server

I installed SQL Server 2005 x64 SP2 on a Windows Server 2008 x64 Standard version. I installed the workstation portion
of SQL Server 2005 on a Vista x64 system. When I tried to connect from the client, I got a SQL Server error 10060, could
not connect.

I went to the Windows Server 2008 and turned off the firewall and then could connect from the Vista client to the
server. Can anyone tell me how to properly configure the firewall to allow SQL Server traffic?

TIA Flomo

Reply With Quote
  #2  
Old 23-02-2008
Meinolf Weber
 
Posts: n/a
Re: Windows Server 2008 firewall permission with SQL Server

Hello Flomo,

Try to open port 1433 in the firewall and check this one:
http://support.microsoft.com/kb/914277

Best regards

Meinolf Weber
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm

> I installed SQL Server 2005 x64 SP2 on a Windows Server 2008 x64
> Standard version. I installed the workstation portion
>
> of SQL Server 2005 on a Vista x64 system. When I tried to connect from
> the client, I got a SQL Server error 10060, could
>
> not connect.
>
> I went to the Windows Server 2008 and turned off the firewall and then
> could connect from the Vista client to the
>
> server. Can anyone tell me how to properly configure the firewall to
> allow SQL Server traffic?
>
> TIA Flomo
>



Reply With Quote
  #3  
Old 24-02-2008
Ryan Hanisco
 
Posts: n/a
RE: Windows Server 2008 firewall permission with SQL Server

Hi Flomo,

On the server:
1. Open the Windows Firewall with Advanced Security
2. Right Click on onbound rules and select New Rule
3. Create a Port Rule, Click Next
4. Choose TCP rule and choose ports 1433, 1444. Click Next.
5. Choose Allow the connection. Click Next.
6. Choose the correct profile. By default all of them are on, but you might
choose only to let domain machines access SQL... Click Next
7. Specify a Name and a Description for the Inbound Rule. Click Finish
8. Your rule should be created

On client, make sure that the console is connecting over TCP/IP and you
should be there.

--
Ryan Hanisco
MCSE, MCTS: SQL 2005, Project+
http://www.techsterity.com
Chicago, IL

Remember: Marking helpful answers helps everyone find the info they need
quickly.


"Flomo Togba Kwele" wrote:

> I installed SQL Server 2005 x64 SP2 on a Windows Server 2008 x64 Standard version. I installed the workstation portion
> of SQL Server 2005 on a Vista x64 system. When I tried to connect from the client, I got a SQL Server error 10060, could
> not connect.
>
> I went to the Windows Server 2008 and turned off the firewall and then could connect from the Vista client to the
> server. Can anyone tell me how to properly configure the firewall to allow SQL Server traffic?
>
> TIA Flomo
>

Reply With Quote
  #4  
Old 24-02-2008
Ryan Hanisco
 
Posts: n/a
RE: Windows Server 2008 firewall permission with SQL Server

Typo there.... 1434 too.
--
Ryan Hanisco
MCSE, MCTS: SQL 2005, Project+
http://www.techsterity.com
Chicago, IL

Remember: Marking helpful answers helps everyone find the info they need
quickly.


"Ryan Hanisco" wrote:

> Hi Flomo,
>
> On the server:
> 1. Open the Windows Firewall with Advanced Security
> 2. Right Click on onbound rules and select New Rule
> 3. Create a Port Rule, Click Next
> 4. Choose TCP rule and choose ports 1433, 1444. Click Next.
> 5. Choose Allow the connection. Click Next.
> 6. Choose the correct profile. By default all of them are on, but you might
> choose only to let domain machines access SQL... Click Next
> 7. Specify a Name and a Description for the Inbound Rule. Click Finish
> 8. Your rule should be created
>
> On client, make sure that the console is connecting over TCP/IP and you
> should be there.
>
> --
> Ryan Hanisco
> MCSE, MCTS: SQL 2005, Project+
> http://www.techsterity.com
> Chicago, IL
>
> Remember: Marking helpful answers helps everyone find the info they need
> quickly.
>
>
> "Flomo Togba Kwele" wrote:
>
> > I installed SQL Server 2005 x64 SP2 on a Windows Server 2008 x64 Standard version. I installed the workstation portion
> > of SQL Server 2005 on a Vista x64 system. When I tried to connect from the client, I got a SQL Server error 10060, could
> > not connect.
> >
> > I went to the Windows Server 2008 and turned off the firewall and then could connect from the Vista client to the
> > server. Can anyone tell me how to properly configure the firewall to allow SQL Server traffic?
> >
> > TIA Flomo
> >

Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Windows Server > Windows Server Help
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Windows Server 2008 firewall permission with SQL Server"
Thread Thread Starter Forum Replies Last Post
Installing a function of Windows Server 2008 Server Core SalVatore Tips & Tweaks 2 28-08-2010 04:03 PM
Server 2008: You don't currently have permission to access this folder HAL07 Windows Server Help 7 24-11-2009 11:27 AM
how can i make 2008 server as a firewall server pl guide me Ehtheshamuddin Operating Systems 1 06-08-2009 04:49 PM
Server 2008 with Hyper-V - domain controller - Firewall GUI's show firewall ON, but netsh reports firewall OFF Bruce Sanderson Windows Server Help 6 07-10-2008 03:27 PM


All times are GMT +5.5. The time now is 07:34 AM.