Ok, for SQL server 2000, I need to change the account it runs under. I know you need to go to the Enterprise Manager, find the database, right click, properties, choose security tab, and at the ...

Reason: login failed for user 'sa'. Please verify SQL Server is running and check your SQL Server Registration properties (by right-clicking on the SERVER1 node) and try again.</pre> ...

In my next several posts, I'd like to take a good look at SQL Server security. We'll primarily focus on SQL Server 2008 R2, which is the latest release. Many of the concepts I plan to discuss will ...