Monday, March 19, 2012

Is SQL Server Windows Authentication mode more secure than SQL Server "Mixed Mode" mode?

Gurus,
Is SQL Server Windows Authentication mode more secure than SQL Server "Mixed
Mode" mode? Someone told me it was b/c SA is disabled and there Windows
Authentication mode provides a good AD mapping to groups which is good for
administration.
Spin
I guess there is some validity in that line of reasoning. But if it really
comes to that difference, I'd argue that you may have a bigger problem. Point
is that you can make the mixed mode secure (e.g. with strong password and so
on).
Linchi
"Spin" wrote:

> Gurus,
> Is SQL Server Windows Authentication mode more secure than SQL Server "Mixed
> Mode" mode? Someone told me it was b/c SA is disabled and there Windows
> Authentication mode provides a good AD mapping to groups which is good for
> administration.
> --
> Spin
>

No comments:

Post a Comment