Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

windows or mixed mode

  
   Database Forums (Home) -> Security RSS
Next:  SSIS Package blocked on a data conversion  
Author Message
mm2t

External


Since: Nov 26, 2008
Posts: 1



(Msg. 1) Posted: Wed Nov 26, 2008 8:05 am
Post subject: windows or mixed mode
Archived from groups: microsoft>public>sqlserver>security (more info?)
Hi experts.
I have a site over internet.
MSDN: When possible, use Windows Authentication.
please see : http://msdn.microsoft.com/en-us/library/aa905171.aspx
What is this reson?
which mode is realy secure over internet?

 >> Stay informed about: windows or mixed mode 
Back to top
Login to vote
"Rick Byham,

External


Since: Jan 15, 2007
Posts: 80



(Msg. 2) Posted: Wed Nov 26, 2008 8:56 am
Post subject: Re: windows or mixed mode [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Windows Authentication mode has more features, for instance it can use
Kerberos. However it requires a domain to authenticate the user, so if the
client and the server are the same domain or a trusted domain, you'll have
to use SQL Server Authentication. It's not bad. It just doesn't have the
full Windows infrastructure behind it.
Here is the description from Books Online.
http://msdn.microsoft.com/en-us/library/ms144284.aspx
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"mm2t" wrote in message

> Hi experts.
> I have a site over internet.
> MSDN: When possible, use Windows Authentication.
> please see : http://msdn.microsoft.com/en-us/library/aa905171.aspx
> What is this reson?
> which mode is realy secure over internet?
>

 >> Stay informed about: windows or mixed mode 
Back to top
Login to vote
Uri Dimant

External


Since: Aug 24, 2003
Posts: 739



(Msg. 3) Posted: Thu Nov 27, 2008 3:25 am
Post subject: Re: windows or mixed mode [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Rick
> so if the client and the server are the same domain or a trusted domain,
> you'll have to use SQL Server Authentication

Perhaps yopu mean not at the same domain....

"Rick Byham, (MSFT)" wrote in message

> Windows Authentication mode has more features, for instance it can use
> Kerberos. However it requires a domain to authenticate the user, so if the
> client and the server are the same domain or a trusted domain, you'll have
> to use SQL Server Authentication. It's not bad. It just doesn't have the
> full Windows infrastructure behind it.
> Here is the description from Books Online.
> http://msdn.microsoft.com/en-us/library/ms144284.aspx
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "mm2t" wrote in message
>
>> Hi experts.
>> I have a site over internet.
>> MSDN: When possible, use Windows Authentication.
>> please see : http://msdn.microsoft.com/en-us/library/aa905171.aspx
>> What is this reson?
>> which mode is realy secure over internet?
>>
>
 >> Stay informed about: windows or mixed mode 
Back to top
Login to vote
"Rick Byham,

External


Since: Jan 15, 2007
Posts: 80



(Msg. 4) Posted: Mon Dec 01, 2008 9:32 am
Post subject: Re: windows or mixed mode [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Yes. Sorry about that. I meant "the client and the server are NOT in the
same domain or a trusted domain, you'll have
to use SQL Server Authentication."
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Uri Dimant" wrote in message

> Rick
>> so if the client and the server are the same domain or a trusted domain,
>> you'll have to use SQL Server Authentication
>
> Perhaps yopu mean not at the same domain....
>
> "Rick Byham, (MSFT)" wrote in message
>
>> Windows Authentication mode has more features, for instance it can use
>> Kerberos. However it requires a domain to authenticate the user, so if
>> the client and the server are the same domain or a trusted domain, you'll
>> have to use SQL Server Authentication. It's not bad. It just doesn't have
>> the full Windows infrastructure behind it.
>> Here is the description from Books Online.
>> http://msdn.microsoft.com/en-us/library/ms144284.aspx
>> --
>> Rick Byham (MSFT), SQL Server Books Online
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mm2t" wrote in message
>>
>>> Hi experts.
>>> I have a site over internet.
>>> MSDN: When possible, use Windows Authentication.
>>> please see : http://msdn.microsoft.com/en-us/library/aa905171.aspx
>>> What is this reson?
>>> which mode is realy secure over internet?
>>>
>>
>
>
 >> Stay informed about: windows or mixed mode 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Security All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]