Earlier last month, I posted an interview question – How to Generate Random Passwords in SQL Server? – Interview Question of the Week #181. Though, my efforts were honest my answer was not complete in that blog post. Thankfully, SQL Server Expert Tim Cartwright noticed the error in the blog post and decided to send me to follow up email with the accurate script to generate a random password.
SQL SERVER – Transfer Logins Error: Msg 15021: Invalid Value Given for Parameter Password
One of my existing clients contacted me for assistance in fixing an error. Sometimes, if the error is easy and it doesn’t take more than 10-15 minute, I give them the benefit of being my existing customer and I give free consulting (not always though). They informed me that they need moving SQL logins (username and password) from one server to another. To achieve that they were using sp_help_revlogin. Here are the steps:
MySQL – Fix – Error – Your Password does not Satisfy the Current Policy Requirements
Just the other day I received an email from a MySQL user who has been struggling to set up his password due to the current policy requirements in MySQL. Let us see how we can identify what is his root cause and how to fix the issue with password security.
SQL SERVER – Log Shipping Copy Job Failure – The Password for This Account Has Expired
Working as freelancer gives an opportunity to see various kinds of error and having fun to fix them. Recently, one of my blog readers sent an email and asked assistance on the log shipping issue. He said that log shipping copy job is failing.
As usual, I asked him error message and he shared below piece from copy job history.
SQL SERVER – Best Practices About SQL Server Service Account and Password Management
One of my clients posted a question to me about management of SQL Server service account. Since it was a nice learning for me, I am sharing my discussion via this blog post. Let us see the Best Practices About SQL Server Service Account and Password Management.
When was Domain Account Password Changed in SQL Server? – Interview Question of the Week #093
If you are a DBA for quite some time, then at least once you must have encountered below error about Domain Account Password.
Error 1069: The service did not start due to a logon failure. I have already written a blog about this long ago.
SQL SERVER – Who Changed the Password of SQL Login? – Interview Question of the Week #065
Today’s interview question was not really asked interview, but it is indeed a real world scenario which everyone should know the answer of. I strongly suggest you bookmark this blog post at once in your lifetime you will need this blog post to know who changed the password of your SQL Login?
Question: Who changed the password of SQL Login?
Answer: Continue to read the answer.