Stefan Goßner

Senior Escalation Engineer for SharePoint Products and Technologies

Microsoft Best Practices Analyzer for WSS 3.0 and MOSS 2007

Microsoft Best Practices Analyzer for WSS 3.0 and MOSS 2007

  • Comments 3
  • Likes


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.
  • 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?



  • 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.



  • Hi,

    I have found a work around for this try it,



Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
Raw Html Fix