Failed to redeployment CRM organization

Failed to redeployment CRM organization and get the error message:


13:02:20
Error
Import Organization (Name=LeumiCim, Id=782be048-dde4-df11-968c-00145ebd47b6) failed with Exception:

System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)

at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)

at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)

at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)

at Microsoft.Crm.CrmDbConnection.SetTransactionIsolationLevel(IsolationLevel il)

at Microsoft.Crm.CrmDbConnection.Dispose(Boolean disposing)

at Microsoft.Crm.SqlExecutionContext.Dispose(Boolean disposing)

at Microsoft.Crm.SqlExecutionContext.Dispose()

at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, String privilegedUserGroupName, String sqlAccessGroupName, String userGroupName, String reportingGroupName, String privilegedReportingGroupName, ICollection`1 users, MultipleTenancy multipleTenancy)



After check this error I got that the problem is missing temporary database for reporting service.

Reporting services contain 2 databases:

1. ReportServer

2. ReportServerTempDB

By mistake the database ReportServerTempDB.

To return the temporary database open "Report server Configuration"

.select "database setup" and press "New"

This option creates the temp database after this process try to run again the redeployment tools.



Thanks,

Rami Heleg

How to create a new organization/ import organization and prevent from insert report service URL…?

Everyone know to create/import organization must insert report URL.


We can prevent insert the report URL and of course success to create organization …

How to do that….?


Add the IgnoreChecks registry key to the computer that is running Microsoft Dynamics CRM 4.
 click Run, type regedit, and then click OK.
In the registry, locate the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
Right-click MSCRM, point to New, click DWORD Value, and then type IgnoreChecks.  + set Value 1.
Sceen shots:

Thanks,
Rami Heleg

Failed to install CRM 4.0

Failed to install CRM 4.0.

Failed to install CRM 4.0 and get error message
"the account specified to run the microsoft dynamics crm asynchronous processing service does not have performance counter permissions..."

in Microsoft Dynamics CRM Setup windows.

The reasons can be:
installer must be local admin.
define CRM to run CRM in a user which is not local admin. ( enable to view this data after install in iis - application pool)

Thanks,
Rami Heleg