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

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

All set up went well. When I came to test out Report Manager, I hit security issues. The first one was simple. The Developer Edition of SQL Server is not set up for Remote connections by default so I ...

Use Windows accounts or groups whenever possible. SQL Server accounts are difficult to maintain and track, and SQL Server is a frequent target of hacker attacks. Here's one final piece of advice: Set ...