Unable to connect to SQL Server 2008 Clinet system from Windows7

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

tim_harkin SSCrazy Points: 2399 More actions · Answer 1

SSCrazy

Points: 2399

September 26, 2012 at 5:48 am

Is the SQL server pingable?

jason.spangler Say Hey Kid Points: 684 More actions · Answer 2

Make sure firewall on your Win7 client is either disabled or allows port 1433 traffic.

-

Jason

balajii Old Hand Points: 375 More actions · Answer 3

tim_harkin (9/26/2012)
Is the SQL server pingable?

Hi,

I can able to ping the server and i added it to host entry.

balajii Old Hand Points: 375 More actions · Answer 4

jason.spangler (9/26/2012)
Make sure firewall on your Win7 client is either disabled or allows port 1433 traffic.
-
Jason

I added the port 1433 on Windows Firewall with advancedsecurity - Inbound and Outbound rules

I added the port 1434 on Windows Firewall with advancedsecurity - Inbound and Outbound rules

and allowed this two programs also on rules:

C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe

C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe

Thanks in advance

balajii Old Hand Points: 375 More actions · Answer 5

Old Hand

Points: 375

September 27, 2012 at 6:28 am

Hi,,, any updates plz

tim_harkin SSCrazy Points: 2399 More actions · Answer 6

Anything in the event logs? Can you try connecting with SQLCMD?

balajii Old Hand Points: 375 More actions · Answer 7

Hi all,

Issue soved, I done the following from my network:

netsh int tcp set global autotuninglevel=disabled

Thanks to all