I'm thinking of switching to Windows Authentication on my SQL 2008 server. Here's my first draft at a plan:
1. Create Windows accounts matching the exiting SQL accounts.
2. Grant the new Windows accounts the appropriate database permissions.
3. Change applications to use the new account information.
4. Remove the SQL accounts
5. Switch SQL to Windows Authentication
Is is that simple? Or am I missing something?
View Complete Post