This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 95%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Hello,
I need to change the account or the password for the SfB 2015 reports service account.
I thought I could do this as described e.g. here:
https://itgala.xyz/cannot-impersonate-user-for-data-source-cdrdb-rserrorimpersonatinguser/
But when I go to my reports-URL I get only file-listings. I am missing the menu on top to edit permissions or create new sources.
The reporting itself is working fine for years but when I change the domain admin password I get
"Cannot impersonate user for data source ‘CDRDB’. (rsErrorImpersonatingUser) error".
Where else could I set that password or better: change it to a real service account in AD?
thanx.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 24%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Welcome to our Q&A forum!
Could you provide the screenshot of your menu on Skype for Business report?
Based on my research, it seems you need to change the service account in AD firstly, so could you check if you have this service account in Active Directory.
Hi,
screenshot above.
Please note the missing menu on top of the screen.
By clicking on "Reports Home Page" I am instantly forwarded to Skype Reports Homepage or, if I changed the AD Admin password, get that error:"An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source ‘CDRDB’. (rsErrorImpersonatingUser)
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)"
If i change back the admin password I can view the reports as usual.
So I do not need to change anything in AD, I exactly ran into this problem described here:
https://itgala.xyz/cannot-impersonate-user-for-data-source-cdrdb-rserrorimpersonatinguser/
But cannot use the solution because I am missing the mentioned menu.
Thanks for your update. I will check this document steps and test in our environment. If there is any update, I will inform you in time.
Here is our Monitor service homepage in our environment：
And it seems the homepage is not the same as the blog talking about.
Thank you for your investigation - but the screenshot you posted is not the one we need.
You posted the situation when SfB reporting is available and you are already INSIDE these reports. This is working in our environment, too - until I do the needed password-reset of the domain admin account.
The blog post I mentioned gives the advise on how to CHANGE the account or/and the password for the SfB-report viewer. This is done via SQL server reports homepage.
But it seems that under normal circumstances these SQL server report services homepage is not really configured during standard installation of SfB reporting so I am still missing an opportunity to change the password for the user which was initially configured to have the rights to operate SfB reports homepage.
Is there any update on this?
It is a bit weird to always change back domain admin passwd to an old one which is known as "broken" just to troubleshoot SfB cases (and you know: there are always a lot of)
Thnx - Chris
Sorry for the delay response!
I just find we did not install the SQL Server Reporting Services in our environment so we cannot access the link. I will install it and if there is any news, I will inform you in time.
Here is our report service page and it is the same as yours
And when we follow this blog's steps to click the reports_content -> CDRDB, it will show like this：
Yes, the same to me.
The question remains:
HOW can I change the user-password used by the SfB-Reportsviewer?
(The blog I mentioned gives ONE solution, which solution is the Microsoft default if the 3rd party hint is not working?)
At present, we did not find any related official document talking about how to change the Sfb-Reportviewer password.
Maybe you could try to change the credential password from here.
Thank you for your reply,
But the account you mention is the service-account and not the account used by the webservice to request and build the reports.
In my environment the service you are ponting to is used by an account named "NT Service\ReportServer$Monitor" - this is not the domain admin account which is the initial problem.
So there is no official way to change this account or its password? I cannot believe...
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 1%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
EDIT: Editing this with an update after playing about with this a bit more I noticed there are 2 separate links for the report server with a link listed for reporting, the "Web Service URL" and "Report Manager URL". If you use the link in the "Web Service URL" section it will lead to the result of not being able to edit the database. If you use the "Report Manager URL" it will load the report Server as expected and allowing editing of the Credentials. I can only surmise that I created the admin account and clicked on this option during my testing making me think it need to be local admin. Have since confirmed its working on domain accounts as well when going through this method.
I know this is an Old thread but I ran into the same issue as mentioned in the thread.
Based on my checks it looks like you need to log in with a local administrator account for the page to load and allow sign into the database as described the linked article .
For clarity mine is running in Native mode which may have made the difference. I tested by creating a brand new local admin account and it was able to load correctly. Domain account's don't seem to allow access without further configuration
@Christian Reichhoff I don't know if you even use SfB 2015 any longer but in the event you do give that a try.
