Hoping someone can give a helping hand here [:)]

So I've got Management Studio installed here (as part of a local MSSQL2005 server) and I'm trying to connect to my UltimaSQL database, but all I keep getting is a rather non-descript error message like below. The funny thing is I am pretty sure the connection is actually working fine as I am able to list available databases on the server (by browsing server for my 'default database').

I'm using mssql2005.mydomainname.com (although I've tried ultimasql.net, IP-only, blah blah blah) as the server, using what I believe is the correct username/password (it works from web.config anyhow). I've tried various combinations of encrypted connections, time-out's, protocols and packet-sizes but I'm still not getting anywhere.

I'm on a double NATed network here (i.e. running in the 192. range here which is behind a semi-local 10. network which finally connects to the net a couple thousand miles away [:p]) but I wouldn't have thought that should cause any problems. Right?

Tried this from two machines (2003 R2 server and Vista RTM) and getting the same error message on both.

Anywho, the error message I keep getting is this;

Cannot connect to mssql2005.mydomainname.com.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) (Microsoft SQL Server, Error: 121)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=121&LinkId=20476

I've obviously tried the htmlinks, but they just tell me no more information is available. Tried googling the error and still didn't really come up with anything [:(]
It's a pain in the *** to use the myLittleAdmin interface over the web, so please, any suggestions?

Hi emigrating,

If you can connect via our web interface at ultimasql.net and your site is working and you have tried using the direct IP (69.16.210.14) then this is a sure sign that your firewall is blocking port 1433. 

Cheers,

Mark 

Hi Mark, thanks for your answer.

That's what I thought also, unfortunately that's not the issue. It was one of the first things I checked when it wouldn't work, also tried telnet'ing and osql to connect - both works fine.

The strange thing is that Management Studio connects just fine as I can see the list of available databases under the Advanced tab - btu as soon as I hit Connect it seems to 'time out' and throw a fit. I've tried again today from another network and it actually works fine, so either there was an issue with the server yesterday or there is something up with my local setup - I was able to connect to another remote SQL no problems thuogh.

Anyhow, if it still doesn't work I can always use Remote Desktop to reach this network and do it that way.