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 enableRight-click
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
And then type in the command
And voilĂ , it's working!