Re: security
- From: "John" <Johna@xxxxxxxxxxxxx>
- Date: Wed, 16 Aug 2006 06:26:49 -0400
That's easy to say I needn't have to assign, but until I do, the user can't
connect. It seems something is set wrong, but I need to know what. I am
using Windows Authentication.
"Charles Wang[MSFT]" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:UY1zG$OwGHA.5864@xxxxxxxxxxxxxxxxxxxxxxxx
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.
======================================================
.
- Follow-Ups:
- Re: security
- From: Charles Wang[MSFT]
- Re: security
- References:
- security
- From: John
- RE: security
- From: Charles Wang[MSFT]
- security
- Prev by Date: Re: Exact use of Log file - why so big?
- Next by Date: Re: Exact use of Log file - why so big?
- Previous by thread: RE: security
- Next by thread: Re: security
- Index(es):
Relevant Pages
|
