Visual Studio AX SSRS Report Error

Finance and Operations/AX Technical Forum
1

Hey everyone,

Recently, AX was migrated onto a new server with a different address. I’m getting the following error messages after I open AX SSRS reports in VS. These errors still contain the old AX server address. Does anyone know where it has to be updated?

======================
Error 3 Could not connect to net.tcp://server1:8201/DynamicsAx/Services/UserSessionService. The connection attempt lasted for a time span of 00:00:01.0046644. TCP error code 10061: No connection could be made because the target machine actively refused it 192.168.11.111:8201. C:\Program Files (x86)\MSBuild\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling.targets 103 6 Invoices

Error 4 The “GenerateRdlTask” task failed unexpectedly.
Microsoft.Dynamics.AX.Framework.Services.Client.UserSessionServiceException: Could not connect to net.tcp://server1:8201/DynamicsAx/Services/UserSessionService. The connection attempt lasted for a time span of 00:00:01.0046644. TCP error code 10061: No connection could be made because the target machine actively refused it 192.168.11.111:8201. —> System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://axapp01:8201/DynamicsAx/Services/UserSessionService. The connection attempt lasted for a time span of 00:00:01.0046644. TCP error code 10061: No connection could be made because the target machine actively refused it 192.168.11.111:8201. —> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 192.168.11.111:8201
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
— End of inner exception stack trace —

Server stack trace:
at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)

at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

Thanks

2

Moving your post to AX forum for faster response.

3

Just an update.

Parameters on the following form already point to the new server. System Administrator >Setup > Business Intelligence > Reporting services > Report server.

4

Hi,

When you have multiple instances of Dynamics AX installed,the Visual Studio identifies the instance to connect from the client configuration. The active client configuration is used to establish the connection. So make sure your active one is pointing to your new server.

Regards,

Raghav.

5

Turns out local config file that I was using still had several old pointers to the old server (I used a notepad to check contents). This file was probably an edited version of a previous config file. I created and exported a new one and now it seems to be working. Also, I made sure that the old server was taken out and replaced with the new one in the Config Utility.

I’m using exported config files to quickly connect to different environments with VS. I made separate shortcuts that point to different config files.