Re: Adding Windows Admin to sa role after setup (MSSQL 2008)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxxxxx> wrote in message
news:%233oo39QQKHA.1232@xxxxxxxxxxxxxxxxxxxxxxx
BTW, it's one of those cases where the person who did the original install
did not select mixed authentication mode.

Alain Quesnel
alainsanspam@xxxxxxxxxxxx



"Alain Quesnel" <alainsansspam@xxxxxxxxxxxx> a écrit dans le message de
news: Ot3uEkQQKHA.4244@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxx





.

Relevant Pages

  • Re: Adding Windows Admin to sa role after setup (MSSQL 2008)
    ... Re-starting the MSSQL service with the -m parameter did ... Alain Quesnel ... You can add domain logins, local logins, or the whole local administrators ...
    (microsoft.public.sqlserver.setup)
  • Re: Is there an alternative to disabling windows authentication?
    ... Remove domain accounts from the Local Administrators. ... SQL Server, or installs an eval version of SQL Server and client tools ... so I want to protect my database by only allowing SQL Server ... The only logins are sa and several default ...
    (microsoft.public.sqlserver.security)
  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • RE: OpenDataSource "Unspecified Error" when connecting to local Excel
    ... Are there any another hidden permissions required for the OpenDataSource ... the file is on the local Sql Server. ... > Even if I add domain users to the server administrator role, ... > local administrators group on the Sql Server? ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)