Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1556
  • Last Modified:

SQL Express 2005 on SBS 2011 Not Accessible over Network

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
snooflehammer
Asked:
snooflehammer
  • 3
  • 3
1 Solution
 
mbkitmgrCommented:
Does the app use the ODBC to call SQL.  If so try using named pipes instead
0
 
snooflehammerAuthor Commented:
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
 
ckivmlCommented:
0
Industry Leaders: 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!

 
snooflehammerAuthor Commented:
bad link
0
 
snooflehammerAuthor Commented:
Thanks, that's some good stuff to work with. Back on it tomorrow
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now