Logon failure: the user has not been granted the requested logon type at this co

Question

Logon failure: the user has not been granted the requested logon type at this co

Kevins1966

SSC Enthusiast

Points: 172
More actions
September 8, 2023 at 8:56 am

#4282297

Hi,
I have installed Report Server on two Windows Server 2019 machines.
I believe I have followed the same process on both though obviously service accounts, server names etc are different.
On the first I can browse successfully to the Web Service URL however the second gives me the following message
Reporting Services Error
The report server cannot open a connection to the report server database. The log on failed. (rsReportServerDatabaseLogonFailed) Get Online Help
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
SQL Server Reporting Services
This is not an activity I have a lot of experience in so I am wondering how best to diagnose the problem.
I have compared the configuration of the SQL Server Management Studio Security Login for the service account used for setting up Reporting Services and they appear to be the same.
The only differences I can see in Comparing Report Server Configuration Manager is that the Backup button on the Encryption Keys page is greyed out on the problematic installation.
I've also notice that in SQL Server Management Studio I can connect to Reporting Services on the successful install server but not the problematic one, however I am not sure if this is helpful as I don't know if successful connection to reporting services from SSMS is a result of a successful set up or a prerequisite.
In log files I can see the following
RSManagement_2023_09_08_09_00_09
2023-09-08 09:46:32.8452|WARN|4|Encrypted data is not accessible| RequestID = s_5d438c0d-182c-45c5-bc5f-5b9bff0db65e Microsoft.BIServer.HostingEnvironment.Cryptography.Exceptions.SymmetricKeyNotInitializedException: Symmetric key not initialized
at Microsoft.BIServer.Configuration.Key.KeyRepository.GetAnnouncedKeyResults(Guid installationId)
at Microsoft.BIServer.Configuration.Key.KeyRepository.ReloadEncryptedSymmetricKey()
at Microsoft.BIServer.Management.WebApi.Controllers.StateController.ReloadEncryptedSymmetricKey(ISqlAccess sqlAccess, Byte[]& encryptedSymmetricKey, DatabaseValidationStatus databaseValidationStatus)
I'm not sure how to follow up the above
ReportingServicesService_2023_09_08_09_00_14
e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseLogonFailedException:
, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseLogonFailedException:
The report server cannot open a connection to the report server database. The log on failed.
---> System.Runtime.InteropServices.COMException: Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at Microsoft.ReportingServices.Library.ConnectionConfig.GetImpersonationUser(String userName, String domain, String userPwd)
--- End of inner exception stack trace ---;
This simply appears to echo the message displayed in the browser
Any advice would be gratefully received.

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

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

Mr. Brian Gale SSC-Insane Points: 24934 More actions · Answer 1

The error tells you MOST of what you need to know - the user doesn't have access to log into the database. Your next step will be to log into the SQL Instance (not SSRS) and grant the user access to the database.

SSRS NEEDS a SQL instance to connect to and your service account is the account it will be connecting as. So you just need to give your service account the appropriate access to the instance and you should be good to go.

The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

frederico_fonseca SSCoach Points: 16251 More actions · Answer 2

error is likely related to the logon type within the computer itself - a service account used for SSRS needs to be setup "correctly" through the admin pages - not doing so means that some permissions on local server may not be granted.

see https://blog.sqlauthority.com/2017/04/14/sql-server-logon-failure-user-not-granted-requested-logon-type-computer/ for one example