sql-server - 在任务管理器中误杀了sqlserver.exe进程,如何重启?

我在任务管理器 > 进程 >(按所有用户显示进程)> sqlserver.exe

中错误地杀死了 sqlserver.exe 进程

现在我的数据库没有连接,Management Studio 和所有应用程序都显示此错误

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. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

即使在配置管理器中,服务也没有显示。请帮忙,因为我需要访问它。这种情况下的数据非常重要..

最佳答案

您可以通过以下方式做到这一点:

To start the default instance of SQL Server

On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.

In SQL Server Configuration Manager, in the left pane, click SQL Server Services.

In the details pane, right-click SQL Server (MSSQLServer), and then click Start. A green arrow on the icon next to the server name and on the toolbar indicates that the server started successfully.

Click OK to close SQL Server Configuration Manager.

To start a named instance of SQL Server

On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.

In SQL Server Configuration Manager, in the left pane, click SQL Server.

In the details pane, right-click the named instance of SQL Server, and then click Start. A green arrow on the icon next to the server name and on the toolbar indicates that the server started successfully.

Click OK to close SQL Server Configuration Manager.

或者您可以重启服务器,假设您已将服务设置为自动启动。

或者您可以进入服务 View 类型服务并右键单击 SQLServer 服务并点击重新启动

More information here

https://stackoverflow.com/questions/29857513/

相关文章:

ruby - 我在哪里可以看到我的浏览器发送的 http 请求

python - 列出目录中的所有文件 - 按大小过滤

asp.net-mvc - 如何在 web.config 中设置密码和用户名

java - String.split() 如果在字符串的最后部分,则忽略定界符之间的空值

macos - 将 MAC 上远程桌面中的下移控制向下箭头发送到 Windows PC

sql - 使用当前连接从 sql 存储过程调用 dll 函数

bash - ANSI 转义在 `printf` 中不起作用

sql - 如何在外键约束中使用两列

PHP - 如何获取 n 深多维数组的所有数组值?

python - 类型错误 : key is not