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
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.
I have found a work around for this try it,