3

Provision Subscriptions and Alerts - SQL Server Reporting Service with SQL AlwaysOn Cluster

view full story
linux-howto

http://serverfault.com – I have an SQL 2012 AlwaysOn Cluster and need to setup SharePoint reporting services. Within SharePoint farm configuration it reports that the SQL server agent is not running. Since I have multiple SQL nodes to which the connection can fail over to any, how do I handle the SQL server agent or is this clustered also? Does the downloadable SharePoint reporting SQL script need to be ran on each node? Finally, how does SharePoint switch to a different SQL Server agent if a node in the cluster goes down? (HowTos)