Is it possible to add a machine's local admin to the sa role after the MSSQL
2008 setup has completed?

Thank you,

Alain Quesnel
alainsanspam (AT) logiquel (DOT) com

BTW, it's one of those cases where the person who did the original install
did not select mixed authentication mode.

Alain Quesnel
alainsanspam (AT) logiquel (DOT) com



"Alain Quesnel" <alainsansspam (AT) logiquel (DOT) com> a écrit dans le message de
news: Ot3uEkQQKHA.4244 (AT) TK2MSFTNGP06 (DOT) phx.gbl...

Yes. Use SQL Server Management Studio, connect to the Database Engine, and
add the login.
You can add domain logins, local logins, or the whole local administrators
group (BUILTIN\Administrators).
If the operating system in Windows Vista or Windows Server 2008, adding the
local administrators group is not a good choice as the OS doesn't pass your
admin credentials automatically.
If you are the admin, and you can't connect, see Troubleshooting: Connecting
to SQL Server When System Administrators Are Locked Out
http://msdn.microsoft.com/en-us/library/dd207004.aspx
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Alain Quesnel" <alainsansspam (AT) logiquel (DOT) com> wrote

Thanks for the link. Re-starting the MSSQL service with the -m parameter did
the trick.

Alain Quesnel
alainsansspam (AT) logiquel (DOT) com


"Rick Byham, MSFT" <rickbyh (AT) microsoft (DOT) com> a écrit dans le message de news:
OohKiLRQKHA.764 (AT) TK2MSFTNGP02 (DOT) phx.gbl...