制作新的Admin用户并进入SQL Express 2005-CSDN博客

This was helpful today. I had a machine with the Aug CTP of SQL Express 2005 but I can't remember if I included an sa? I don't even remember if there was one. I think that it was a silent install and there's a strong password created for it then it's disabled, so I need to fix that. Anyway, I needed to enable mixed mode for my samples' existing connection strings to work, and I haven't got any SQL Client Tools lying around, I was on a VM.

今天这很有帮助。我有一台装有SQL Express 2005年8月CTP的计算机，但我不记得是否包含sa吗？我什至不记得是否有一个。我认为这是一个无提示安装，并且为此创建了一个强密码，然后将其禁用，因此我需要修复此问题。无论如何，我需要启用混合模式才能使示例的现有连接字符串正常工作，并且我没有使用任何SQL Client Tools，因为我在VM上。

I enabled mixed mode in the registry by chaning this key:

我通过更改以下键在注册表中启用了混合模式：

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer - LoginMode =2

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server \ MSSQL.1 \ MSSQLServer-LoginMode = 2

Then I made a new user for my purposes

然后我为自己的目的创建了一个新用户

C:>SQLCMD -S.\SQLEXPRESS -E
sp_addLogin 'usernamepoo', 'passpoop'
GO
sp_addsrvrolemember 'usernamepoo', 'sysadmin'
GO

C：> SQLCMD -S。\ SQLEXPRESS -E sp_addLogin'usernamepoo'，'passpoop' 走sp_addsrvrolemember'usernamepoo'，'sysadmin' 走

Back in business...seems to me that simply shipping a decide admin tool would obviate the need for this nonsense. Sure there's one to download, but it still seems like duplication of effort. And, for the CTPs, the current version of the Express Manager is June, which is less helpful for me in August.

回到企业中……在我看来，仅交付决定管理工具就可以避免这种废话。当然，这里有一个可供下载，但似乎仍然有些重复。而且，对于CTP，Express Manager的当前版本是6月，这对8月的我而言没有太大帮助。

Now playing: Counting Crows - Mrs. Potters Lullaby

现在播放：乌鸦盘点-陶艺家Gradle曲夫人

翻译自: https://www.hanselman.com/blog/making-a-new-admin-user-and-getting-into-sql-express-2005