Connecting to a SQL Server database, newbie question

[rodmjay]

I am having a hard time connecting to the SQL server from my computer. Here is what i have in client network utility.

Tab 1 (General): Enabled Protocols By Order: TCP/IP (on top), Named Pipes -- Properties for TCP/IP: Default Port: 1433
Tab 2 (Alias): Server Alias: RODMJAY, Network Library: TCP/IP, Connection Parameters: mssql07.discountasp.net

(Note: I pinged the mssqlp7.discountasp.net to make sure that it was valid)

I disabled my firewall, so that should not be blocking the port (that i know of, i dont know how to test this)

Here is the error message that i get when i try to connect the RODMJAY server Ive setup via query analyzer

'Unable to connect to server RODMJAY:

Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Sql Server does not exist or access denied.'

[junior]

rodmjay (http://community.discountasp.net/profile.aspx?f=16&m=8829&p=2646),


to test to see if the port is open, run the follwing commands:

From the Start Menu, select: RUN
Type in: cmd
In the popup window, type: telnet mssql07.discountasp.net 1433
if it fails, it will display - Connecting To mssql07.discountasp.net...Could not open connection to the host, on port 1433: Connect failed= port not open and try using 14330. if successful, a blank screen will appear= port is open
You want to make sure that you are using the correct username and password for your SQL server which the sql login can be found in the control panel - and the sql link of the sql server version that you have purchased


junior

DiscountASP.NET

www.DiscountASP.NET (http://www.DiscountASP.NET)