crexin

Retrieve User and Password for CRM Custom Reports in SSRS

Apr 25th, 2019
345
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.34 KB | None | 0 0
  1. /*
  2. https://support.microsoft.com/en-sg/help/2006869/cannot-create-a-connection-to-data-source-crm-error-occurs-when-you-ru
  3. Here username should be systemuserid and password should be organizationid when running a SQL based custom report on a Report Server.
  4. */
  5.  
  6. SELECT fullname, systemuserid, organizationid FROM FilteredSystemUser ORDER BY FullName
Advertisement
Add Comment
Please, Sign In to add comment