Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL 2008 R2 instances will only connect with named pipes not TCP/IP

Posted on 2012-03-18
5
Medium Priority
?
577 Views
Last Modified: 2012-03-28
I have a new installation of SQL 20082 running on SBS 2011 premium. 2 installed applications will not connect via TCP/IP we need to create an OBDC data connector with named pipes.  These applications connected in the old SQL server.  DNS seems to work OK.  This box is SBS 2011 Premium and SQL is installed on that servernot a second server.  

Note: this may be a licesing problem.  When I look at the properties on my computer is lists this as Windows SBS 2011 standard not Premium.  I have a primium license key not I am not sure where to enter it.
0
Comment
Question by:BlueGlory
[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
  • 4
5 Comments
 
LVL 59

Accepted Solution

by:
Cliff Galiher earned 1500 total points
ID: 37735432
It isn't a censing issue, and note that there is notice thing as SBS 2011 Premium edition. There is a premium add-on, but as the name implies, it "adds on" to standard edition, so when you check the version, SBS will Report standard edition (to differentiate it from SBS essentials) but never premium.

Your problem mayy be one of two things:

1) you have not set up the appropriate exceptions in windows firewall. the premium add-on comes with a second windows server license for a reason. SQL server chooses a RANDOM port to listen in on (but can be forced if necessary) and the SQL helper service helps clients locate the proper port for an instance. A domain controller, conversely, should not be listening in random ports as this is a significant security risk. As such, the firewall policies of a default DC install are directly interfering with how SQL operates. You can define exceptions (usually through group policy) but know that doing so adds SIGNIFICANT risk to your server. Which brings me full circle to the PAO including a second server license for a reason. You REALLY SHOIOD run any network SQL app on the second server, I can't stress this enough.

2) less common, but still possible, is if you didn't enable TCP/IP via the SQL server management. You must choose the instance, enable TCP/IP, and bind it to an interface (it defaults to localhost) or it won't be listening on an interface that the client can reach. You can check to see if it is working and listening with netstat and other process monitoring tools such as those I the sysinternals toolkit.

-Cliff
0
 

Author Comment

by:BlueGlory
ID: 37735993
We are considering getting a second server for SQL but until then I need to get this going. I you give me more insight on how to configure the group policy for random port exceptions.
0
 

Author Comment

by:BlueGlory
ID: 37778827
We installed the second instance successfully
0
 

Author Comment

by:BlueGlory
ID: 37778833
non
0
 

Author Comment

by:BlueGlory
ID: 37778844
We successfully installed a second instance
0

Featured Post

Technology Partners: We Want Your Opinion!

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!

Question has a verified solution.

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

The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

618 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