ah confirmation! Thanks Geoge and Dan! I was pretty sure it wasn't reaching SQL but the apps guys were telling me it was so I was starting to doubt myself.
thanks for the reply! I've checked the instance name is correct and the firewall is ok. The app has been running successfully for 6 months. I've actually found the reason...