Solved

SQL Express 2005 on SBS 2011 Not Accessible over Network

Posted on 2011-09-25
7
1,525 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

706 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

17 Experts available now in Live!

Get 1:1 Help Now