Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • Last Modified:

How to Make SQLEXPRESS 2012 Instance Visible

I have a new SQLEXPRESS 2012 server running on Windows Server 2012 R2.  The database is up and running, but can't be seen by other servers in the network.  I've followed instructions from here (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_26564401.html) with still no luck.  To confirm:
Firewall is off entirely (for testing purposes)
Within SQL Server Configuration Manager, both Named Pipes and TCP/IP are enabled
In TCP/IP properties --> IP Addresses, I've got four IP addresses listed (static IPv4 & IPv6, loopback IPv4 & IPv6) and IPAII, each with TCP Dynamic Ports blank and TCP Port as 1433

I've also reviewed the steps in this link (http://msdn.microsoft.com/en-us/library/ms177440.aspx#SSMSProcedure) which are slightly different than the one above, but still no luck.

There are two things I see that catch my eye as possible solutions.  In each of the IP Addresses listed under TCP/IP properties, they are listed as Active: Yes and Enabled: No.  Is this correct?  If they are supposed to be Enabled: Yes, how would I do so?  (The drop down menus are blank, no allowing me to enter a manual value.)

Lastly, do I simply need to enable the SQL Browser Service, and if so, what is the reason for doing or not doing so?

Thanks in advance!
0
Dan Carp
Asked:
Dan Carp
1 Solution
 
Valliappan ANSenior Tech ConsultantCommented:
Did you try the steps here:

stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012

http://technet.microsoft.com/en-us/library/ms165647(v=sql.90).aspx

HTH.
0
 
Dan CarpIT DirectorAuthor Commented:
Thanks valli_an - I actually had tried the solution in the first link.  What ended up solving it (that I'd missed earlier) was a comment further down in the thread about how to properly specify a server name.  I wasn't specifying the port, so I needed to use (any of) the following formats:

SERVER,1433
SERVER/SQLEXPRESS,1433
172.16.1.x,1433

The SQL server still isn't being broadcast, but I simply need to access it (and am probably better off it not being broadcasted).  I presume that's what the SQL Server Browser service does?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now