SQL Server Security … basic 101 stuff?
Sure, you’ve mastered the foundational areas (i.e., logins, users, permissions, etc.), but there is much more to security than permissions to database objects. In this webinar, Randy Knight digs into some areas that are often overlooked, starting with the SQL Server services and best practices for the service accounts, including utilizing Group Managed Service Accounts (gMSA), permissions needed at the operating system level, and the overall surface area configuration of the services.
He also goes deeper into Service Principal Names (SPNs) and Kerberos and why these are important for DBAs to understand. If you’ve ever had to troubleshoot the dreaded and oh-so-helpful error message “Could not generate SSPI context,” or struggled to get Windows Authentication to work for a web application or linked server, we will answer those questions and more.