We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Solved
How to Make SQLEXPRESS 2012 Instance Visible
Posted on 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:
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!
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!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Did you try the steps here:
stackoverflow.com/question
http://technet.microsoft.com/en-us/library/ms165647(v=sql.90).aspx
HTH.
stackoverflow.com/question
http://technet.microsoft.com/en-us/library/ms165647(v=sql.90).aspx
HTH.
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?
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?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Background Information
Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008.
Determine the location of the FSMO roles by lo…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…
Suggested Courses
Course of the Month8 days, 21 hours left to enroll
604 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.