Unable to connect to a SQL Server database remotely

I have a SQL Server 2008 R2 Developer edition set up on a Windows Server 2008 R2 edition and although I was able to get into the database locally via SQL Server Management Studio (using my server name\MSSQLSERVER), I was unable to get in there remotely (using IP\MSSQLSERVER).

I have turned off t开发者_运维问答he firewall for Windows (no other firewall installed) and turned on all 4 protocols for SQL Server (Shared Memory, Named Pipes, TCP/IP and VIA) and has turned on every single service in the SQL Server Management Studio with no luck.

Could you please help me?

Many thanks in advance!

---

enable TCP/IP, Shared Memory and Named Pipes from all prorams> sql 2012 > configuration tools > sql server configuration manager > expand sql server network configuration > protocols for sql2012r2de

---

Did you check the following?

1. Configure SQL Server to allow remote connections
2. Configure TCP/IP connection enabled and on IP Address tab specific to Ip Address change to Active -> Yes, Enabled -> Yes
3. Add/Check Firewall policy is open for port 1433(Default) or specific port according to your sql server listner port

---

Are you sure you're connecting to the developer instance?? From the instance name, it would appear that you have a SQL Server Express edition installed....

Check by running this SQL statement:

SELECT  
    SERVERPROPERTY('edition')

SQL Server Express does not allow remote connections by default - see this Microsoft KB to learn how to enable remote connections.

---

Problem fixed after reinstall the whole system and open port 1433 for TCP connections.