The attempt to connect to the report server failed.Check Your connection information and that the reportserver is a compatible version

Question

1.11/5 (2 votes)

See more:

Hi,

I have created the .rdl file in visualstudio 2008.Its working fine and deployed these report in Reportserver Manager.I have checked the report in ReportManager locally.That's also absolutely working.I am calling these report from .aspx page.The code looks like below

 protected void Report()
    {
        string strPath = string.Empty;

        ServerReport serverRptObj = rptTransactions.ServerReport;
        serverRptObj.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServer"]);

        ReportParameter rptParamObj = new ReportParameter();
        rptParamObj.Name = "Date";
        rptParamObj.Values.Add(strDate);

        strPath = "/Online/Trans Report";
        serverRptObj.ReportPath = strPath;
        rptTransactions.ServerReport.Refresh();
        rptTransactions.ServerReport.SetParameters(new ReportParameter[] { rptParamObj });
}

It's showing the error for me "The attempt to connect to the report server failed.Check Your connection information and that the reportserver is a compatible version".How to fix this issue.Can anyone help regarding this?(*****Please don't delete my question(it's my humble request')***********************)

Posted 26-Mar-13 11:20am

priya9826

Add a Solution

Comments

Richard C Bishop 26-Mar-13 17:22pm

Can you post the "ReportServer" part of your code you have in your web.config file?

priya9826 26-Mar-13 17:24pm

Sabarish Mahalingam 16-Jul-15 7:08am

rptDisplay.ServerReport.ReportServerCredentials = new MyReportServerCredentials();

priya9826 26-Mar-13 17:24pm

[no name] 26-Mar-13 18:11pm

The error is pretty obvious isn't it? Check that you are connecting to the report server that you deployed your report to and makes sure that you have a compatible version.

priya9826 27-Mar-13 9:48am

How to check the version?I am developing the report(.rdl) file in VS 2008 and deploying the report in Reports server configuration manager.Developing the .aspx page in VS 2010.Can you please give more details?

[no name] 27-Mar-13 11:04am

And when you went and looked at the version of SQL Server that you are using, what did you find?

priya9826 27-Mar-13 13:01pm

It's a credential issue.The issue got resolved.Thank u very much.

Rahul prasad Yadav 30-Mar-15 3:50am

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sai sagar · Answer 1 · 2013-07-01T23:14:00

Solution 1

Try

Check your IIS first

Then

1. Go to Reporting Services Configuration Connection
2. Start services with the instance of your SQL Server
3. Go to Report Manager URL assign role for your user windows to

If eveything you check can work. you can deploy your reports

Posted 1-Jul-13 23:14pm

sai sagar

Skip-Sailors · Answer 2 · 2016-02-12T07:29:00

Solution 3

I got this behavior when I made a type in the rssrvpolicy.config file. When I corrected the typo, the server started working.

Posted 12-Feb-16 7:29am

Skip-Sailors