SqlServer连接问题从本地机器到服务器 [英] SqlServer connecting problem from local machine to Server

问题描述

大家好！



我已经在我的本地机器和服务器上安装了SqlServer 2005.



当我登录服务器并打开SQL服务器时，它会完全打开。我也可以在本地机器上打开sqlserver。



但问题是.....



我想从我的本地机器连接到SqlServer到SERVER（服务器是Windows Server 2003）



这是它显示的错误。



建立与SqlServer的连接时发生与网络相关的特定于实例的错误。

未找到服务器或无法访问服务器。验证实例名称是否正确，以及是否将SQL Server配置为允许远程连接。

（提供者：命名管道提供程序，错误：40无法打开连接到SQL Server）

（Microsoft SQL Server，错误：121）



请帮帮我。



谢谢......

hi everyone !

I have installed SqlServer 2005 in my local machine as well as in server.

When i login in server & open SQL server it opens perfectly. and also i can open sqlserver in my local machine locally.

BUT THE PROBLEM IS .....

I want to connect to SqlServer from my local machine to SERVER (Server is windows server 2003)

This is ERROR it shows.

A Network-relatedor instance-specific error occured while establishing a connection to SqlServer.
The Server was not found or was not accessible. verify that the instance name is correct and
that SQL Server is configured to allow remote connections.
(provider:Named Pipes Provider, error:40 could not open a connection to the SQL Server)
(Microsoft SQL Server, Error:121)

Please can you help me.

Thank you...

推荐答案

你知道吗， Google [ ^ ]帮助。

You know, Google[^] helps.

看到这个.. :)



转到\Start Menu \Programs\Microsoft SQL Server 2008 \Configuration Tools，启动SQL Server配置管理器并启用所需的连接协议。



或



SQL SERVER - FIX ：错误:(提供程序：命名管道提供程序，错误：40 - 无法打开与SQL Server的连接）（Microsoft SQL Server，错误:) [ ^ ]



在建立与服务器的连接时出现错误40.连接到SQL Server 2005时。连接到SQL Server 2005时，这种失败可能是由于在默认设置下SQL Server没有允许远程连接。 [ ^ ]



解析无法打开与SQL Server错误的连接 [ ^ ]



命名管道提供程序，错误：40 - 无法打开与SQL Server的连接 [ ^ ]



网络 - 在建立与SQL SERVER的连接时发生的相关或实例特定的错误。服务器未找到或无法访问。验证实例名称是否正确并且SQL服务器配置为允许远程连接。 （P [ ^ ]

see this.. :)

Go to \Start Menu\Programs\Microsoft SQL Server 2008\Configuration Tools, launch SQL Server Configuration Manager and enable the connection protocols you need.

or

SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )[^]

Error 40 has occurred while establishing a connection to the server.When connecting to SQL Server 2005. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.[^]

Resolving could not open a connection to SQL Server errors[^]

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server[^]

A NETWORK-RELATED OR INSTANCE-SPECIFIC ERROR OCCURRED WHILE ESTABLISHING A CONNECTION TO SQL SERVER. THE SERVER WAS NOT FOUND OR WAS NOT ACCESSIBLE. VERIFY THAT THE INSTANCE NAME IS CORRECT AND THAT SQL SERVER IS CONFIGURED TO ALLOW REMOTE CONNECTIONS. (P[^]

这篇关于SqlServer连接问题从本地机器到服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！