Scott Hanselman

Making a new Admin User and Getting into SQL Express 2005

September 13, '05 Comments [0] Posted in Programming | Tools
Sponsored By

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.

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

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

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.

Now playing: Counting Crows - Mrs. Potters Lullaby

About Scott

Scott Hanselman is a former professor, former Chief Architect in finance, now speaker, consultant, father, diabetic, and Microsoft employee. He is a failed stand-up comic, a cornrower, and a book author.

facebook twitter subscribe
About   Newsletter
Sponsored By
Hosting By
Dedicated Windows Server Hosting by SherWeb
Comments are closed.

Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.