Post reply

SQL Server SSRS - RSTempFiles

  • December 2, 2016 at 3:48 pm

    #332488

    Hi

    After installing the SQL 2014 SSRS, can we change the location temp file folder to different drive? If possible, can you please provide the steps? Or just updating the web.config will suffice?

    Thanks

    Shuaib

  • December 6, 2016 at 8:49 pm

    This was removed by the editor as SPAM

  • December 7, 2016 at 3:19 pm

    #1916639

    JasonClark (12/6/2016)

    Using SQL Server Management studio it can be changed:

    Go to Object Explorer, right-click a server and Properties then click on the Database settings page.

    Database default locations, view the current default locations for new data files and new log files. Here you can change the path by giving path name.

    That's totally incorrect.

    The RSTemp directory has nothing to do with setting the default location of data and log files in SQL Server.

    Sue

  • December 7, 2016 at 3:34 pm

    #1916643

    ShuaibV (12/2/2016)

    Hi

    After installing the SQL 2014 SSRS, can we change the location temp file folder to different drive? If possible, can you please provide the steps? Or just updating the web.config will suffice?

    Thanks

    Shuaib

    You'd change it in the RSReportServer.config file, actually add it as I believe it's blank by default.

    You would add the entry to the services section, along the lines of:

    <FileShareStorageLocation>

    <Path>X:\NewPathTo\RSTempFiles</Path>

    </FileShareStorageLocation>

    Check this article for information on the config file - it has an example of adding this as well:

    https://msdn.microsoft.com/en-us/library/ms157273(v=sql.120).aspx

    Sue

  • January 3, 2017 at 10:03 am

    #1920432

    Thank you and it seems to be the solution. However, for now we have increased the disk capacity and will look into it later when we run into issues again.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply