Cannot connect to SQL Server 2005 From Management Studio - target machine actively refused it

Discussion in 'Databases' started by Ljones27, Mar 19, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I am trying to connect to the my SQL Server 2005 database with SS Mangement Studio.

    I get this error:

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

    I also get the error when I try to run ASP.net app from my local machine. Everthing works find in the discount ASP.net environment.
    Thistheconnection data/string:
    "Data Source=tcp:sql2k5**.discountasp.net\;Initial Catalog=SQL2005********;User ID=*******;Password=*****;" providerName="System.Data.SqlClient"/>
     
  2. That slash should not be there,should be like this:

    Data Source=tcp:sql2k510.discountasp.net;
     
  3. I removed the slash and I get the same error.
    Thx
    LJ
     
  4. Joseph Jun

    Joseph Jun DiscountASP.NET Staff

    Hello Ljones27,

    Please open up a ticket with the Technical Support department regarding this problem since this is a problem that they can trouble shoot.

    Winston

    DiscountASP.NET
     
  5. LJ...Please leave a reply if you solve this.
    It will help others and I'd like to be as accurate as possible. [​IMG]
    Salute,
    Mark
     
  6. Bruce

    Bruce DiscountASP.NET Staff

    the most likely problem is port 1433 is not opened. Many isp blocks 1433 after the Nimda virus..


    A little bit of insider information.... Nimda is still the#1 attack blocked by our Intrusion Prevention system (Tipping Point)


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  7. Thanks for pointing that out bro...Valuable info for sure. [​IMG]
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page