How To Enable Remote Connections SQL Server 2012 Express
I know I have previously covered this with SQL Server 2008 Express but there’s some subtle differences in SQL Server 2012 Express, so here’s a bullet point guide:
- Open the SQL Server Configuration Manager
- Expand SQL Server Network Configuration – Protocols for SQLEXPRESS
- Enable TCP/IP
- Right click TCP/IP and open Properties
- Check the IP2 settings reflect the servers IP address and subnet
- Check IPAll and ensure that Dynamic Ports is blank and make sure that the TCP port is set to 1433
Try connecting to the server from a remote machine using SQL Management Studio or your favourite tool, you should be good!
If not, expand SQL Server Services from the SQL Server Configuration Manager and change the SQL Browser Service to Automitic and start it, then try again.
Also, it’s worth noting that if you’ve already had a fiddle you may need to double check that you have still got Allow remote connections to this server enabled on the instance options. Here’s how to check:
- Open Microsoft SQL Server Management Studio and connect to the desired instance.
- Right click on the instance node and click Properties
- Click on Connections and check that Allow remote connections to this server is checked and you haven’t limited your maximum number of connections over drastically
Warning: When stopping and starting SQL services it is worth making sure that the databases are not in use so as not to effect any live systems.