SSRS report error in AX 2012

[Aman Nain]

I am trying to create a basic SSRS report in Visual Studio 2010 with
AX 2012. I want to display basic CustTable data. When i link the
dataset with the query CustTableSRS (a query in AOT), i get an error.
The error says,

A call to SSPI failed, see inner exception.

This doesnt happen if i do the same steps in AX 2009 with Visual
Studio 2008. On googling, i found that this has something to do with
"misconfigured SPN". SPN is Server Principal Name, a name given to a
server instance in a Kerboros environment. But i am not able to set it
right. I am using AX2012 image running on Oracle VirtualBox.

Error log in Visual Studio

Error 3 The "GenerateRdlTask" task failed unexpectedly.
Microsoft.Dynamics.AX.Framework.Services.Client.UserSessionServiceException:
A call to SSPI failed, see inner exception. --->
System.ServiceModel.Security.SecurityNegotiationException: A call to
SSPI failed, see inner exception. --->
System.Security.Authentication.AuthenticationException: A call to SSPI
failed, see inner exception. --->
System.ComponentModel.Win32Exception: The target principal name is
incorrect
--- End of inner exception stack trace ---
at
System.Net.Security.NegoState.StartSendAuthResetSignal(LazyAsyncResult
lazyResult, Byte[] message, Exception exception)
at System.Net.Security.NegoState.StartSendBlob(Byte[] message,
LazyAsyncResult lazyResult)
at
System.Net.Security.NegoState.CheckCompletionBeforeNextSend(Byte[]
message, LazyAsyncResult lazyResult)
at System.Net.Security.NegoState.ProcessReceivedBlob(Byte[]
message, LazyAsyncResult lazyResult)
at System.Net.Security.NegoState.StartReceiveBlob(LazyAsyncResult
lazyResult)
at
System.Net.Security.NegoState.CheckCompletionBeforeNextReceive(LazyAsyncResult
lazyResult)
at System.Net.Security.NegoState.StartSendBlob(Byte[] message,
LazyAsyncResult lazyResult)
at
System.Net.Security.NegoState.CheckCompletionBeforeNextSend(Byte[]
message, LazyAsyncResult lazyResult)
at System.Net.Security.NegoState.ProcessReceivedBlob(Byte[]
message, LazyAsyncResult lazyResult)
at System.Net.Security.NegoState.StartReceiveBlob(LazyAsyncResult
lazyResult)
at
System.Net.Security.NegoState.CheckCompletionBeforeNextReceive(LazyAsyncResult
lazyResult)
at System.Net.Security.NegoState.StartSendBlob(Byte[] message,
LazyAsyncResult lazyResult)
at
System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult
lazyResult)
at
System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential
credential, ChannelBinding binding, String targetName, ProtectionLevel
requiredProtectionLevel, TokenImpersonationLevel
allowedImpersonationLevel)
at
System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential
credential, String targetName, ProtectionLevel
requiredProtectionLevel, TokenImpersonationLevel
allowedImpersonationLevel)
at
System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream
stream, SecurityMessageProperty& remoteSecurity)
--- End of inner exception stack trace ---

Server stack trace:
at
System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream
stream, SecurityMessageProperty& remoteSecurity)
at
System.ServiceModel.Channels.StreamSecurityUpgradeInitiatorBase.InitiateUpgrade(Stream
stream)
at
System.ServiceModel.Channels.ConnectionUpgradeHelper.InitiateUpgrade(StreamUpgradeInitiator
upgradeInitiator, IConnection& connection, ClientFramingDecoder
decoder, IDefaultCommunicationTimeouts defaultTimeouts, TimeoutHelper&
timeoutHelper)
at
System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.SendPreamble(IConnection
connection, ArraySegment`1 preamble, TimeoutHelper& timeoutHelper)
at
System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.DuplexConnectionPoolHelper.AcceptPooledConnection(IConnection
connection, TimeoutHelper& timeoutHelper)
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)
at System.ServiceModel.

[abhi.bh...@gmail.com]

hey hi Aman,

I am also getting the same error while opening SSRS report .Have you found any solution for this.
If yes , plz share it bcoz i am struckd badly bcoz of this error

[carth...@gmail.com]

Do you got any solution?

[aaro...@gmail.com]

By any chance has anyone been able to understand the root cause of this issue?
thanks.

[prem...@gmail.com]

I have the same error showing up on Dynamics AX 2012 R3 installation. Was anyone able to get a solution for this?

[deva...@gmail.com]

Hi Aman Nain,

Maybe you much first check the setup datetime/regional machine all your servers have the same/sincron..

Regards,
Toms

[deva...@gmail.com]

Hi, Abhishek Bhati,

You much check your time/regional machnine in your server, the Time on all server must be the same as Time in Active Directory.

hopefully helpful.. :)

Regards,
Thoms

[deva...@gmail.com]

Hi Aman Nain,

Maybe you much first check the setup datetime/regional machine all your servers have the same/sincron with time in your active directory..

hopefully helpful.. :)

Regards,
Toms