Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,515 of 19,505    |
|    Erland Sommarskog to Tony    |
|    Re: about Windows authentication    |
|    23 Nov 11 11:31:09    |
      From: esquel@sommarskog.se              Tony (johansson.andersson@telia.com) writes:       > Now to my question When was these two accounts created because I have       > not added these two ? I assume that these two was automatically added       > when I installed SQL Server ? Is that correct understood ?              When you ran the Setup wizard, you were prompted to add a user to be       sysadmin, and there was a button Add Current User, and that answers your       question.              Although, it does not really stop there. Say that you would add a new       Windows user on your machine and log into Windows with this user. I would       expect that this new user would be able to connect to at least the Express       instance. This is because with Express, Setup automatically add the group       BUILTIN\Users to SQL Server. (I don't think this happens with Standard.)              More generally, you can get access to an SQL Server instance, solely by       being member of a Windows group. This is useful in bigger corporations,       since this permits an administrator to give a new employee access to a       number of resources - file shares, printers, databases etc - by a single       addition to the Active Directory.              --       Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se              Books Online for SQL Server 2005 at       http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx       Books Online for SQL Server 2000 at       http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca