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.

Advertisements

Tags: , , , ,

6 responses to “How To Enable Remote Connections SQL Server 2012 Express”

  1. michaelhuerta says :

    Thanks for finally talking about >How To Enable Remote Connections SQL
    Server 2012 Express | sysBADmin <Liked it!

  2. Juan Pablo says :

    I don’t know if I was doing something wrong, but I wasn’t able to connect to other servers until I enabled server browser.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: