How do you find the Service Account for SQL Server and SQL Server Agent? Here are three ways: Configuration Manager, services.msc, and a T-SQL query.
SQL SERVER – Transfer Logins Error: Msg 15419: Supplied Parameter sid Should be Binary(16) – sp_help_revlogin
Moving logins with sp_help_revlogin, I hit Msg 15419: supplied parameter sid should be binary(16). Here is what causes it and how to fix the script.
SQL SERVER – Transfer Logins Error: Msg 15021: Invalid Value Given for Parameter Password
Moving logins with sp_help_revlogin failed with Msg 15021: invalid value given for parameter PASSWORD. Here is what was wrong with the hashed password.
SQL SERVER – Always On Replica Disconnected After Changing SQL Server Service Account
After I changed the SQL Server service account in my lab, the Always On secondary replica went disconnected. Here is why the endpoint rejects the new account.
How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176
Files kept vanishing from a client’s SQL Server Binn folder. SQL Server cannot track that, so here is how to enable Files and Folders Level Auditing in Windows.
SQL SERVER – Unable to Bring SQL Cluster Online – Reason: The Account is Disabled
After security hardening, a client’s SQL cluster resource sat in Online Pending, then failed: the account is disabled. Here is how we found and fixed it.
SQL SERVER – Creating a Login and Database User Without Automatic Sysadmin Grants
To Create a Login and User, I separate the instance identity from database access. Database ownership and sysadmin membership have different scopes.