Enable remote connections for SQL Server Express 2012

by

Well, glad I asked. The solution I finally discovered was here:

How do I configure SQL Server Express to allow remote tcp/ip connections on port 1433?

  1. Run SQL Server Configuration Manager.
  2. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
  3. Make sure TCP/IP is enabled.

So far, so good, and entirely expected. But then:

  1. Right-click on TCP/IP and select Properties.
  2. Verify that, under IP2, the IP Address is set to the computer’s IP address on the local subnet.
  3. Scroll down to IPAll.
  4. Make sure that TCP Dynamic Ports is blank. (Mine was set to some 5-digit port number.)
  5. Make sure that TCP Port is set to 1433. (Mine was blank.)

(Also, if you follow these steps, it’s not necessary to enable SQL Server Browser, and you only need to allow port 1433, not 1434.)

These extra five steps are something I can’t remember ever having had to do in a previous version of SQL Server, Express or otherwise. They appear to have been necessary because I’m using a named instance (myservername\SQLEXPRESS) on the server instead of a default instance. See here:

Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)

More Related Contents:

  1. Wait on the Database Engine recovery handle failed!! SQL Server 2012 installation
  2. Use TO_DATE in SQL Server 2012
  3. Can’t create stored procedure with table output parameter
  4. Code first custom SQL migration timeout exception
  5. I dont know sql syntax for my table [closed]
  6. Taking lot of time to read from SQL Server using c#
  7. query sql between two tables [duplicate]
  8. Identity increment is jumping in SQL Server database
  9. How to check if a column exists in a SQL Server table
  10. Auto increment primary key in SQL Server Management Studio 2012
  11. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  12. Connecting to Postgresql in a docker container from outside
  13. STRING_SPLIT in SQL Server 2012
  14. XML Server XML performance optimization
  15. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  16. Can’t connect to localhost on SQL Server Express 2012 / 2016
  17. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0
  18. Scope of temporary tables in SQL Server
  19. Sequence vs identity
  20. Getting total row count from OFFSET / FETCH NEXT
  21. Last executed queries for a specific database
  22. Full text search does not work if stop word is included even though stop word list is empty
  23. Avg of float inconsistency
  24. Convert Date format into DD/MMM/YYYY format in SQL Server
  25. Joining multiple tables returns NULL value
  26. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  27. Cannot Resolve Collation Conflict
  28. Try_Convert for SQL Server 2008 R2
  29. How to get Previous Value for Null Values
  30. Create a user defined table type in c# to use in sql server stored procedure

Leave a Comment