sql-serversql-server-2008connection-stringdiscountasp

Connect to SQL Server database


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:


Solution

  • 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