SQL Server 2008 remote logins fail, local succeeds, remote logins enabled?

Question

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!

Solution 1

Doh! I was specifying port 2434 with my connection string. This is not necessary, and causes problems. Removing the port specification fixed this issue.

Solution 2

I had this exact same problem, in my case SQL Server Browser service was not running on my SQL server. Starting that service removed the error and allowed me to connect remotely.

Comments

[squillman]

chuckle Wish I had a nickel for every horked connection string I've written...