Windows Server 2008 firewall permission with SQL Server

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

[Guest Meinolf Weber]

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

>

[Guest Ryan Hanisco]

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

>

[Guest Ryan Hanisco]

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

> >