SQL Server 2008 连接错误“管道的另一端没有进程" [英] SQL Server 2008 Connection Error "No process is on the other end of the pipe"

问题描述

首先让我说，我知道 this thread 以及网络上其他寻求解决此问题的人.

Let me begin by saying, I am aware of this thread and others around the web that seek to trouble shoot this issue.

此处发布的解决方案不适用于我的问题.在决定提出这个问题之前，我已经花了 5 个小时试图解决这个问题.

The solutions posted there do not apply to my issue. I have spent 5 hours trying to resolve this before deciding to ask the question.

问题:当我尝试使用 SQL 身份验证登录 SSMS(或从 Java 应用程序连接)时，出现此错误:

The problem: When I attempt to log into SSMS (or connect from a java application) using SQL Authentication I get this error:

已成功与服务器建立连接，但随后出现登录过程中发生错误.(提供者:共享内存提供程序，错误:0 - 管道的另一端没有进程.)(Microsoft SQL Server，错误:233)

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

虽然它确实有效，但我不能选择使用集成身份验证.我尝试连接的数据库与我的 SSMS 实例在同一台机器上.没有网络，这是一个独立的系统.

Although it does work, it is not an option for me to use integreated authentication. The database I am attempting to connect to is on the same machine as my SSMS instance. There is no network, this is a stand-alone system.

NAMED PIPES is ENABLED 在我的配置中，我已经重新启动，因为 TCP IP 在我的配置中比命名管道具有更高的优先级.

NAMED PIPES is ENABLED in my configuration, I HAVE rebooted since, TCP IP is a higher priority than named pipes in my configuration.

我什至卸载 SQL Server 并重新安装它，但无济于事.

I have even gone as far as to uninstall SQL Server and reinstall it, to no avail.

我的 SQL Server 实例的详细信息如下:

The details of my SQL Server instance are as follows:

Microsoft SQL Server Management Studio - 10.0.2531.0
Microsoft Analysis Services Client Tools - 10.0.1600.22
Microsoft Data Access Components (MDAC)  - 6.1.7601.17514
Microsoft MSXML - 3.0 5.0 6.0 
Microsoft Internet Explorer - 9.0.8112.16421
Microsoft .NET Framework - 2.0.50727.5466
Operating System     - 6.1.7601

配置详情如下:http://i45.tinypic.com/vxdz7c.pnghttp://i45.tinypic.com/vxdz7c.jpg

我使用此代码从 java 连接.

I connect from java using this code.

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String connectionUrl = "jdbc:sqlserver://localhost;database=AdventureWorks;integratedSecurity=false;User=JIMBO; Password=JIMBO;";
Connection con = DriverManager.getConnection(connectionUrl);

但请记住，当我尝试直接登录 SSMS 时也会出现此错误.提前致谢.

But please remember, this error also occurs when I atttempt to log in to SSMS directly. Thanks in advance.

-吉姆

推荐答案

要强制使用 TCP/IP，将连接字符串中的 localhost 替换为 127.0.0.1.

To force TCP/IP being used replace localhost with 127.0.0.1 in your connection string.

当您使用用户名和密码时，请确保启用 SQL 身份验证.默认情况下，sqlserver 2008 上仅启用 Windows 集成.

As you are using a username and password make sure SQL authentication is enabled. By default only Windows integrated is enabled on sqlserver 2008.

对于 SqlServer 身份验证，请记住密码策略到位以加强安全性.

With SqlServer authentication keep in mind that a password policy is in place to enforce security.

这篇关于SQL Server 2008 连接错误“管道的另一端没有进程"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！