November 20, 2018 at 3:40 am
Hi, I need to configure the unattended execution account and I am having some permission issues. I am somewhat out of my depth where networking and permissions are concerned so I hope someone can help. Here is what I have tried so far;
I have created a new local domain user account, lets call it 'LOCALDOMAIN\SSRS_Unattended', and assigned this user to the basic 'User' group.
In SQL server, under security, I have added this new user.
In user mappings I have assigned the following roles
master - Public & RSExecRole
msdb - Public & RSExecRole
ReportServer - Public & RSExecRole (also db_owner out of desperation)
ReportServerTempDB - Public & RSExecRole (also db_owner out of desperation)
Using 'Reporting Services Configuration Manager' under execution account I selected 'Specify an Account' and entered the created user Domain\Username and password.
My issue is that now whenever I try to execute a report I get the following error;
"The report server has encountered a configuration error. Login failed for the unattended execution account. (rsServerConfigurationError)
Log on Failed. Ensure the user name and password are correct. (rsLogonFailed)
Logon failure: the user has not been granted the requested logon type at this computer"
I have checked and rechecked the username/password details. I have even had other people watch me enter them and had them do the same but to no avail
HOWEVER if I assign the user to the 'Administrator' role in windows user management then everything works fine!
I know I cannot leave it with this role assignment, more than my jobs worth!
It is clear to me that I missing some vital steps in what role I need to assign my unattended user to and I cannot seem to find anything via Google or other sources that makes any sense to a non network guy.
Can anybody please help?
November 20, 2018 at 10:01 am
scout7-500377 - Tuesday, November 20, 2018 3:40 AMHi, I need to configure the unattended execution account and I am having some permission issues. I am somewhat out of my depth where networking and permissions are concerned so I hope someone can help. Here is what I have tried so far;I have created a new local domain user account, lets call it 'LOCALDOMAIN\SSRS_Unattended', and assigned this user to the basic 'User' group.
In SQL server, under security, I have added this new user.
In user mappings I have assigned the following roles
master - Public & RSExecRole
msdb - Public & RSExecRole
ReportServer - Public & RSExecRole (also db_owner out of desperation)
ReportServerTempDB - Public & RSExecRole (also db_owner out of desperation)Using 'Reporting Services Configuration Manager' under execution account I selected 'Specify an Account' and entered the created user Domain\Username and password.
My issue is that now whenever I try to execute a report I get the following error;"The report server has encountered a configuration error. Login failed for the unattended execution account. (rsServerConfigurationError)
Log on Failed. Ensure the user name and password are correct. (rsLogonFailed)
Logon failure: the user has not been granted the requested logon type at this computer"I have checked and rechecked the username/password details. I have even had other people watch me enter them and had them do the same but to no avail
HOWEVER if I assign the user to the 'Administrator' role in windows user management then everything works fine!
I know I cannot leave it with this role assignment, more than my jobs worth!
It is clear to me that I missing some vital steps in what role I need to assign my unattended user to and I cannot seem to find anything via Google or other sources that makes any sense to a non network guy.
Can anybody please help?
Try granting that account permissions on the report server to Log on Locally.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply