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.

SQL Server manages this by creating an account in the database as well. You don't have to make the account names the same, but you'll save yourself a huge amount of stress by keeping everything the ...

How to protect your database from SQL injection, data theft, rogue users, and well-meaning meddlers without tying your environment in knots Like so much of IT, database security requirements largely ...

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 ...