topspeed007

i think this is sorted - and i need to change the subnets so that they match ...seems obvious now!

Hi guys This is my problem: I want my webserver on a local network to talk to my in house file server on a separate local network. When both are on the same network all is fine yet whatever I do on the alternate networks nothing changes. My Webserver(running Windows 2008 webserver) is on a network with an ip of 192.168.0.3, gateway is 192.168.0.1 subnet 255.255.255.255 using a netgear 834gt router. The file server (2003SBS Server) is 192.168.1.3 gateway 192.168.1.1 (subnet 255.255.255.0) dns 192.168.0.1 using a draytek Vigor 2820. The netgear has my inbound adsl connection and the draytek is connected to the netgear by Ethernet. The webserver is trying to access MS SQL 2005 express using std port settings and as previously mentioned when all connected on the same subnet all work fine, yet when I put in this config (which it’s supposed to be in for security) no data flows. I am using the webconfig file on the webserver to connect – which I suspect is now incorrect due to location change? (this is copy of conn. String where file server is name of my fileserver and password is fine) <connectionStrings><add name="ConnectionString" connectionString="Data Source=fileserver;Initial Catalog=TBS;User ID=sa;Password=xxxxxx" providerName="System.Data.SqlClient"/> </connectionStrings> I have been told that I may have to add a cmd route add xxxx mask xxx etc. I have tried with no firewall on both routers and o/s but no help. Any clues at all would help. Many thanks PS at present all I wish to do is build and test a webserver locally before hosting to the www - which nodoubt will present me wth another set of problems!