First-time SQL Server 2008 R2 management Studio Connection problems.

Discussion in 'Databases' started by Philip Morrison, Jan 26, 2015.

  1. Upon first trying to connect SQL Server 2008 R2 Query Management Studio to my Discount ASP.NET database, I get the following message:

    Cannot connect to sql2k804.discountasp.net. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

    Here are the values for the login fields in Management studio.

    Server type: Database Engine
    Server Name: sql2k804.discountasp.net
    Login: SQL2008R2_929735_sharptongue_user
    Password: [my site password]

    I am trying to connect from work, so it could be that the work network is blocking my connection. Will try from home as well.

    Thanks.
     
  2. BTW: Authentication is set to SQL Server Authentication.
     
  3. martino

    martino DiscountASP.NET Staff

    It could be that the network connection is blocking the ports of: 1433 or 14330

    Try changing the port in your settings to: 14330

    If that doesn't work try to telnet to: sql2k804.discountasp.net 1433
    Or: sql2k804.discountasp.net 14330

    If you can connect you will just get a blank screen. If you can't connect you will get an error message saying you can't connect.
     
  4. Thanks Martino,

    Once I connected from home, I was able to get to my database. Woo hoo!

    Phil
     
    martino likes this.

Share This Page