As I don't really know the other tools I can't really give any cons of SQL Server, aside from the learning curve perhaps.

But I've got some pro's:

* If you have already SQL Server: it is free!

* Good integration with Excel (which is still the most commonly used BI interface)