Unable to connect to SQL Server 2008 Clinet system from Windows7

  • 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

  • Is the SQL server pingable?

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

    -

    Jason

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

  • 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

  • Hi,,, any updates plz

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

  • Hi all,

    Issue soved, I done the following from my network:

    netsh int tcp set global autotuninglevel=disabled

    Thanks to all

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

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