MSSQL 2008 on Windows 2008 Server Standard R2
I have been bashing my head against a wall for about a month now trying to enable remote access to my MSSSQL server.
I have switched off the firewall completely so and it made no difference so that is not the issue.
I have confirmed that I have enabled the right ip addresses in the sql tcp/ip settings and sql is set to allow remote logins.
There is only 1 instance installed on the server, and local logins work without a hassle.
I have no idea why this is not working, if you have any ideas please let me know!