One of my client was running into the below error running xp_logininfo on some of their users. It was interesting that when they run the script to capture user information it works for the same user in another domain. They asked me if there is anything specific they can look for to find out the difference between the two users in the different domains?
How to Change Owner of Database in SQL SERVER? – Interview Question of the Week #117
Question: How to Change Owner of Database in SQL SERVER?
SQL SERVER – Script to Audit Login and Role Member Change
Once there was a security breach on my client machine and they wanted to know who made changes to the SysAdmin role. They contacted me and my first question was that, are you are auditing such changes and as expected answer was No. I gave them answer that nothing can be done as a consultant. They still wanted my suggestion to prevent this in future. So, they want to track if someone does such things in future. Let us see a script to audit login and role member change.
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.
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.