Examine the similarities and differences between Windows security and SQL Server security and you'll find that most of the concepts you already know from managing a network will map quite nicely into ...

I'm rebuilding our SQL 2000 box and trying to figure out the best way to configure the permissions settings. The first question is whether to use a local or domain account for the SQL service account.

I am pretty much at a loss here, this should be easy. All I am trying to do is install a simple instance of SQL 2008 R2 Express on a Windows 2K8 x64 Server. No luck. The domain name is COPPER, the ...