Mark Minasi's Tech Forum
Register Calendar Latest Topics Chat
 
 
 


Reply
  Author   Comment  
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 202
Reply with quote  #1 

Using SSDTs   (SQL Server Data Tools 2012)  I was working on a new SSRS report for an Dynamics CRM 2015 online instance.

I use a Microsoft Dynamics CRM Fetch EMBEDDED TYPE  of connection.
The string for the data resource is also embedded instead of Shared.   Since it was CRM 2015 online update 1, the "URL/organization name still allows me to make a connection.  This changes in CRM 2016 online.

I use the organization login for the credentials.     For the unacquainted, if you opened a trial with O365 and CRM you would authenticate via the organization login. 
Say for instance the O365/CRM online instance was called MRND.crm.dynamics.com
And your the admin called Mark.   You login name by default would be Mark@MRND.onmicrosoft.com  and then your password. 
FYI:  You can get to the login page via https://portal.office.com

So back on track:
This morning I received  the following error:

 

 

 

The security timestamp is invalid because its creation time ('2016-03-17T13:43:02.550Z') is in the future.

Time? Hmm!!!!!   I look to the south east corner of the screen and not the time.   Then I look at the time on my cell phone.   Well, five min. difference.   I remembered errors from working in a domain.  But this machine I have my dev environment on is not part of a domain and I did not have a external time reference (Shame on me).   So I was 5 min plus out of sync.
I synced the time on my Dev station 
 Changed the time with a quick net stop w32time and net start w32time at the CMD prompt, and checked to see if the time service was in sync.   
I got back into SSDT and checked the Report data area.   My data source had authenticated and my Fetchxml code had rendered the fields of the CRM entity I was querying.

No reboot required.

As we continue to move into using cloud resources, I hope this helps when you have to do SSRS and SSIS packages while connecting to a cloud resource.

 

 




 


__________________
Curt Spanburgh
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation: