CRM Errors : Login failed for user

If you get errors like this, you have to add user to sql who log on as service account  or

  • You install Microsoft Dynamics CRM in a multiple-server environment. Then, you install Microsoft Dynamics CRM directly on a server that is running Microsoft SQL Server. However, some SQL Server permissions are not set.
  •   The Microsoft Dynamics CRM server is not added to the SQLAccessGroup group in the Active Directory directory service.
  • Application Pool identity was set to the Built-in Account in the Advanced Settings of App pool, instead change it to one of the user account which has access to Database.

 

  • Error in LoadDeploymentSettings [Cannot open database “MSCRM_CONFIG” requested by the login. The login failed.
  • Error in LoadSiteWideSettings [Cannot open database “MSCRM_CONFIG” requested by the login. The login failed.
  • The type initializer for ‘Microsoft.Crm.Monitoring.MonitoringSettings’ threw an exception. System.Data.SqlClient.SqlException: Cannot open database “MSCRM_CONFIG” requested by the login. The login failed.

 

Monitoring runtime failed: Machine: CRMKitchen:
Exception: SmokeTests failed with exception :
System.TypeInitializationException:
The type initializer for ‘Microsoft.Crm.Monitoring.MonitoringSettings’ threw an exception. —> System.Data.SqlClient.SqlException: Cannot open database “MSCRM_CONFIG” requested by the login. The login failed.
Login failed for user ‘CRMKitchen\CRMService’.

 

CrmTrace encountered an error. Additional Info:Error in LoadSiteWideSettings [Cannot open database “MSCRM_CONFIG” requested by the login. The login failed.
Login failed for user ‘CRMKitchen\CRMService’.], Stack Trace : at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at Microsoft.Crm.CrmTraceSettings.Load(String traceDirectory)
at Microsoft.Crm.CrmTrace.get_RefreshTrace()
at Microsoft.Crm.CrmTrace.Write(Guid orgId, TraceCategory traceCategory, TraceLevel traceLevel, Int32 skipFrames, String format, Object[] args)
at Microsoft.Crm.CrmTrace.TraceFormat(Guid orgId, TraceCategory traceCategory, TraceLevel traceLevel, String format, Object[] args)
at Microsoft.Crm.CrmTrace.Initialize()
at Microsoft.Crm.Asynchronous.AsyncService.StartServiceComponents(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch(), Inner Exception: , Data: System.Collections.ListDictionaryInternal (Reporting Process:CrmAsyncService, AppDomain:C:\PROGRA~1\MICROS~4\Server\bin\)

 

More info  :

https://support.microsoft.com/en-us/kb/946286

http://mscrmtechie.blogspot.com.tr/2015/07/login-failed-for-user-domain-servername_23.html

Read More

CRM Reporting Extensions Setup Error : The SQL Server Reporting Services account is a local user and is not supported

The SQL Server Reporting Services account is a local user and is not supported

reporting-setup-error

If you get an error when trying to install Microsoft Dynamics CRM Reporting Extensions (SetupSrsDataConnector). You have to change service account on Reporting Services Configuration Manager.

  1. Open the Reporting Services Configuration Manager
  2. Change the Service Account to Network Service.
  3. While changing account it will ask you “Backup Encryption Key”
  4. Type your pass and locate file.
  5. Then you can continue to setup Reporting Extensions.

 

More info :

https://msdn.microsoft.com/en-us/library/ms160340.aspx

https://mscrmonline.wordpress.com/2012/07/31/microsoft-crm-2011-and-sql-server-2012-support/

SQL Server Reporting Services Account is a local user and is not supported – Error installing SrsDataConnector

Read More

The issuer of the security token was not recognized by the IssuerNameRegistry. To accept security tokens from this issuer, configure the IssuerNameRegistry to return a valid name for this issuer

If you get an error like this, you have to update federation metedata url and iisreset then restart adfs service.  Normally CRM throws a generic error and I found this message from trace.

The issuer of the security token was not recognized by the IssuerNameRegistry. To accept security tokens from this issuer, configure the IssuerNameRegistry to return a valid name for this issuer

unexpected-error-crm

  1. Open Deployment Manager on CRM Server
  2. Configure Claims Based Authentication from wizard
  3. Click start menu, select run and type iisreset to complete.
  4. Then go to Services on ADFS Server and restart ADFS Service.

 

Reference : https://support.microsoft.com/en-us/kb/2686840

http://www.dynamicscrmpros.com/microsoft-dynamics-crm-error-the-issuer-of-the-security-token-was-not-recognized-by-the-issuernameregistry-solved/

Read More

HTTP Error 403.14 : The Web server is configured to not list the contents of this directory

When you publish your web site on IIS , you may get an error like this.

HTTP Error 403.14 – Forbidden
The Web server is configured to not list the contents of this directory.

Resolution 1 : Check your Application Pool’s .NET Framework version !

When you add a new web site without default application pool, IIS set default .NET Framework 2 version for your site. So you have to change your application pool’s framework version.

  1. Open IIS Manager
  2. Go to application pools
  3. Select your app pool and click basic settings to configure.

application pool iss manager

Resolution 2 : Edit your web.config file

keep this into your web config file then rename the add value=”yourwebformname.aspx”

or

source : http://stackoverflow.com/questions/18981118/http-error-403-14-forbidden-the-web-server-is-configured-to-not-list-the-con

Resolution 3 : Enable the Directory Browsing feature in IIS

  1. Go to IIS Manager. (If you dont know to do this, click Start, click Run, type inetmgr.exe, and then click OK.)
  2. In IIS Manager find your Web sites, and then click the website that you want to modify.
  3. In the Features view, double-click Directory Browsing.
  4. In the Actions pane, click Enable.

Resolution 4 : Add a default document

  1. Start IIS Manager. To do this, click Start, click Run, type inetmgr.exe, and then click OK.
  2. In IIS Manager, expand server name, expand Web sites, and then click the website that you want to modify.
  3. In the Features view, double-click Default Document.
  4. In the Actions pane, click Enable.
  5. In the File Name box, type the name of the default document, and then click OK.

Resolution 5 : Enable the Directory Browsing feature in IIS Express

Note This method is for the web developers who experience the issue when they use IIS Express.

To do this, follow these steps:
Open a command prompt, and then go to the IIS Express folder on your computer. For example, go to the following folder in a command prompt:
C:\Program Files\IIS Express
Type the following command, and then press Enter:
appcmd set config /section:directoryBrowse /enabled:true
For more information about the appcmd command, view How to use AppCmd.exe.

source : https://support.microsoft.com/en-us/kb/942062

Read More

Unable to start CRM Email Router Service

When you try to start the MS CRM E-mail Router Service in Microsoft Dynamics CRM Backend Server, you get an error like

The Microsoft CRM Email Router service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

 

This problem occurs because the Microsoft.Crm.Tools.EmailAgent.SystemState.xml file is corrupted.

  1. Delete the Microsoft.Crm.Tools.EmailAgent.SystemState.xml file.

    C:\Program Files\Microsoft CRM Email\Service\Microsoft.Crm.Tools.EmailAgent.SystemState.xml

  2. Restart the Microsoft Dynamics CRM E-mail Router Service.

 

More info : https://support.microsoft.com/en-us/kb/954522

Read More

CRM Deploy Error : Assembly must be registered in isolation

When you trying to deploy plugins, if you get an Assembly must be registered in isolation error. You are not a Deployment administrator on CRM Organization. After the deployment administrator must add you as deployment administrator, you can deploy / register a plugin.

Open the Deployment Manager

First of all you must be a Dynamics CRM deployment admin to access the Dynamics CRM Deployment Manager and change the Dynamics CRM URLs. If you dont have access to privileges, you can tell your administrator.

crm acces denied

 

 

Open the User Panel from Deployment Adminstrators

Right click the deployment adminstrators then click the New Deployment Adminstrator.crm deployment

 

Add a New Deployment Administrator

You can add the user who you want from Active Directory.

deployment crm microsoft

Register and Deploy Plugins

https://msdn.microsoft.com/en-us/library/gg309620.aspx

Read More

CRM 2013 Tips : How to fix Access Denied Error ?

When you write javascript oData if you get an Access denied error. You have to change Web Addresses from Deployment Manager.

Open the Deployment Manager

First of all you must be a Dynamics CRM deployment admin to access the Dynamics CRM Deployment Manager and change the Dynamics CRM URLs. If you dont have access to privileges, you can tell your administrator.

crm acces denied

 

 

Open the Properties

crm access denied

 

Change Web Addresses

You have to change all 4 CRM URLs to the full FQN CRM URL (Full Qualify Domain Name).

crm access denied deployment

 

More info : http://www.dynamicscrmpros.com/microsoft-dynamics-crm-2011-access-denied-error-resolved/

 

Read More

How to fix Assembly does not have a strong name for CRM ?

Referenced assembly XXX does not have a strong name.

These errors are taken in the following steps : 

  • Deployment with CRM Package
    CRM Assembly Build

 

  • Register the Plugin with Plugin Registration Tool

CRM Strong Name Signing

 

How to Sign an Assembly in Visual Studio ?

  • With the project node selected in Solution Explorer, from the Projectmenu, click Properties(or right-click the project node in Solution Explorer, and click Properties)

CRM Strong Name Signing

  • In the Project Designer, click the Signing tab
  • Select the Sign the assembly check box

CRM Strong Name Signing

  • Specify a new key file. In the Choose a strong name key file drop-down list, select New… Note that new key files are always created in the .pfx format.The Create Strong Name Dialog appears.
  • In the Create Strong Name Key dialog box, enter a name and password for the new key file, and then click OK

More info : https://msdn.microsoft.com/en-us/library/ms247123(v=vs.90).aspx

 

Why Strong Name is required for CRM Projects ?

https://social.microsoft.com/Forums/en-US/01de0856-e7a6-429b-b150-cca174eefb28/why-strong-name-key-is-required-for-plugin-in-ms-crm-40?forum=crmdevelopment

 

We recommend you that read in a very detail post on Hosk’s Dynamic CRM Blog

https://crmbusiness.wordpress.com/2014/10/01/assembly-generation-failed-referenced-assembly-does-not-have-a-strong-name/

 

Read More

Dynamics CRM 2013 Developer Toolkit for Visual Studio 2013

 

Normally there is no CRM Developer Toolkit installation file for Visual Studio 2013. But you can install it with some customization.

s2

  • Firstly Download the installation files.
  • Open Visual Studio folder and Run Microsoft.CrmDeveloperTools.vsix file
  • s3
  • Run the crmSDKFix.reg file
  • Copy contents of the CRM MSBuild folder to “C:\Program Files\MSBuild\Microsoft\CRM” or “C:\Program Files (x86)\MSBuild\Microsoft\CRM”
  • If there is no CRM folder in MSBuild folder, you can create this CRM folder.
  • Now open Visual Studio and you can create CRM Toolkit Project.

Read More