sql-server-2008sql-server-2008r2-express

Ideal Account to use for SQL Server 2008 R2 Express?


What is the ideal "Log On As" account to use for SQL Server 2008 R2 Express?


Solution

  • It depends how you're going to access it, in a Domain, Locally, or else. The most secure way is to use Windows Authentication. But if that's not your case, you could user Mixed Authentication and remember a best practice is to create an account with SysAdmin privileges, and disable SA account that is created by default.