Problem:
Recently I faced a problem while installing with ReportingInstaller for Microsfot Commerece Server 2009 R2, parameters like data warehouse server and Report Server url were correct but when I clicked "Test Connection" I got error message that :
"The Reporting Server "http://localhost/ReportServer" is invalid."
Solution:
I googled for it, but didn't find any solution. What I did , I tested the url I was trying to hit in browser, then it returned me error that :"The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing"
Then I googled for it and found that we have to add user in the ReportServer configuration, and by following command you can add user :
rsconfig -c -s < SQLSERVERNAME > -d reportserver -a Windows -u < MYDOMAIN\MYACCOUNT > -p < PASSWORD >orrsconfig -c -m < REMOTECOMPUTERNAME > -s < SQLSERVERNAME > -d reportserver -a SQL -u SA -p < SAPASSWORD >It worked for me nicely!!
Hope it help someone else..!! :-)
No comments:
Post a Comment