Connect to SQL Server database

Question

I'm trying to connect to a SQL Server database at Discount asp.net hosting with SQL Server Management Studio. Here`s the connection string that is working fine. What parts of it should I use in Management Studio to connect to remote Db?

Data Source=tcp:sql2k803.discountasp.net;Initial Catalog=SQL2008_709539;
User ID=SQL2008_709539_user;Password=password;

I'm filling the fields in the following way:

• Server name: tcp:sql2k803.discountasp.net
• login: SQL2008_709539_user
• password: password
• authentication type is SQL Server.

Answer 1

• Database: SQL2008_709539
• Login: SQL2008_709539_user
• Password: password
• Host: sql2k803.discountasp.net

Please note also:

1. Some hosting companies denies access by default so you may have to request access from your IP address
2. Sometime I was unable to connect using host name, I used IP address to connect via Management Studio (such problem appear due firewall, proxy, etc)

ADDED: Also see whether you've enabled remote tcp/ip connections