This one has me stumped. My SQL 2008 Express resides on a remote Server 2003. My client resides on Windows 7. I VPN into the remote server and have always been able to access the database until recently and I do not know what has changed.
I access via SQL authentication and I have insured that the user is valid along with his password. I have gone through the complete checklist and to the best of my knowledge, have set all parameters and security settings properly. I can get to the remote
desktop via RDC and can access the database and tables perfectly yet when I attempt the remote access I receive an error "-40" along with an error "2". I have googled both and followed all instructions but am still locked out. Oh, these errors
seem to relate to the remote server not being accessible.
View Complete Post