Defauld SQL Logins - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Defauld SQL Logins

Author

Topic

Deepak03@rediffmail.com
Starting Member

11 Posts

Posted - 2009-04-28 : 11:30:52

Hi, In a fresh installation of SQL Server i can fould below logins in mixed mode:

1. BUILTIN\Administrators
2. NT AUTHORITY\SYSTEM
3. S2-0090\SQLServer2005MSSQLUser$S2-9909$MSSQLSERVER
4. S2-9909\SQLServer2005SQLAgentUser$S2-9909$MSSQLSERVER
5. S2-9909\SQLServer2005MSFTEUser$S2-9909$MSSQLSERVER
6. sa

the 1.) login is used for users having admin access(on windows level) on that box
6. sa is sql's sa

could anyone please explain about the rest of the logins, what they are and for what purpoose they can be used.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-04-29 : 18:44:06

Books online has all that info.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources