Simple Excel & SQL setup?

[aceee]

hi all.

I'm starting to play with an online SQL server, and wanting to link it to excel.

i've gone to excel, opened a new SQL connection, entered the server, username and password, but i keep getting the error;

[DBNETLIB][ConnectionOpen (Connect()).]SQL Service does not exist or access denied.

i've tripple checked all the addresses, username & password but no luck..

am i missing something simple? do i need to change a setting in excel?

cheers