Data tools cannot connect to SQL Server

Discussion in 'General troubleshooting' started by Cralis, Jul 24, 2014.

  1. Strange issue!

    My uploaded Web Application is working fine, and getting data from my database on s10 (SQL 2012)

    However, when I connect to the database using data tools in Visual Studio, to do Schema compares, it's unable to connect with a Connection Refused issue.

    Actually, as I type, Management Studio now can't get a valid connection. I can see the tables, but any query is failing with a 'Network related' error. Is there a known issue?
     
  2. Ray

    Ray

    Sounds like something is blocking the SQL ports. First as a test, the basic and easiest test is to temporarily bypass any routers, firewalls, and temporarily disabling your antivirus system on your computer/network. Then try performing a PING and Traceroute test to your SQL server, make sure the IP address matches that with the Winhost SQL server. Next perform a telnet test to the SQL server, you'll need to specifically test port 1433 and 14330. If you get some kind of error than something on your network maybe blocking the SQL ports.
     
    Last edited by a moderator: Oct 14, 2015

Share This Page