Microsoft has released wonderful tool SQL Server 2008 R2 Best Practices Analyzer. I have previously used this tool and found it quite helpful. Here is the latest version which you can download from MS site.
Microsoft SQL Server 2008 R2 Best Practices Analyzer
However, I received quite a few emails that users are not able to install it after downloading this tool. There is nothing wrong with this tool but there are two prerequisites which are needed. I am additionally listing the download link to all of them here with.
Microsoft Baseline Configuration Analyzer 2.0
Microsoft PowerShell 2.0
Reference: Pinal Dave (https://blog.sqlauthority.com)
4 Comments. Leave new
Hi Pinal,
I have already installed SQL server 2005 in windows 7 operating system, Now I have install SQL server 2008 R2. Installation has been completed. but I can’t see “SERVER NAME” in connect to server dialog box of management studio.
I think problem is due to SQL Agent is not started, I tried to start SQL server Agent, but I can’t start. It gives error.
I had tried to find solution in blogs and etc…, but I can’t find any solution that is helpful.
Thanks in Advance.
—
Regards,
Haresh
Nice article.
I downloaded the tool and am trying to connect to one of our development SQL servers to test this out before using it on produciton.
I installed it on my client – should it be on the SQL server for which I am trying to gather information?
When I do try to connect to one of the development servers from the software on my client I get an error. Does the software need to be on the SQL Server for which I am trying to gather information?
Thanks
Daria B
DBA
Hi pinal i am unable to install it in windows 7 machine.