Cannot connect to another SQL Server through SQL mangement Studio

Posted on 2014-08-30
Last Modified: 2014-09-04
Try to connect to another SQL 2008R2 server but it can't connect. Any idea ? Which port should it be excluded on the firewall on the remote server ? Is there any setting that I need to configure as well ?

Question by:AXISHK
    LVL 3

    Accepted Solution

    is this sql server inside or outside your network? if outside, the default port is 1433 if you don't specify a port in your connection.  So the remote server would need to have that port opened.  Or it can have a different port open but you would need to include in your connection, usually IP:port.

    did you specify the sql instance on the remote server? it could be sqlexpress or a named instance.
    LVL 7

    Assisted Solution

    by:Pushpakumara Mahagamage
    Check Whether remote connection allow in remote server, check on remote server  SQL Server configuration manager > SQL Server network configuration > Protocol for your instance ID, and then TCP IP, you have to enable TCP if it's not. you can check server port there.   if it's default instance TCP 1433 inbound need to open on remote Server and 1433 outbound need to open on your PC.
    LVL 4

    Assisted Solution

    by:Randy Knight, MCM
    Can you ping it?  Make sure name resolution is working.

    If you've done the above and it's still not working, a good way to test the network connectivity is to telnet to the port.  You may have to add the telnet client as a Windows feature but then you can execute this replacing remoteserver with the server name or IP address and putting the correct port if it's not the default 1433.

    telnet remotehost 1433

    Open in new window

    It should connect immediately and all you'll get is a blank screen.  But that will tell you that your network connectivity is working.

    If it times out, then you have a network issue at some level.  Most likely a firewall.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now