Click here to Skip to main content
14,770,555 members
Home » Discussions » Database
   

Database

 
AnswerRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Pete O'Hanlon30-Jun-11 8:44
mvePete O'Hanlon30-Jun-11 8:44 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Vasudevan Deepak Kumar30-Jun-11 8:53
MemberVasudevan Deepak Kumar30-Jun-11 8:53 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
J4amieC1-Jul-11 2:18
MemberJ4amieC1-Jul-11 2:18 
AnswerRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Mycroft Holmes30-Jun-11 13:54
professionalMycroft Holmes30-Jun-11 13:54 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Vasudevan Deepak Kumar30-Jun-11 14:43
MemberVasudevan Deepak Kumar30-Jun-11 14:43 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
J4amieC1-Jul-11 0:57
MemberJ4amieC1-Jul-11 0:57 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Mycroft Holmes1-Jul-11 1:54
professionalMycroft Holmes1-Jul-11 1:54 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
J4amieC1-Jul-11 2:11
MemberJ4amieC1-Jul-11 2:11 
Ok, I have an even smaller sample size than you, but in 15 years of SQL/web development i have only once seen SQL authenttication used.

The wisdom passed to be by my elders was that windows authentication could be kept significantly more secure, primarily by centralising policies across (potentially) multiple instance of sql server.

Almost everywhere ive ever worked has specifically not installed sql with mixed mode security, making the use of sql authentication actually impossible.

Edit: this article seems to backup my claims above: http://databases.about.com/od/sqlserver/a/authentication.htm[^]

"Microsoft’s best practice recommendation is that you use Windows authentication mode whenever possible. The main benefit is that the use of this mode allows you to centralize account administration for your entire enterprise in a single place: Active Directory. This dramatically reduces the chances of error or oversight.

For example, consider the scenario where a trusted database administrator leaves your organization on unfriendly terms. If you use Windows authentication mode, revoking that user’s access takes place automatically when you disable or remove the DBA’s Active Directory account. If you use mixed authentication mode, you not only need to disable the DBA’s Windows account, but you also need to comb through the local user listings on each database server to ensure that no local accounts exist where the DBA may know the password. That’s a lot of work! "


Edit2: The general wisdom seems to be that if you support multiple platforms connecting to SQL, then SQL Authentication is your only option. If all clients are on a windows domain, use windows auth. (source: http://blogs.msdn.com/b/jjameson/archive/2007/03/23/sql-server-authentication-modes.aspx[^]).

Its certainly got nothing to do with company size or programmer experience!
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Mycroft Holmes1-Jul-11 2:26
professionalMycroft Holmes1-Jul-11 2:26 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
J4amieC1-Jul-11 3:40
MemberJ4amieC1-Jul-11 3:40 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Mycroft Holmes1-Jul-11 3:55
professionalMycroft Holmes1-Jul-11 3:55 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Eddy Vluggen3-Jul-11 2:08
professionalEddy Vluggen3-Jul-11 2:08 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Mycroft Holmes3-Jul-11 2:50
professionalMycroft Holmes3-Jul-11 2:50 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Eddy Vluggen3-Jul-11 3:03
professionalEddy Vluggen3-Jul-11 3:03 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Mycroft Holmes3-Jul-11 3:50
professionalMycroft Holmes3-Jul-11 3:50 
AnswerRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Shameel30-Jun-11 23:41
professionalShameel30-Jun-11 23:41 
GeneralRe: A Quick SQL/Integrated Authentication issue (Looks like I am missing something trivial) Pin
Vasudevan Deepak Kumar1-Jul-11 3:46
MemberVasudevan Deepak Kumar1-Jul-11 3:46 
Generali want a to get a SQL Pin
firass202529-Jun-11 10:58
Memberfirass202529-Jun-11 10:58 
GeneralRe: i want a to get a SQL Pin
Alaric_29-Jun-11 11:40
professionalAlaric_29-Jun-11 11:40 
GeneralRe: i want a to get a SQL Pin
Mycroft Holmes29-Jun-11 13:48
professionalMycroft Holmes29-Jun-11 13:48 
GeneralRe: i want a to get a SQL Pin
PIEBALDconsult29-Jun-11 15:36
professionalPIEBALDconsult29-Jun-11 15:36 
GeneralRe: i want a to get a SQL Pin
Johan Hakkesteegt29-Jun-11 23:22
MemberJohan Hakkesteegt29-Jun-11 23:22 
GeneralRe: i want a to get a SQL Pin
Pete O'Hanlon30-Jun-11 0:40
mvePete O'Hanlon30-Jun-11 0:40 
GeneralRe: i want a to get a SQL Pin
Corporal Agarn30-Jun-11 2:47
professionalCorporal Agarn30-Jun-11 2:47 
GeneralRe: i want a to get a SQL Pin
Pete O'Hanlon30-Jun-11 2:57
mvePete O'Hanlon30-Jun-11 2:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.