RE: security



Hi Johna,
SQL Server has two authentication mode: Windows Authentication mode and
Mixed Authentication mode. You needn't have to assign an user local
administrator permission. Any local user or domain user can access SQL
Server however he need to be assigned more sql server permissions to
execute query , DML operations and manage the sql server.

For more information, you can refer to:
Authentication Mode
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_
runsetup_6p9v.asp

If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.

Charles Wang
Microsoft Online Partner Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

.



Relevant Pages

  • Re: How to check user_id and password via ADO ?
    ... SQL Server, when in Mixed Authentication mode, automatically checks user's ... > Please tell me how can I check the user_id and password while user logins? ...
    (microsoft.public.sqlserver.security)
  • Re: security
    ... using Windows Authentication. ... SQL Server has two authentication mode: ... Server however he need to be assigned more sql server permissions to ...
    (microsoft.public.sqlserver.setup)
  • RE: How to access SQL Server from a non-privileged domain account
    ... account to be able to access the SQL Server. ... Since your SQL Server 2005 has been running with Windows Authentication ... Contact your network administrator to add your domain account to the ... Change your SQL Server 2005 authentication mode to Mix mode so that you ...
    (microsoft.public.sqlserver.setup)
  • Re: Questions about SQL on SBS Premium
    ... Changing the authentication from Windows to Mixed mode will not ... Just make sure you secure this SQL Server ... The authentication mode needs to be set to mixed mode (it is currently ...
    (microsoft.public.windows.server.sbs)
  • Re: losing sysadmin
    ... You can edit the registry key (This key will vary slightly for a default ... > 1)My SQL Server is in Mixed Authentication Mode. ... > 4)Now I changed the Mixed Authentication Mode to Windows ...
    (microsoft.public.sqlserver.security)