Best Practicing, the Results Part Dos
This week, we have been talking about running the Microsoft Baseline Configuration Analyzer 2.01 with the SQL Server Best Practice Analyzer for 2008 R2. Today I want to talk about one of the errors that occurred on one of the new boxes I just stood up in a new cluster. You may encounter a prerequisite error stating that the user is not a member of the Administrators group on the remote machine or PowerShell remoting is not enabled on the remote server. This is easily remedied.
- Add the user as a member of the Administrators group, or
- Run Enable-PSRemoting in PoweShell with elevated privileges, AND
- Run winrm set winrm/config/winrs `@`{MaxShellsPerUser=`”10″`} in PowerShell with elevated privileges.
Once I made these changes the analyzer was able to proceed. The analyzer will give you these directions, but I figured if you are reading this beforehand you can make the changes proactively. Enjoy!
Posted on March 21, 2012, in Maintenance and tagged Best Practices, BPA, SQL Server 2008R2. Bookmark the permalink. Leave a comment.
Leave a comment
Comments 0