sql server 无法启动 10013错误 7024事件以一种访问权限不允许的方式做了一个访问套接字的尝试

最新推荐文章于 2024-07-26 09:40:31 发布

无知懵懂

最新推荐文章于 2024-07-26 09:40:31 发布

阅读量3.9k

点赞数 2

分类专栏： sqlserver日常err 文章标签： sqlserver 数据库 sql

本文链接：https://blog.csdn.net/qq_23082219/article/details/125576935

版权

sqlserver日常err 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

问题描述

sql server 无法启动 10013错误

系统日志里面的事件是 7024

SQL Server (MSSQLSERVER) 服务由于下列服务特定错误而终止:
以一种访问权限不允许的方式做了一个访问套接字的尝试。

sqlserver里面报错就是端口给占用

2022-07-02 19:36:36.00 spid21s Error: 26023, Severity: 16, State: 1.
2022-07-02 19:36:36.00 spid21s Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use.
2022-07-02 19:36:36.00 spid21s Error: 17182, Severity: 16, State: 1.
2022-07-02 19:36:36.00 spid21s TDSSNIClient initialization failed with error 0x271d, status code 0xa. Reason: Unable to initialize the TCP/IP listener. An attempt was made to access a socket in a way forbidden by its access permissions.
2022-07-02 19:36:36.00 spid21s Error: 17182, Severity: 16, State: 1.
2022-07-02 19:36:36.00 spid21s TDSSNIClient initialization failed with error 0x271d, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. An attempt was made to access a socket in a way forbidden by its access permissions.
2022-07-02 19:36:36.00 spid21s Server is listening on [ ::1 27697].
2022-07-02 19:36:36.00 spid21s Server is listening on [ 127.0.0.1 27697].
2022-07-02 19:36:36.01 spid21s Server local connection provider is ready to accept connection on [ \.\pipe\sqlsatellitelaunch ].
2022-07-02 19:36:36.01 spid21s Resource governor reconfiguration encountered an issue (HRESULT code : 0x80040002, reason: Construction of Launchpad Connection failed), while sending active external resource pool ids to launchpad. This will not fail reconfigure.
2022-07-02 19:36:36.01 spid21s Error: 17826, Severity: 18, State: 3.
2022-07-02 19:36:36.01 spid21s Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2022-07-02 19:36:36.01 spid21s Error: 17120, Severity: 16, State: 1.
2022-07-02 19:36:36.01 spid21s SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the operating system error log for information about possible related problems.