Unable to connect to a SQL Server database remotely

Question

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 the 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!

Answer 1

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