SQL Server 2005 Management Studio connection problem with database

Hi, i just got registered for hosting our site on the DiscountASP servers. I have uploaded the needed files for the site but i'm having trouble connecting to the database (SQL Server 2005) using Management Studio Express. I put in all the login required information which was:

Server Name: esql2k501.discountasp.net
User Name: SQL2005_560862_pmn_*****

When i click Connect, i get the following error

TITLE: Connect to Server
------------------------------

Cannot connect to esql2k501.discountasp.net.

------------------------------
ADDITIONAL INFORMATION:

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)

For help, click: http://go.microsoft.com/fwlink?Prod...rver&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

------------------------------

I also tried connecting with the OSQL command and that too didnt work, here's the result:

>osql -S esql2k501.discountasp.net -U SQL2005_560862_***_user -P *****
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).

I have tried doing a trace route to the esql2k501.discountasp.net server with the following command but not luck.
>telnet sql2k502.discountasp.net 1433
Connecting To sql2k502.discountasp.net...Could not open connection to the host,
on port 1433: Connect failed

>telnet sql2k502.discountasp.net 14330
Connecting To sql2k502.discountasp.net...Could not open connection to the host,
on port 14330: Connect failed

I also tried pinging this server but the ping command returns time out error:

>ping esql2k501.discountasp.net

Pinging esql2k501.discountasp.net [89.187.101.73] with 32 bytes of data:

Request timed out.
Request timed out.
Request timed out.

Ping statistics for 89.187.101.73:
Packets: Sent = 3, Received = 0, Lost = 3 (100% loss),

Then i checked with the trace route utility at www.DNSStuff.com and that came up with the information that i'v attached as an image.
I have tried connecting with Management studio 2005 and Management Studio 2005 Express but no luck, please help. </font>

 

Something is blocking the connection on your end. The fact that you performed a ping test and it resolved to the correct IP address shows that it knows it. But the drop packet can indicate some firewall resolution issue. Try using another network to connect to the database server. You should double check your firewalls and see if it has whitelist/black list features. Also having port 1433 or 14330 open is crucial. These are our SQL ports without them you can't connect to our database server. Also I've seen some issues where the router may have routing table may have gotten corrupted. A simple router recycle (powering the router off and on) can help. When it doubt always try the easiest fix first.

rcp
DiscountASP.NET
www.DiscountASP.NET