Wednesday, 19 September 2018

SharePoint Online Share URL "Anyone" Grayed Out




Following steps allows you to enable “Anyone” option for Guest Contributor

1) Run PowerShell as Administrator

   Should be installed with latest version SharePoint Online Management Shell

2) To Connect Online SharePoint the power shell

$adminUPN="<the full email address of a SharePoint administrator account, example: jdoe@contosotoycompany.onmicrosoft.com>"
$orgName="<name of your Office 365 organization, example: contosotoycompany>"
$userCredential = Get-Credential -UserName $adminUPN -Message "Type the password."

3) C:\Windows\system32>

Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential   (Sharepoint Admin URL)

4) C:\Windows\system32>

Result: ExternalUserSharingOnly

5) PS C:\Windows\system32>

Set-SPOSite -Identity https://Contoso.sharepoint.com/sites/TeamSite -SharingCapability ExternalUserAndGuestSharing

6) PS C:\Windows\system32> (Get-SPOSite -Identity 

https://Contoso.sharepoint.com/sites/TeamSite).SharingCapability

Result: ExternalUserAndGuestSharing







Now refresh the SharePoint Page and check for the Share link




Monday, 23 April 2018

Issue with the 'CRM 2013 Outlook Plugin' crash when you try to open it from Windows Start


Faulting application name: Microsoft.Crm.Application.Outlook.ConfigWizard.exe, version: 6.0.0.819, time stamp: 0x57a8f98f

Faulting module name: KERNELBASE.dll, version: 6.1.7601.24094, time stamp: 0x5abee073
Exception code: 0xe0434352
Fault offset: 0x0000c54f
Faulting process id: 0x2db4
Faulting application start time: 0x01d3dae0b2f11adb
Faulting application path: C:\Program Files (x86)\Microsoft Dynamics CRM\Client\ConfigWizard\Microsoft.Crm.Application.Outlook.ConfigWizard.exe
Faulting module path: C:\Windows\syswow64\KERNELBASE.dll
Report Id: f4a0ee1b-46d3-11e8-8e45-b083feb17d38


Resolution:


Resolve by replacing the value(C:\Program Files (x86)\MSCRM\Client\) of 'HKEY_CURRENT_USER\Software\Microsoft\MSCRMClient\InstallPath' in registery, with 'C:\Program Files (x86)\Microsoft Dynamics CRM\Client\'.


Reboot the PC once and try to open the putlook client.


For your info, I have installed the following updates on top of the 'Microsoft Dynamics CRM 2013 for Microsoft Office Outlook' 


- Service Pack 1 for Microsoft Dynamics CRM 2013 (KB2941390)


- Update Rollup 5 for Microsoft Dynamics CRM 2013 Service Pack 1 (KB3122951)

Wednesday, 18 April 2018

Dynamics 365 - SQL Server Custom Report run issue

Trace Log:

Webserver!ReportServer_0-10!187c!04/17/2018-05:26:11:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
Microsoft.Crm.CrmException: An unexpected error occurred.
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 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The target principal name is incorrect
   --- End of inner exception stack trace ---

Resolution:  

The error is due to a negotiate exception that is occurring with a fail to the SSPI.  Given the rsProcessingAborted and SSPI failure, we are looking at an SPN issue as none are registered under the domain account currently running the CRM AppPool. 

To check the list of spn's registered:
C:\>setspn -l <user running CRM app pool>

Run the following setspn commands on all CRM app servers which should resolve this reporting issue:

setspn -a HTTP/<CRM application server name> <user running CRM app pool>
setspn -a HTTP/<CRM application server FQDN> <user running CRM app pool>

Example:
setspn -a HTTP/CRM1 crmuser
setspn -a HTTP/CRM1.test.com test\crmuser

Do IIS reset and run the report.


Wednesday, 1 November 2017

How to Determine The Installed Update Dynamics 365 Version With SQL Query


SELECT UpgradeToVersionNumber

FROM [Yourdatabase_MSCRM].[dbo].[UpgradeActionTracker]

order by UpgradeToVersionNumber desc


















Google the build number.....


Wednesday, 20 September 2017

Error occurs when you install Microsoft Dynamics CRM App Server on a domain whose NetBIOS domain name contains a period (.)

Error | Installer complete: OrganizationCreator - Error encountered

Error | Exception occured during Microsoft.CRM.Tools.Admin.OrganizationCreator : Action Microsoft.crm.tools.Admin.provisionBusinessAction Failed.
Inner exception:
The domain logon for this user is invalid: (Domain\username).
Select another domain logon and try again.
At Microsoft.CRM.Authentication.UserManagementFactory.ValidateActiveDirectoryUser…

Error occurs when you install Microsoft Dynamics CRM App Server on a domain whose NetBIOS domain name contains a period (.)

Resolution : 

  1. Open Registry Editor.
  2. Browse to the following location: HKLM\Software\Microsoft
  3. Create the MSCRM registry key if it does not already exist.
  4. Browse to the following location: HKLM\Software\Microsoft\MSCRM
  5. Create a new DWORD type registry value, and then name the registry value VerifyDomainName.
  6. Set the datavalue of the VerifyDomainName value to 1
Restart the CRM app server and then try to re import.



Wednesday, 10 May 2017

Dynamics 365 (Online CRM) & Exchange online - Unable to track emails in Queue (Server side Synchronization)

In Case if CRM queues did not receive incoming (Track) emails from INTERNAL users and able to track outside users sent emails   without any problem.


1)     Navigate to SETTINGS –> ADMINISTRATION –>SYSTEM SETTINGS –> EMAIL, the box “Track emails
Sent between Dynamics 365 users as two activities” must be CHECKED
2)     Use the OrgDBOrgSettings tool and install it as a solution where it is called “OrganizationSettingsEditor”.
                                 
3)      After opening, look for the value DoNotIgnoreInternalEmailToQueues. The default is FALSE.  That must be changed to TRUE as the bottom text explains.
        As show in below screen shot…