Post reply

Reporting service issue

  • July 1, 2015 at 8:08 am

    #299710

    Hi All,

    SQL Server Reporting Service is running under local system, but when i changed service from local to Network service , I am not able to connect to the Reporting servers.

    I am not sure what was the issue. could anyone please help me on this.

    Thanks in advance.

  • July 1, 2015 at 3:49 pm

    #1809696

    I would check if the Network Service account have full permission to this folder.

    <install>\Reporting Services\ReportServer\ReportService.asmx

    Network service is the default account to run SSRS. The best practice is to use Service account.

    Check out this article :

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

  • July 2, 2015 at 2:46 am

    #1809746

    Hi Sam,

    Thanks for the reply. As per you instruction I have given permission for the reportservices. But still I am getting error that " Service unavailable".

    Thanks,

    Arooj

  • July 2, 2015 at 10:48 am

    #1809996

    The account used must NT AUTHORITY\NetworkService - when you call CreateService or ChangeService config.

    Local Security policy - Local policies - User Rights Assignment - Log on as a service - check if the account is present.

    Do you have any GPOs applied on the server ?

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

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