Solved

SQL Express 2005 on SBS 2011 Not Accessible over Network

Posted on 2011-09-25
7
1,531 Views
Last Modified: 2013-12-02
SQL app on SBS 2011 running off SQL Express 2005. Locally the app works fine, but network clients cannot connect. The client SQL app cannot see the SQL Express instance advertising its services over the network.

No firewall running on the client PCs.

AFAIK you cannot disable the SBS 2011 firewall without blocking all network traffic. I tried to bypass it by putting in a rule to pass all ports through the SBS 2011 firewall to no avail.

Any suggestions please?
0
Comment
Question by:snooflehammer
  • 3
  • 3
7 Comments
 
LVL 5

Expert Comment

by:mbkitmgr
ID: 36597348
Does the app use the ODBC to call SQL.  If so try using named pipes instead
0
 

Author Comment

by:snooflehammer
ID: 36597353
It uses named pipes already. I think there's a clash between the bundled SQL2008 withSBS 2011, but I don't know what to do to test it.
0
 
LVL 6

Expert Comment

by:ckivml
ID: 36597390
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:snooflehammer
ID: 36597392
bad link
0
 
LVL 6

Accepted Solution

by:
ckivml earned 500 total points
ID: 36597393
0
 
LVL 6

Expert Comment

by:ckivml
ID: 36597395
0
 

Author Comment

by:snooflehammer
ID: 36597404
Thanks, that's some good stuff to work with. Back on it tomorrow
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

13 Experts available now in Live!

Get 1:1 Help Now