Making a new Admin User and Getting into SQL Express 2005
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.
About Newsletter
Comments are closed.