When you create the SQL Server login, you can move to the Database tab and add the account to the database at the same time. If you're adding multiple accounts, however, it's often easier to use a ...

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

Understand SQL Server Security SQL Server grew out of the UNIX world, and administrators maintained accounts (at that time) in a fashion similar to the "no domain" scenario in Windows. They created ...