更改计算机名后无法登录SQL Server [英] Can't log into SQL server after changing computer name

问题描述

我安装了 Windows Server 2008 和 SQL Server 2008 R2，加入域后我更改了计算机名称，错误地从 SQL Server 登录用户中删除了管理员组，现在我无法登录.

I installed Windows Server 2008 and SQL Server 2008 R2, after joining to domain I changed computer name and mistakenly I deleted the administrators group from SQL Server login users and now I am not able to login.

有什么建议吗?

推荐答案

按照本文中的步骤操作:http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/

Follow the steps in this article: http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/

基本上，您必须修改 SQL Server 服务设置，以便它以管理员模式启动.这将只允许一个连接到它.启动后，您可以创建一个新的 sysadmin 用户，此后您可以使用该用户.

Basically you have to modify the SQL Server Service settings so that it starts in admin mode. This will only allow one connection to it. Once you start it up you can create a new sysadmin user that you can use from then on.

我也知道，如果您更改服务器的主机名，您需要在 SQL Server 上运行某些脚本.如果你用谷歌搜索它们，你应该能找到它们.

Also I do know that you need to run certain scripts on a SQL Server if you change the hostname of the server. You should find them if you google them.

这篇关于更改计算机名后无法登录SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！