SQL Server 2012 - 恢复主Db的单模式用户 [英] SQL Server 2012 - Single Mode User to Restore Master Db
问题描述
我已关闭除MSSQLSERVER之外的所有SQL Server服务,并已通过配置窗口中的-m开关将该服务设置为以单用户模式启动。
但是,当我尝试使用sa登录时帐户]弹出一个对话框,告诉我该服务处于单用户模式,只有一个管理员可以登录。
我是唯一的管理员,因为服务器(开发人员版)在我的电脑上。
有没有人遇到这个问题并解决了吗?
我按照Wrox专业Microsoft一书中的说明进行操作SQL Server 2012管理 - Jorgensen&其他"为了在将PC升级到Windows 8 Pro后恢复Master Db的备份。
I''ve closed all SQL Server service except the MSSQLSERVER, and have set that service to startup in single user mode by using the -m switch in the Configuration Window.
However, when I tried to login using the "sa" account" a dialog box popped up telling me that the service was in single user mode and only one Administrator could login.
I am the only Administrator as the server (Developer edition)is on my PC.
Has anyone come across this and resolved it, please?
I was following the instructions given in the Wrox book "Professional Microsoft SQL Server 2012 Administration - Jorgensen & Others" in order to restore a backup of the Master Db after upgrading the PC to Windows 8 Pro.
推荐答案
在运行时没有其他任何连接到服务的内容这个?没有查询会话?什么都没有?
And you have nothing else connecting to the service at the time you ran this? No querying session? Nothing?
我甚至无法登录来运行查询。
我停止了所有其他SQL服务。
我是唯一使用SQL Server的人。
I can''t even login to run a query.
I stopped all the other SQL services.
I''m the only one using the SQL Server.
我以为你知道你的意思。问题的措辞方式,即使你现在只有24个帖子(尽管你几乎和我一样是一个成员),但在发布之前你会想到。
我很害怕我和米克一样困惑。我希望你可能忽略了一些显而易见的事情(正如很多人所做的那样),但我总是害怕它。让我们希望有人之前遇到过你的情况,可以帮助你。
I thought you knew what you were about. The way the question was worded and you only having 24 posts even now (even though you''ve been a member almost as long as I have), shows you think before posting.
I''m afraid I''m as confused as you are Mick. I was hoping you may have overlooked something obvious (as so many people do), but it was always a long-shot i''m afraid. Let''s hope someone has come across your situation before and can help you further.
这篇关于SQL Server 2012 - 恢复主Db的单模式用户的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!