Error Connecting Remotely to SQL Server 2008 Express on a Virtual Server
Posted on 2011-09-17
I have opened a Virtual Server Account with a Web hosting company. On the Virtual Server that I have been provided by this Company I have installed SQL Server 2008 Express Edition and put a Database on this Server. I would like to be able to connect to this Server Remotely, but when I try doing this I get the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I have spoken to the technical support for my Virtual Server and they have advised me the following:
You will have to make sure that port 1433 is open on firewall and make sure that you set the port to static MSSQL configuration for TCP/IP connection and set it to 1433.
I have tried doing the above (opening port 1433), but I am not sure how to do this and whether I have been able to do this or not. I am also not sure how to set the port to static MSSQL configuration for TCP/IP connection and set it to 1433.
I would be grateful for help with this.
Please note that the Operating System on my Virtual Server is Windows Server 2008 R2 Standard.