Solved

How to Make SQLEXPRESS 2012 Instance Visible

Posted on 2013-10-30
2
388 Views
Last Modified: 2013-10-30
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
Comment
Question by:pcamis
2 Comments
 
LVL 9

Accepted Solution

by:
Valliappan AN earned 500 total points
ID: 39612110
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
 

Author Closing Comment

by:pcamis
ID: 39612310
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now