Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have installed (3 times on 3 machines) sql server 2008 r2 can connect with connection manager but other program cannot connect. I can connect to remote sql servers with heidisql or with my dbcontroles in visal studio or embarcadero delphi xe2. But non of those can connect to te sql server whlie the connection-manager can. What settings may be involved? -My firewall is open for SQL server. -I use the same port numer everywhere

Any suggestions?

share|improve this question
Are you connecting to a default instance, or a named instance? – JohnThePro Apr 26 '12 at 14:15

I don't know what connection manager is, but I'm assuming you mean SQL Server Management Studio. If I'm not mistaken, SQL Server since SQL Server 2005 installs with only the Shared Memory protocol enabled and all network protocols disabled. You're able to connect via SSMS on the server to the SQL Server database engine instance on the server because it's connecting via Shared Memory protocol. In order to connect to it from another host on the network you'll need to enable the appropriate network protocol; Named Pipes or TCP/IP, whichever suits your need.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.