Last post Feb 15, 2012 03:18 PM by chingfong2001
Feb 14, 2012 02:38 PM|chingfong2001|LINK
Hi, Would appreciate if any input on this error......
I am using sql 2008 r2 with enterprise ssrs. the report server is not local and it 's name is "myServer".
I am able to run the reports on BI application. However, when I run the reports under web site,
I get this error:
Feb 14, 2012 03:16 PM|b471code3|LINK
In your SSRS report make sure you have your dataset connection string make sure you define a username and password so the report knows how to connect otherwise I believe it uses the IIS process username to try to connect.
Feb 14, 2012 03:32 PM|chingfong2001|LINK
Thanks for the reply. Userid and password do not resolve the error issue.
Feb 14, 2012 04:06 PM|b471code3|LINK
Then do as the error states and enable remote errors or the simpler thing to do would be to log into the server hosting the website and run the application to see what the detailed error is. Probably give you exactly what you need to fix the problem.
Feb 14, 2012 05:37 PM|chingfong2001|LINK
Thanks for the suggestion. The issue here is report server and sql db is on server 1 while the web site is on server 2. Do you know any
web.config parameter set up? Have set up the server path and server name.
Feb 14, 2012 09:18 PM|b471code3|LINK
Thats fine, go to server 2 and it should display the error for you. Can always look at the server event logs and/or the SQL logs as well.
Feb 14, 2012 11:41 PM|Srikanth Kasturi|LINK
Are you passing the credentials to the report via the code on your application ?
Please check with that once..
Just in Case :
reportViewer.ServerReport.ReportServerUrl = new System.Uri(ConfigurationManager.AppSettings["ReportServerURL"]);
reportViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
reportViewer.ToolBarItemBorderColor = System.Drawing.Color.PowderBlue;
reportViewer.ToolBarItemBorderStyle = BorderStyle.Double;
string strUserName = ConfigurationManager.AppSettings["UserName"].ToString();
string strPassword = ConfigurationManager.AppSettings["Password"].ToString();
string strDomain = ConfigurationManager.AppSettings["Domain"].ToString();
reportViewer.ServerReport.ReportServerCredentials = new ReportCredentials(strUserName, strPassword, strDomain);
string strReport = string.Empty;
strReport = ConfigurationManager.AppSettings["ReportsFolder"] + Request.QueryString["ReportName"].ToString();
Feb 15, 2012 02:09 PM|chingfong2001|LINK
Thanks for your suggestion. I have
on the form:
on the code behind:
donot need credential at this point since this is a test server. Somehow when it gets to the report server, it does not recognise the login and password calling from the web server. How do you pass the necessary information to the report server?
Feb 15, 2012 02:32 PM|b471code3|LINK
I'm guessing what
Srikanth Kasturi is saying is doesn't matter if you are on test or not, specify those credentials and it should work.
You are dealing with 2 different accounts (and you need both):
Feb 15, 2012 03:18 PM|chingfong2001|LINK
Thanks all. Resolve this after modify the access right on sql server to allow this machine to access the db.