March 3, 2020 at 12:12 am
Hi, I've been having some issues trying to get a brand new SSRS install deployed.
I have setup a brand new Windows 2019 server install along with SSRS 2019. I have the SSRS DB hosted a a separate Windows 2016/SQL2017 server. I have configured SSRS to use the Virtual Network service account and am trying to specify a Windows Integrated SQL account for DB connection.
This is where I am having issues. When I start SSRS the error log is logging these two errors.
library!DefaultDomain!5dc!03/03/2020-11:07:13:: 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 ---;
servicecontroller!DefaultDomain!5dc!03/03/2020-11:07:13:: e ERROR: Error initializing configuration from the database: 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)
On the SQL Server event logs I can see.
Message
Login succeeded for user 'XXXXXXX\SRV-XXXX-XXXXXX'. Connection made using Integrated authentication. [CLIENT: 10.55.XX.XX]
So the DB can connect to the SQL intstance and is part of all the right groups. Used the SSRS config tool to create the DB and account which completes successfully. Now if I grant the Service account local admin on the SSRS server everything starts fine, I have tried setting the account to login as service and login locally permissions.
Any ideas? SQL DB server and SSRS server are on the same domain.
March 3, 2020 at 3:00 am
So, looks like login as batch file seems top have fixed it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply