Error 1069, logon failure, often means the service account password changed in the domain. Here is how to find when a Domain Account Password was last changed.
PowerShell – Create a User with Read Rights on a Database
A DBA kept creating database users by hand. Here is a simple PowerShell and SMO script to create a user with read rights on a database.
SQL SERVER – How to Find Out When Your SQL Login Will Expire?
A client wanted a script to show when each SQL login will expire. LOGINPROPERTY makes it easy on SQL 2008 onwards. Here is the query I used.
SQL SERVER – FIX Error 18456, Severity: 14, State: 5. Login failed for user
A customer moving from Oracle kept getting Error 18456, Severity: 14, State: 5 from Java and from SSMS. Here is how we found the real cause.
SQL SERVER – Event ID 7000 – The service did not start due to a logon failure
SQL Server did not start after a reboot and the event log showed Event ID 7000, the service did not start due to a logon failure. Here is the cause and the fix.
Refreshing a Test Database From Production Safely
Plan refreshing a test database with isolated restores, safe paths, user repairs, data replacement, disabled outbound actions, and a log.
SQL SERVER – Who Changed the Password of SQL Login? – Interview Question of the Week #065
Who changed the password of your SQL Login? It is a real world question every DBA faces one day. Bookmark this post, here is how to find the answer.