Re: Logins created by default

From: Peter (Peter_at_discussions.microsoft.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 11:37:04 -0800

Hi Kevin,

I'm trying to find out the following:

1. Whether that Windows User login(the one installed the SQL Server) is
always created automatically during installing a SQL Server using Windows
Authentication or not.

Based on my testing in installing SQL Server with Windows Authentication
when I logged onto the domain, the following logins are created automatically:

sa
BUILTIN\Administrators
domain\user - the Windows User who logged onto the domain

2. Can a user who has local administrative permissions log on to the
operating system locally (so he/she is not logged onto the domain) and
install a SQL Server using Windows Authentication? If yes, since the user
only logs on locally, I guess that only sa and BUILTIN\Administrators logins
are created automatically. Am I right?

So, basically I want to know what logins are created automatically in
installing a SQL Server using Windows Authentication when:

1. the user is logged on locally
2. the user is logged onto the domain

Thanks.

"Kevin McDonnell [MSFT]" wrote:

> Not unless that user is a member of the local Administrators Group.
> So, any local admin has Windows Auth access to the server by default. It
> doesn't matter who ran setup per se.
> Local admin privleges are required to install services.
>
> Thanks,
>
> Kevin McDonnell
> Microsoft Corporation
>
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
>
>

Relevant Pages

  • Re: Windows security
    ... sp_change_users_password only works with SQL Server ... Authentication, not Windows Authentication. ... > Windows NT environment but still have entries in the Microsoft SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Very basic login question
    ... Both computers are NOT members of a domain. ... In order to use Windows Authentication the two computers have to be ... you should have a login at the SQL Server on the XP Pro ...
    (microsoft.public.sqlserver.security)
  • RE: Error Message When Setup MS SQL Server Developer Edition
    ... I my case it was caused by a problem with MDAC. ... Try downloading and installing the latest ... as you no doubt know running Windows XP without any service pack is not ... My Experience is that the SQL Server developer edition ...
    (microsoft.public.sqlserver.setup)
  • Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?
    ... connecting using a Windows account or using a SQL Server account? ... For Windows authentication, SQL Server need to enumerate the SIDs for the account you pass with Windows. ...
    (microsoft.public.sqlserver.clients)
  • Re: Trouble connecting to SQL Server express over Peer to Peer network
    ... I have a program that accesses an SQL Server Express database. ... Configuration and I connect using Windows Authentication. ... that have never been connected to the domain, I have an issue connecting. ...
    (microsoft.public.vb.general.discussion)