Hello friends, As always enjoying cross platform Database
support and sharing something new for
you. Today I am going to share on SQL Server reporting services. Sometime a
small change can lead the blunder of issues in any IT environment and you will start running here and there to resolve,
if things are not good. Recently I was looking on MSBI-Report on development
environment , I was new on this reporting server .
Reporting server was running with .\Administrator logon, IT team given public access IP to access SSRS
report publicly for demo purpose. For keeping security measure and threats in
mind I just re-set the administrator password on windows server. I was assuming when user will access the
report it will ask for new windows credential and with new credential they will
see the report. After testing I will rollback the password. But things goes
wrong as I need to change more. After changing password reporting server
started throwing error .
" Unattended
Execution Account in SSRS, The report server has encountered a configuration
error. Logon failed for the unattended execution account.
(rsServerConfigurationError) Log on failed. Ensure the user name and password
are correct. (rsLogonFailed) Logon failure: unknown user name or bad
password".
For the quick resolution I started digging around search
engine and experimenting because developer is waiting to see his report back on
their asp.net web application , as his
demo was scheduled.
- I restarted the services of SSRS ... no resolution.
- I changed the logon services , from .\administrator to local ... no resolution.
- I found that data source have no connection values as before.. so I said developer to re-deploy the data sources on report server. Actually the report server were able to access but when trying to access report the error was coming. but re-deploying of data source was wrong.
Then took a break just back to reporting server
configuration manager and rollback the logon services with .\administrator and
put the windows new password over there . Also re-set the password on execution
account setting . After that restart the SSRS report .. Reports get executed.

Thanks
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757