tags:

views:

25

answers:

1
Q: 

SQL Server Management Studio connection issue

Hello everyone,

I am using SQL Server 2008 Enterprise on Windows Server 2008 Enterprise. The server runs SQL Server 2008 is machine M1. I have tried using SQL Server Management Studio on machine M2 could be connected to M1. But I can not use another machine M3 to connect to M1. Any ideas what is wrong? I am not sure whether it is the issue at M1 side or M3 side? Any check list?

Error message is, provider: named pipeline provider program, error 40 -- can not open connection to SQL Server (Microsoft SQL Server: error 53).

thanks in advance, George

+1  A: 

On M1 you need to enable TCP/IP in SQL Server Configuration Manager, under "Protocols for MSSQLSERVER". In addition to this you need to open at least port 1433 in the Windows Firewall

Vidar Nordnes  2010-07-27 09:16:56
If they are not enabled, how could M2 be able to connect to M1?
George2  2010-07-27 09:22:28
Could you describe more about your network, the difference between M2 and M3
Vidar Nordnes  2010-07-27 09:34:29
1. M2 and M1 are in server room, and M3 are outside server room. I think there should be some restrictions between connection from server room and non-server room. Could it be the root cause? 2. Besides enable TCP/IP, open firewall 1433 at M1, do you think anything else setting on M1 which may impact?
George2  2010-07-27 09:40:32
I think that's it. Check this article out: http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/If this doesn't solve your issues, you should look at the connection between your server room and non-server room.Btw, you can force a TCP connection with "tcp:" at the start of your server
Vidar Nordnes  2010-07-27 09:48:14
Thanks, question answered!
George2  2010-07-29 14:45:28

related questions

In SQL Server 2008 how can I secure data in a way that it cannot be decrypted unless connected to a network?
Advantages of MS SQL Server 2008 over MS SQL Server 2005?
SqlDataReader.HasRows returns false since SQL 2008 upgrade
How do I set the login info for SQL Server 2008 in Entity Framework?
Move SSIS Packages from SQL Server 2005 to 2008.
Installation problem sql server 2008
How do I register a Web Reference for a SQL Server 2008 Reporting Service Report?
How to use DataMining feature of SQL Server 2008 with ASP.Net
SSAS Cube Browsing not working after SQL 2008 CTP uninstall
Hooking up Reporting Services 2005SP2 to SQL Server 2008
New Date/Time data types in SQL 2008
Can SQLExpress 2005 and 2008 be installed on same machine without issue?
Any reason to have SQL Server 2005 and 2008 installed on same machine?
Cloud Hosting options for ASP.NET 3.5 and SQL Server 2008
How do I get the full name of the current user from a SQL Reporting Services 2008 report?
How do I fix a Cross language installation problem in SQL Server 2008?
Upgrade MSDE to SQL Server 2008
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
SQL Server 2008 Reporting Services Report Definition Customization Extensions
Moving SQL2005 app to SQL2008
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Can I use SQL Server Management Studio 2005 for 2008 DB?
SQL 2008 Dialect Support for NHibernate
SQL Server 2008 vs 2005 Linq integration
SQL Server 2005 and 2008 on same developer machine?