Tag Archives: security

MDF File Password Confusion

I had never seen this, but I ran across a blog that mentioned an MDF File password here. The post really looks at ways to reset the administrator password for the “sa” account in SQL Server. However it has some … Continue reading

Posted in Blog | Tagged , , | Comments Off on MDF File Password Confusion

Track Your Consultants

If you pay attention to security issues in software, you’ve probably heard about man-in-the-middle attacks. These can occur more frequently than you expect, though inside of a company, it’s more unlikely that you’ll experience one if you have some fairly basic … Continue reading

Posted in Editorial | Tagged | Comments Off on Track Your Consultants

Locking sa

When I started working with SQL Server, the sa account was “the” account used for admin operations. This was the default account for many DBAs and as a result, it couldn’t be locked out. This changed in SQL Server 2005, … Continue reading

Posted in Blog | Tagged , , | Comments Off on Locking sa

#SQLNewBlogger–Adding Local Accounts

  What do you do if you need a process running under Local Service to connect to your SQL Server? Most of the advice out there is to change the login account. I actually agree with that, but there are … Continue reading

Posted in Blog | Tagged , , , | Comments Off on #SQLNewBlogger–Adding Local Accounts