Daily Archives: April 4, 2016

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