Connecting to a remote instance of SQL Server (Developer Edition 2014)

It's been a while since my last post! Less posts means less problems, right?

Recently I had to connect to a remote instance of SQL Server Developer Edition 2014 and it was harder than expected <insert Microsoft whining here>. The solution is quite simple but until you know it, it can be quite evasive.

Lets get straight to the point.

How to make it work?

First configure your instance.

On your Sql Server Configuration Manager enable Shared Memory and TCP/IP protocols (Named Pipes shouldn't be needed though):

Right-click TCP/IP and click Properties and scroll to the bottom of the new window. You can set the desired port there. You can see that I used 51672 at the bottom under TCP Dynamic Ports:

After this, make sure the port is open on your the firewall (I opened both TCP and UDP):

Configure it as below:

(And do the same for UDP)

Now restart your instance service:

It looks like you should be able to connect remotely now, but sadly that may not be the case. If you still can't connect, open your command prompt (press Windows Key + R) and type cmd:

And then type in the command netsh Winsock reset:

And voilà, it's working!