Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ConfusedAgain
Yak Posting Veteran
82 Posts |
 Posted - 2010-10-04 : 16:26:08
|
| I am installing SQL Server 2008 on Windows 7 on my laptop.What is the best to choose, Windows or SQL server authentication and why? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-10-04 : 19:09:21
|
| Unless you have specific audit or compliance requirements, I'd recommend mixed mode. You can always disable, or not create, any other logins besides SA. I recently got locked out of 2 Windows Auth instances (not installed by me) because the only account with sysadmin privileges belonged to an employee who had recently left. This is especially easy if you follow Microsoft's recommendation and remove the BUILTIN\Administrators group from your SQL instance. |
 |
|
|
ConfusedAgain
Yak Posting Veteran
82 Posts |
Posted - 2010-10-06 : 04:47:33
|
| Thank you for that I have opted for mixed mode and all seems to work smoothly with connecting VS to the database that way. |
|
|
|
|
|
|
Windows on SQL Authentication on installation