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:
- some hosting companies denies access default may have request access ip address
- 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
Post a Comment