I have an MS Access database that I am using to connect to SQL Server. SQL Server is installed on a server running Windows Web Server 2008 OS. If I install the MS Access database on the server, I can connect locally with no problem. Yet when I go to connect from my office PC over the internet it will not connect. The latest error message reads...
SQL State 28000
SQL Error 18452
Login failed for user ''. The user is not associated with a trusted SQL Server Connection.
I am using port 5000 to connect to the server over the internet. I have been told that this port is bing forwarded to the server. I modified the firewall to allow access over ports 1433-1434 and 5000 over TCP/IP and the same over UDP.