none
Cannot connect from windows 7 to a sql server 2008 R2 instances running in a windows 2008 r2 via Static IP

    Question

  • We have an SQL 2008 R2 running in a windows 2008 R2 Server with a static IP but we are unable to connect to this server from a particular windows 7 32 bit client machine.

    But we can very well successfully connect to this server from other machines running win XPs and win7s

    Is there any settings specifically in win7 that should be configured ?

    or is there any modem settings ?

    What all way should we attempt to get this right ?

    Its very urgernt and hope someone will answer it soon

    Thanks in advance


    Thursday, July 11, 2013 9:34 AM

Answers

  • Hi soware,

    Since other computers can access SQL Server properly, this issue can occur due to the network connection between Windows 7 computer and Windows 2008 R2 server, we may need to involve the network administrator to help us troubleshoot the network connection issue. Currently, please try to ping Windows 2008 R2 server on Windows 7 computer side. Additionally, please make sure the SQL Server login you use with Windows 7 computer is valid. If it still fails to connect to SQL Server, please post the detail error message here for analysis. There are some other troubleshooting steps on the following link, you can also refer to them.

    Steps to troubleshoot SQL connectivity issues
    http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx

    If you have any feedback on our support, please click here.


    Allen Li
    TechNet Community Support

    Tuesday, July 16, 2013 9:56 AM
    Moderator