Solved

SQL Express 2005 on SBS 2011 Not Accessible over Network

Posted on 2011-09-25
7
1,538 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

830 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