Everywhere I look, I get told I am able to connect to a remote server's (my VPS) SQL Server Express.
I have Windows Server 2008, I have run the port opening batch file to open all SQL ports, (and manually checked them in Windows Firewall Inbounds)
I have SQL Server 2008 Express installed and I know the sa username and password.
I have set right clicked the instance name in ssms and made sure SQL Server Authentication is checked.
I have gone in to configuration manager, made sure SQL Browser is running, Then gone to SQL Network Configfuration Enabled TCP/IP (And named pipes for good luck) and gone into TCP/IP Properties and made sure every IP Address version has enabled set to yes...
Then I restarted SQL Server Services to make sure the changes had effect.
I then went to my remote machine, using SQL Express also, and tried logging in (IP Address, SQL Server authentication, username and password) I even tried the port number 1433 at the end for good measure.
I have absolutely no idea what to do now. I've been tearing my hair out for 2 days. What else am I missing? The error I get is:
A network related or Instance specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Veri
View Complete Post