posted on Wednesday, February 07, 2007 1:10 PM by admin
Vista and SQL Server Mixed-Mode
I've been traveling the continent the past few months warning people of the evils of SQL Server Mixed Mode authentication. I recently (this past weekend) procured a snappy new Gateway laptop with Vista installed.
It turns out SQL Server 2005 installed on Vista does not automatically add members of the local Administrators group to the SQL Server role BUILTIN\Administrators. Rather than waste lots of time reading the readme files, I discovered this when I tried to connect to freshly-installed SQL Server instance.
So after re-installing SQL Server in Mixed Mode and logging in as sa, I was able to add myself as a sysadmin. Afterwards, I changed the instance from Mixed Mode to Windows Authentication. Windows Authentication is still more secure.
Thank you, Slammer worm...
:{> Andy
Technorati Tags: SQL Server 2005 Vista Mixed Mode Windows Authentication security Slammer