233: A connection was successfully established with the server, but then an error occurred (no process is on the other end of the pipe)(已成功与服务器建立连接,但随后发生错误(管道的另一端上无任何进程))
SQL Server含义
客户端已到达服务器,但连接在握手期间断开。通常由 Named Pipes/TCP 配置、协议设置或服务器端拒绝引起。与 10054(连接被强制关闭)相关。
原因
Shared Memory/Named Pipes/TCP 协议被禁用、不允许远程连接、账户无法登录(参见 18456)、防火墙/网络中断,或服务器强制关闭了连接(10054)。
解决方法
在 SQL Server Configuration Manager 中启用 TCP/IP,必要时启用 Named Pipes,然后重启服务。确认允许远程连接。在防火墙中开放 SQL 端口(默认 1433)。对于认证问题,检查错误日志中 18456 的 State 代码。检查网络稳定性和 TLS/加密设置。
同一数据库的其他条目
- 208Invalid object name(对象名无效)
- 229The SELECT/EXECUTE permission was denied on the object(拒绝了对对象的 SELECT/EXECUTE 权限)
- 4060Cannot open database requested by the login. The login failed(无法打开登录所请求的数据库。登录失败)
- 823The operating system returned error to SQL Server during a read/write at offset in file (I/O error)(操作系统在文件的偏移量处读/写时向 SQL Server 返回了错误(I/O 错误))
- 824SQL Server detected a logical consistency-based I/O error (page corruption)(SQL Server 检测到基于逻辑一致性的 I/O 错误(页损坏))
- 701There is insufficient system memory in resource pool to run this query(资源池中的系统内存不足,无法运行此查询)
- 845Time-out occurred while waiting for buffer latch(等待缓冲区闩锁时超时)