This series is for professionals who start their journey with SQL Server administration and. Holds many Microsoft certificates including MCSA: Windows Server 200820122016, MCSA: SQL Server 201220142016, MCSE: Data Platform and MCT. With more than 10 years of experience in Microsoft technology, helps in advisory for performance optimization on database and application levels. Ing Contoso Database How To Configure SQLīelow there are steps describing how enable gMSA on Active Directory and how to configure SQL Server to take advantage of it.įor that we are going to execute PowerShell command on domain controller by user with Domain Administrator or Enterprise Administrator privileges.Įvery time when you build new server for SQL Server, check if all steps described in this blog post are configured. This limitation was solved new feature in Windows Server 2012 called Group Managed Service Account (gMSA). One of the restriction of the MSA was that it cant be used for more than one computer. Such object significantly increase security as the Database Administrator (DBA) doesnt need to change password for SQL Server accounts. This feature allows you to create an Active Directory account that is tied to specific computer object with complex password and automatic process of password renewal (like for the computer object). Once all steps are completed you should see following drives in This PC. I am using mount points due to fact that it is not commonly used and can help us with having too many drives in the system (situation when all drives letters are used). This will minimize random performance hiccups during normal operation. You may wonder what can be configured with configuration Yes, there are some settings that should be adjusted for drives used by SQL Server.
0 kommentar(er)
