I am having trouble connecting to a remote mssql, local mode works but trying to use mssql_connect to remote pc on my local network does not work and gives this error:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.0.x in …\php\sql.php on line 9
Couldn’t connect to SQL Server on 192.168.0.x. Error:
This error started to appear from me to install my new router mikrotik rb1100ahx2, someone had the same problem?
I would guess that you can’t connect to anything on 192.168.0.x network. I suspect that you have not setup any routing protocol. Anyhow that is just a guess. Can you compare the old configuration to the new configuration? Maybe when you transferred the configuration you missed something like “network 192.168.0.1 255.255.255.0 interface 2” but that is just a guess or put in a static route “ip route 192.168.0.x interfacex” NOTE the syntax is not accurate. Also maybe go ask in the router forum, this is the dude forum, for monitoring.