Connection String (Works on DiscountAsp doesn't work Locally)

Hello,

I am using the following MS SQL Server connection string that works fine when I upload to the DiscountASP servers but errors with "Can't find server or don't have access" message when I try to debug from my local computer. I can access DiscountASP's SQL server just fine in Enterprise Manager so I am lead to belive it is not a sercurity or firewall issue. Does anyone see any problems with this connection string?




System.Data.SqlClient.SqlConnection myConn = new System.Data.SqlClient.SqlConnection("server=mssql07.discountasp.net;database=db_126363;uid=MyUserName;pwd=########;");





I would just like to be able to debug my website locally so that I can use breakpoints and also don't have a stechy page online.





Thanks.

 

Thanks for the reply bruce.

I have tried many different connection strings, and I am using a FQDN and I have tried using an IP address also. I ran etherreal and I see traffic going to the discountASP SQL server, so I know it is at least talking to it. Unfortunatly I don't know much about the traffic that goes to a SQLserver so I can't really diagnose at the Packet level unless I really read up on SQL server, which at the present time I don't really want to

I havn't tried this from my home computer yet, just at the office. We have ISA server here and I am using MS Firewall Client. (My account is setup for full access on ISA andI do not see any blocked traffic from my account/ip to idicate that it is a port blocking issue) Do you think that IIS on my local XP local machine just isn't using that correctly? Like I said before though Enterprise Manager works fine, and so does everything else.



Welp, if anyone else has any thoughts or has experienced similar problems, please letme know!

Thanks.