Microsoft Best Practices Analyzer for WSS 3.0 and MOSS 2007


The Microsoft Best Practices Analyzer for Windows SharePoint Services 3.0 and the 2007 Microsoft Office System Best Practices Analyzer programmatically collects settings and values from data repositories such as MS SQL, registry, metabase and performance monitor. Once collected, a set of comprehensive ‘best practice’ rules are applied to the topology.

Administrators running this tool will get a detailed report listing the recommendations that can be made to the environment to achieve greater performance, scalability and uptime.



  1. When I run it on a WSS 3 install that has SQL 2005 Express installed on the same server, it gives me this error eight times:

    "Error connecting to SQL Server

    An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)"

    I’m running it with this string:

    sharepointbpa.exe -cmd analyze -substitutions SERVER_NAME SharePoint3

    Any thoughts?




  2. Hi Ray,

    I don’t have more details. On my box the tool worke fine.

    For such problems please post into the public newsgroup or open a support case with Microsoft.




Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.