I am using a GoDaddy hosted virtual dedicated server and installed Sql Server 2008 Express R2. I can connect locally but cannot connect remotely.
The sql server error log returns this: "Login failed for user 'user_name'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: ip_address]."
That is the problem. I have the server set to both "Sql Server and Windows Authentication".
Rebooted the server to make sure all services are restarted and still same error.