SSRS with Sharepoint integrated mode server restart order

• Raul Undreiner

  SSCommitted

  Points: 1554

  More actions

  January 8, 2016 at 7:41 am

  #307579

  Hello all,

  We have SSRS 2008R2 and SharePoint 2010 installed in different servers. We think we are having synchronization problems since our reports are dropping the datasources and subscriptions as posted in a previous topic. I'm wondering if there is a specific order that needs to be followed when restarting the servers. Our sharepoint is located in 2 servers, one holding the sharepoint database (SQL Server 2008R2) and another one with the web side of sharepoint. SSRS is on a separate server. So 3 servers. I'm thinking we should restart the SharePoint web server first, then the sharepoint SQL and then the SSRS server.

  Does it really matter? Should they sync anyway? If any of them had an auto update applied and needs to restart, should the others be restarted too?

  Thanks in advance

• Jo Pattyn

  SSC-Dedicated

  Points: 32069

  More actions

  January 20, 2016 at 4:26 am

  #1853086

  I would start them in this order

  1.SSRS Server

  2.SharePoint SQL (no connection errors to reports)

  3.SharePoint Web (no connection errors to SharePoint sql)