The attempt to connect to the report server failed

(1) Share

Report

Posted on by murtafiah

497

Why error, if I will open the report in AX 2012?

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

can you help me?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Murtafiah Via,

Can you check whether your report server is up and running?

Are you aware of any changes that have been made to the report server?

If it runs and you still get the error message can you try to restart it?

Would be great if you could check and let us know if this resolves your issue.

Ludwig

Was this reply helpful? Yes No
murtafiah 497 on at

Like (1)

Report

Hi Mr. Ludwig

I was try to restart it but can't work and stay error such as that..

any solution sir?

Regards,

Via

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Probably have a look at the following site and try to go through it with one of your System admins

social.msdn.microsoft.com/.../fix-to-the-attempt-to-connect-to-the-report-server-failed-check-your-connection-information

In addition, also take a look at this earlier thread that deals with a similar issue

community.dynamics.com/.../106761

Hope this helps,

Ludwig

Was this reply helpful? Yes No
murtafiah 497 on at

Like (1)

Report

Hi, Mr. Ludwig

I can't understand with that..

But, if I click validate setting in report server show error :

"Unable to connect to http://ID-SRV-DBA-V003/Reports for the report server at ID-SRV-DBA-V003. Make sure that SQL Server Reporting Services is configured correctly matching the report server configuration in the Microsoft Dynamics AX client."

why?

any solution?

Was this reply helpful? Yes No
Syed Shabab Mujtaba 278 on at

Like (0)

Report

Hi Murtafiah,

there are multiple places you have to check.1

login with admin id and check the report server configuration on SSRS report server.

check whether login id and password is successful(if anyone changed the admin password update it)

check in AX in Administrator module -> setup -> Reporting services-> check this setup should match with SSRS reporting server Web service URL and Report Manager URL.

Was this reply helpful? Yes No
murtafiah 497 on at

Like (0)

Report

Hi Mr. Syed,

when I go to it blank value, and check 2st was matching such as below :

Was this reply helpful? Yes No
Suggested answer

Syed Shabab Mujtaba 278 on at

Like (0)

Report

yes, you need to check the Reporting servers URL's copy and paste it on explorer whether it is opening for your id and paste those url's at the specific places in the Reporting server Parameters.

also check for the system service accounts in the AX. Business connector proxy alias should be same as admin of your SSRS reporting server.

Was this reply helpful? Yes No
murtafiah 497 on at

Like (1)

Report

Morning Mr. Syed,

When i click Validate settings menu show error such as below image :

Was this reply helpful? Yes No
Suggested answer

Syed Shabab Mujtaba 278 on at

Like (0)

Report

Hi Morning,

You should put all the parameters same as in SSRS reporting server and here in AX report server both should match. Also check for admin id or ssrs reporting server and AX business connector should match. check the below link will be helpful.

technet.microsoft.com/.../hh389764.aspx

Was this reply helpful? Yes No
Minh.Nguyen 19 on at

Like (0)

Report

Hi Murtafiah,

It seems the connection between your AOS server and DB/Reporting server was interrupted/ wrong configurations or maybe the software version is not compatible together.

Try to:

- Check the Microsoft Dynamics AX 2012 System Requirements and compare to your system.

- Restart all servers.

- Check the network connection of the DB/Reporting servers. The Reporting services must be running.

- Ping the DB/Reporting server from you AOS server and see the result (using CMD of Window).

If everything above is still ok, next,

- Check the Report servers configuration in your AX (System administration>Setup>Business intelligence>Reporting services>Report servers). Then click the button "Validate settings".

The URL of your Reporting services configuration in AX must be the same to the URL in the Reporting Services Configuration Manager (NOTE: add the PORT number if you have it in the Reporting server & select the right AOS server name if you have multi-AOS server). Or easier, just copy and past the URL into your Reporting services configuration in AX.

Was this reply helpful? Yes No