Microsoft Sql Server 2008 R2 Bpa Setup Error
Contents |
Escalation Services team. Introducing the SQL Server 2008 R2 Best Practices Analyzer (BPA)… ★★★★★★★★★★★★★★★ psssqlJune 20, 201016 Share 0 0 Some of you may have noticed I haven’t posted a blog in
The Specified Module Baseline Configuration Analyzer Was Not Loaded
some time. Well, I’ve been a bit busy working behind the scenes on a new sql server bpa tool we released this weekend, the SQL Server 2008 R2 Best Practices Analyzer (BPA). You may remember that I announced this new tool back in April at the PASS Europe Summit on this post. This past week final development and testing were completed on the tool and it is now available for you to download at the following location: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591 I will spend more time this summer posting a series of blogs on various aspects of the tool, the rules contained in it, and possible usages and benefits for you. While the tool was developed and produced by the product team, the CSS team was a major part of the project. The CSS SQL Escalation team provided much of the rule logic, design, and guidance about how the BPA tool would scan for known configuration settings or look for critical events to alert DBAs. In a way, running this tool is like getting CSS SQL Escalation advice without having to call CSS. For now let me give you a few facts to help you get started: Even though called SQL Server 2008 R2 BPA, it supports both SQL Server 2008 and SQL Server 2008 R2 Supports Windows Server 2003, Vista, Windows Server 2008, Windows Server 2008 R2, and Windows 7 Requires you to first install the Microsoft Baseline Configuration Analyzer 2.0 and Powershell 2.0 (only on WS03, Vista, or WS08). Comes with about 130 rules including applicable rules from SQL Server 2005 BPA ported to the new tool plus many other new rules covering Engine, Security, Replication, Reporting Services, Analysis Services, Setup (Servicing), and SSIS. Supports remote scanning through MBCA or through remote powershell (the help file explains all of this) We have also created a series of KB articles that covers every rule in the tool with reference information in the article pointing back to the rule. The articles can be found as you use the help file or click on the More Information Link in the tool results. However, you can also find our articles with some keyword searching on the internet: Go to http://support.microsoft.com and search
SQL Server Customer Advisory Team OLTP SQL Server SQL Server Customer Advisory Team SQL Release Services Running SAP Applications on the Microsoft Platform Integration Services SQL Server Customer Advisory Team Data Security & Storage SQL Security SQL Server Database Engine SQL Server Customer Advisory Team Data in the Cloud SQL Server Internet of Things Microsoft Azure - Database Microsoft Azure - Big Data Microsoft Azure - Internet of Things Cortana Intelligence and Machine Learning Cortana Intelligence and Machine Learning SQL Server Release Services Follow us to receive release https://blogs.msdn.microsoft.com/psssql/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa/ announcements related to Microsoft SQL Server SQL Server 2008 R2 Best Practices Analyzer is now available ★★★★★★★★★★★★★★★ June 18, 2010 by Matthias Berndt [MSFT] // 13 Comments Share 0 0 Following the original release of SQL Server 2008 R2 we are pleased to announce the associated release of the SQL Server 2008 R2 Best Practices Analyzer (BPA). BPA is designed for administrators who want https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2008-r2-best-practices-analyzer-is-now-available/ to determine the overall conformance of their SQL Server instances and topology with established best practices. BPA examines your SQL Server instance for system events, reviews login permissions, scans your SQL Metadata for advisable settings, and recommends solutions to items that do not conform with established Microsoft best practices. BPA runs within the framework of the Microsoft Baseline Configuration Analyzer (MBCA 2.0) and supports both, SQL Server 2008 and SQL Server 2008 R2. It is supported on a variety of operating systems including Windows Server 2003, Windows Server 2008, Windows 7. As always, we appreciate your feedback. Subsequent releases will "learn" from experiences of our customer base and we plan on expanding the best practices portfolio over time. For more information and download information go here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591 Dana H. BurnellProgram ManagerMicrosoft SQL Server
Back totop Search this blog Search all blogs Top Server & Tools Blogs ScottGu's Blog Brad Anderson’s "In the Cloud" Blog Brian Harry's Blog Steve "Guggs" Guggenheimer's Blog Tiger Team Blog Share This PostShareShareShareShareShare Recent Posts Cumulative Update #2 for SQL Server 2014 SP2 October 18, 2016 Cumulative Update #9 for SQL Server 2014 SP1 OctobeBusiness Intelligence http://sqlblog.com/blogs/davide_mauri/archive/2010/06/21/installing-sql-server-2008-r2-best-practices-analyzer-on-a-stand-alone-machine.aspx and .NET Installing SQL Server 2008 R2 Best Practices https://www.mssqltips.com/sqlservertip/2180/using-the-microsoft-sql-server-2008-r2-best-practice-analyzer/ Analyzer on a Stand-Alone machine As soon as the shiny new SQL Server 2008 R2 BPA has been released, I’ve downloaded it and tried to install it immediatly on my Virtual Machine, which is not joined to any sql server domain. Unfortunately I had a bad surprise, since the installation failed with a very anonymous error. Some more detailed error appears in a pop-up console, but it closes just too fast to be read. Armed with patience and Camtasia, I recorded the installation and found the error: I’ve microsoft sql server tried to run the command manually (using an Administrative account), but still no luck. After having reported the error, Adam Saxton came to the rescue : http://blogs.msdn.com/b/psssql/archive/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa.aspx So, to summarize, if you want to install in a stand-alone machine, do the following: Open a PowerShell 2.0 command prompt, using an administrative account Enable Powershell Remoting using the command Enable-PSRemoting Launch BPA installation using the command msiexec /i "SQL2008R2BPA_Setup64.msi" SKIPCA=1 Done :-) UPDATE You can find a detailed post on possibile installation errors (and their resolution) here: http://blogs.msdn.com/b/psssql/archive/2010/06/21/known-issues-installing-sql-2008-r2-bpa-relating-to-remoting.aspx PS You can find Microsoft® SQL Server® 2008 R2 Best Practices Analyzer here http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591 and the required Microsoft Baseline Configuration Analyzer 2.0 here http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=1b6e9026-f505-403e-84c3-a5dea704ec67 Published Monday, June 21, 2010 4:10 PM by Davide Mauri Comment Notification If you would like to receive an email when updates are made to this post, please regis
| Related Tips: 1 | 2 | More > DBA Best Practices Problem Database Administrators are often asked questions like "are all the SQL Servers within an organization configured according to the industry standards?" In this tip, you will see how a Database Administrator can quickly use Microsoft SQL Server 2008 R2 Best Practices Analyzer to analyze a SQL Server instance to determine whether it is configured according to the best practices or not. Database administrator can also use SQL Server 2008 R2 Best Practice Analyzer to analyze SQL Server 2008. Solution The Microsoft SQL Server 2008 R2 Best Practices Analyzer (BPA) is an excellent tool which is available as a free download from Microsoft. Using the BPA tool, a DBA can quickly gather information from Microsoft Windows and SQL Server configuration settings. The BPA tool basically uses a predefined set of SQL Server 2008 R2 recommendations and best practices to identify potential issues within the database environment. You can download the latest version of Microsoft SQL Server 2008 Best Practices Analyzer (BPA) for free from the following link. Once you have installed Microsoft SQL Server 2008 R2 Best Practices Analyzer (BPA). You can use the tool by clicking Start | Programs | Microsoft Baseline Configuration Analyzer 2.0. In Microsoft Baseline Configuration Analyzer 2.0, Select a Product as SQL Server 2008 R2 BPA as shown in the below snippet. Next, click Connect to Another Computer and choose Local Computer and then click OK to close Connect to Another Computer window. In Microsoft Baseline Configuration Analyzer 2.0 window, click Start Scan to begin the scan. In Microsoft Baseline Configuration Analyzer 2.0 Enter Parameters screen, you need to specify the SQL Server Instance Name, for a default instance you need to specify the instance name as MSSQLSERVER. Using Microsoft SQL Server 2008 R2 Best Practice Analyzer you can scan SQL Server Database Engine, Analysis Services, Replication, Integration Services, Reporting Servers and SQL Server Setup. You can choose the required Parameters and click the Start Scan at the bottom of the screen to begin the scan. In the below snippet you can see the Microsoft Baseline Configuration Analyzer 2.0 is scanning to identify potential