Windows Server 2008 firewall permission with SQL Server

[Flomo Togba Kwele]

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

[Meinolf Weber]

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
>

[Ryan Hanisco]

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
>

[Ryan Hanisco]

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
> >