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.
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.