SQL Server 2005 login with Windows Authentication

Hi all,

I am not very familiar with SQL Server security so bear with me for my basic
question.

I just installed on my laptop at home SQL Server 2005 and I chose Windows
authentication as authentication mode during the installation process. My
computer is running Windows XP PRO.

My Computer name is D620 and my windows user name is Francois (who has admin
rights, beign part of the Administrator group). As it's a stand alone
computer at home, I don't have any domain so it's a local user (not a domain
user).

I obviously installed SQL Server using my Francois (admin) local user
account. So having stated that I chose windows authentication as
authentication mode i was expecting to see something like D620\Francois in
the available logins of my SQL Server instance.
Instead, I see:
- BULTIN\Administrators (What is it? And why is it not D620\Administrators,
which would then be the windows user group)
- D620\SQLServer2005MSFTEUser$D620$MSSQLSERVER (windows local user group
created by SQL Server)
- D620\SQLServer2005MSSQLUser$D620$MSSQLSERVER (windows local user group
created by SQL Server)
- D620\SQLServer2005MSSQLAgentUser$D620$MSSQLSERVER (windows local user
group created by SQL Server)
- NT AUTHORITY\SYSTEM (who is that fellow?)
- sa (who is disabled, which i understand as i did not chose mixed
authentication mode)

So can anyone explain me why there is not any D620\Francois login? And I can
open SQL Server Managemetn Studio and connect to my DB with D620\Francois.
How can I know if D620\Francois got admin rights and if he is dbo of all db?
And how can I change his rights if i don't see the login in the Management
studio?

Maybe also someone can point me out some great material which can explain
SQL security and logins properly?

Thanks a lot in advance,

Francois Malgreve.





.

Relevant Pages

  • [NT] SQL Server Installation Process May Leave Passwords on System
    ... service pack for SQL Server 7.0 or SQL Server 2000, ... without having to actually perform an installation. ... to SQL Server 7.0 Service Pack 4, the passwords were stored in clear text. ... information in the setup.iss and log files would not allow any access. ...
    (Securiteam)
  • Re: How to install 32-bit Reporting Services on 64-bit Windows
    ... Start SQL Server 2008 Installation Center ... existing installation" and install only Reporting Services ... I have 64-bit Windows because of Analysis Services. ...
    (microsoft.public.sqlserver.setup)
  • RE: SOLUTION: Security Update for SQL Server 2005 Service Pack
    ... successfully, and then after windows updates, asks me to reinstall again. ... Description" under the "Product Installation Status." ... "SQL Server Database Services 2005." ... So I just went to Program Files and decompressed my Microsoft SQL Server ...
    (microsoft.public.windowsupdate)
  • Re: MSDE Failed to install
    ... Cannot access the Windows Management Instrumentation software. ... Manually Remove a Microsoft SQL Server 2000 Desktop Engine ... Performing the installation in the Clean Boot mode ...
    (microsoft.public.sqlserver.setup)
  • RE: Error Code: 1073807364 sql server 2005
    ... contain the files that are required during the installation of SQL Server ... In the D:\SQLServer2005 folder, ... Setup.exe to start the SQL Server 2005 Setup program. ...
    (microsoft.public.windows.server.sbs)