Re: How to implement Windows Authentication?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 01 Feb 2008 15:09:56 -0800
Peter (Peter@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I don't recall that the SQL Server 2008 Installation asks me to specify an
admin user.
This was something that was changed in CTP5. Previous CTPs used the old
SQL 2005 setup.
The application will not create windows groups or windows users in AD.
Whether the application will create login which is tied to a windows
group or a window user is a question mark to me. If the common way (or
standard) is to have logins for an applicaton created outside the
application, I will follow the standard. The problem is that I have no
exposure to any application which is using Windows Authentication so I
don't know whether the authentication should be handled internally by
the application or not. I cannot find guideline/best practice for this
in MS.
I can't claim to have any knowledge in this area, but my gut feeling
is that you should do it outside the application.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: How to implement Windows Authentication?
- From: Erland Sommarskog
- Re: How to implement Windows Authentication?
- Prev by Date: Re: SQL 2005 express security issue
- Next by Date: Re: SQL 2005 express security issue
- Previous by thread: Re: How to implement Windows Authentication?
- Next by thread: Re: SQL job schedule modification
- Index(es):
Relevant Pages
|
