管道的另一端没有进程 (SQL Server 2012) [英] No process is on the other end of the pipe (SQL Server 2012)
问题描述
我遇到了这个错误:
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)
我知道,这个网站上也有类似的问题,答案是,启用TCP/IP和管道.但是我都启用了,还是不行:
我使用的是 Microsoft SQL Server 2012 并且用户拥有完全权限.
I am using Microsoft SQL Server 2012 and the user has full permissions.
推荐答案
默认情况下,服务器仅设置为 Windows 身份验证.没有任何通知,错误的来源是那个,所以很难弄清楚.SQL 管理工作室不会发出警报,即使您创建的用户仅使用 SQL 身份验证.
The server was set to Windows Authentication only by default. There isn't any notification, that the origin of the errors is that, so it's hard to figure it out. The SQL Management studio dont alert, even if you create a user with SQL Authentication only.
所以答案是:从 Windows 切换到 SQL 身份验证:
- 右键单击服务器名称并选择
properties
; - 选择
security
标签; - 启用
SQL Server 和Windows 身份验证模式
; - 重新启动 SQL Server 服务.
您现在可以使用您的登录名/密码进行连接.
You can now connect with your login/password.
以下是 Microsoft 的说明:https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode?view=sql-server-ver15
Here are the directions by Microsoft: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode?view=sql-server-ver15
这篇关于管道的另一端没有进程 (SQL Server 2012)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!