Home Forums SQL Server 2012 SQL 2012 - General SQL 2012 running SSRS without the ability to add users. RE: SQL 2012 running SSRS without the ability to add users.

  • December 14, 2017 at 1:02 am

    #1972071

    Hi There,
    Hope you're doing well !
    I've gone thru your problem case as above, What I can conclude from my end is, Memory issue in the server where the SSRS is installed.
    Firstly I want to check,

    1. Whereis the SSRS installed ? Is it installed in DB server / Application server ?

    2. Howmuch the main memory is allocated In the server where the SSRS isinstalled  ?  ( RAM size )

    3. What isthe OS version, If it is windows, what is the windows server and clientversions ? ( 32 bit / 64 bit ) ( this info will help to trouble shootcompatibility issue )

    4. If RAMsize is 10gb, say for example, how much memory was given to SSRS ?  (Please check report server config file )

    5. IIS isinstalled in the server where SSRS is configured ? If it is there, check foractive internet connections

    Please reply to these, Once you've replied we can further investigate into SSRS config file and settings.
    Thanks
    Subbu