Re: How Does SQL Server Verify Domain Security

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 04/24/05 

Date: Sun, 24 Apr 2005 11:36:12 +0200

No problem, thats a good articl about Autentification in SQL Server:

http://www.databasejournal.com/features/mssql/article.php/3341651

To summarize Aut: You logon on a domain controller prooving that your are
the individal that you are supposed to be. (Username and Password) If this
Aut. is successfull you get a Kerberos ticket is valid for a specific amount
of time. With this ticket you are able to logon to SQL Server bcause the
server can validate the ticket with the domain controller to proove "time"
and identity.

HTH, Jens Suessmeyer. 

---
http://www.sqlserver2005.de
---
"Will" <DELETE_westes@earthbroadcast.com> schrieb im Newsbeitrag 
news:uy%23DDRISFHA.3156@TK2MSFTNGP15.phx.gbl...
> How does SQL Server verify the credentials of a domain user who attempts 
> to
> use a database with domain security?    Is some sort of Kerberos key 
> passed
> instead of the userid and password, and how does SQL Server's security
> verify these tokens are correct?
>
> We want to migrate a small application from an internal network to the 
> other
> side of a proxy server, and we want to understand what is required for the
> domain authentication to continue working.
>
> -- 
> Will
>
>
>

Relevant Pages

  • Re: User ASPNET in SQL Server 2000
    ... and turn off anonymous access. ... a logon box will pop up if the user cannot ... >While I love integrated security in SQL Server, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: User ASPNET in SQL Server 2000
    ... I want to logon to the virtual catalog from the internet ... as the windows user then I want to logon to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Run As Command
    ... Declare @VCHCOMMAND Char, ... if you are using BACKUP DATABASE command to backup the database then ... to use a seperate logon for the destination server. ... to SQL server bacause SQL Server cannot see that domain. ...
    (microsoft.public.sqlserver.security)
  • Re: User ASPNET in SQL Server 2000
    ... I want to logon to the virtual catalog from the internet ... as the windows user then I want to logon to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Run As Command
    ... if you are using BACKUP DATABASE command to backup the database then ... to use a seperate logon for the destination server. ... to SQL server bacause SQL Server cannot see that domain. ...
    (microsoft.public.sqlserver.security)