Unable to connect to SQL Server 2008 Clinet system from Windows7

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Unable to connect to SQL Server 2008 Clinet...

Unable to connect to SQL Server 2008 Clinet system from Windows7

Rate Topic

Display Mode

Topic Options

Author

Message

balajii

Posted Wednesday, September 26, 2012 1:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 12, 2012 6:02 AM
Points: 5, Visits: 15

hi all,

I try login to my client system sql server using Sql Server Client Management Studio 2008 wit Windows 7. Am connecting to client network using telnet. Am getting the following error. Same database can be connect throught Windows XP. Is any changes we need to do? Please help ASAP

TITLE: Microsoft SQL Server Management Studio
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) (Microsoft SQL Server, Error: 121)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=121&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Regards,
balaji

Post #1364464

tim_harkin

Posted Wednesday, September 26, 2012 5:48 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 3:07 PM
Points: 138, Visits: 355

Is the SQL server pingable?

Post #1364588

jason.spangler

Posted Wednesday, September 26, 2012 6:45 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 11:01 AM
Points: 62, Visits: 308

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

-
Jason

Post #1364624

balajii

Posted Wednesday, September 26, 2012 7:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 12, 2012 6:02 AM
Points: 5, Visits: 15

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.

Post #1364637

balajii

Posted Wednesday, September 26, 2012 7:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 12, 2012 6:02 AM
Points: 5, Visits: 15

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

Post #1364639

balajii

Posted Thursday, September 27, 2012 6:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 12, 2012 6:02 AM
Points: 5, Visits: 15

Hi,,, any updates plz

Post #1365192

tim_harkin

Posted Thursday, September 27, 2012 7:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 3:07 PM
Points: 138, Visits: 355

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

Post #1365268

balajii

Posted Thursday, September 27, 2012 10:58 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 12, 2012 6:02 AM
Points: 5, Visits: 15

Hi all,

Issue soved, I done the following from my network:

netsh int tcp set global autotuninglevel=disabled

Thanks to all

Post #1365603

« Prev Topic | Next Topic »

Permissions