Connect to SQL Server database -


i'm trying connect sql server database @ discount asp.net hosting sql server management studio. here`s connection string working fine. parts of should use in management studio connect remote db?

data source=tcp:sql2k803.discountasp.net;initial catalog=sql2008_709539; user id=sql2008_709539_user;password=password; 

i'm filling fields in following way:

  • server name: tcp:sql2k803.discountasp.net
  • login: sql2008_709539_user
  • password: password
  • authentication type sql server.

  • database: sql2008_709539
  • login: sql2008_709539_user
  • password: password
  • host: sql2k803.discountasp.net

please note also:

  1. some hosting companies denies access default may have request access ip address
  2. sometime unable connect using host name, used ip address connect via management studio (such problem appear due firewall, proxy, etc)

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


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -