[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
-
I've developed an app that uses database on pc3 computer. my computer is pc1. My app connects fine with pc3 db from my computer (pc1) though I don't have iis installed. But when I put app on pc2 with iis installed. and try to access it like. (http://192.168.1.3/trackweb/ where trackweb is virtual directory assigned to it. It does not connect with pc3 database and gives above mentioned error. Some of the options I've tried. 1. turn firewall off. allow http port through firewall. 2. change connection string in a different ways. last one I tried.
Provider=sqloledb;Data Source=192.168.1.5;Initial Catalog=SpyTrack;User ID=sa;Password=psw;
3. install asp.net on pc3. 4. add local policy, and permit all ip traffic/ all icmp traffice on pc3. but nothing works. Hope someones there to help me. Regrads Asif Rehman