Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1560
  • 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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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