I'm running SQL Server 2008, with remote connections enabled, and mixed Windows Authentication and SQL Server Authentication enabled. The logins I have setup (Windows and SA) work fine from the server. However, when I login from a remote computer, I receive the error "Login failed for user ...".
Any ideas? Before I was receiving a "remote connections not enabled" error, but enabled that and now receive this new error.
Any help is greatly appreciated!