Ошибка открытия приложения ms crm

[Camena]

Добрый день!

После удаления отношения "многие ко многим" и последующей публикации одной из кастомных сущностей перестало открывать приложение MS CRM. Выдается следующая ошибка:

[InvalidOperationException: Для ExecuteNonQuery нужно открытое и доступное подключение. Подключение закрыто.]
System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) +925120
System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) +9
System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +99
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +75
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) +75
Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) +120
Microsoft.Crm.CrmDbConnection.SetTransactionIsolationLevel(IsolationLevel il) +87
Microsoft.Crm.CrmDbConnection.Close() +90
Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId) +304
Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId) +50
Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context) +168
Microsoft.Crm.Metadata.DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context) +355
Microsoft.Crm.Metadata.MetadataCache.LoadCache(IOrganizationContext context) +312
Microsoft.Crm.Metadata.MetadataCache.GetInstance(IOrganizationContext context) +286
Microsoft.Crm.BusinessEntities.BusinessEntityMoniker..ctor(Guid id, String entityName, Guid organizationId) +115
Microsoft.Crm.Caching.UserDataCacheLoader.LoadCacheData(Guid key, ExecutionContext context) +296
Microsoft.Crm.Caching.ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context) +389
Microsoft.Crm.Caching.BasicCrmCache`2.CreateEntry(TKey key, IOrganizationContext context) +82
Microsoft.Crm.Caching.BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context) +108
Microsoft.Crm.BusinessEntities.SecurityLibrary.GetUserInfoInternal(WindowsIdentity identity, IOrganizationContext context, UserAuth& userInfo) +313
Microsoft.Crm.BusinessEntities.SecurityLibrary.GetCallerAndBusinessGuidsFromThread(WindowsIdentity identity, Guid organizationId) +194
Microsoft.Crm.Authentication.CrmWindowsIdentity..ctor(WindowsIdentity innerIdentity, Boolean publishCrmUser, Guid organizationId) +252
Microsoft.Crm.Authentication.WindowAuthenticationProviderBase.Authenticate(HttpApplication application) +502
Microsoft.Crm.Authentication.AuthenticationStep.Authenticate(HttpApplication application) +125
Microsoft.Crm.Authentication.AuthenticationPipeline.Authenticate(HttpApplication application) +66
Microsoft.Crm.Authentication.AuthenticationEngine.Execute(Object sender, EventArgs e) +475
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

В чем может быть причина и как лечить?

[slivka_83]

https://community.dynamics.com/blogs...nts/38531.aspx
http://blogs.msdn.com/b/emeadcrmsupp...onnection.aspx
http://www.irfansaeed.net/2009/05/er...ew-crm-40.html
http://www.nlsky.co.cc/?p=527
http://www.experts-exchange.com/Micr..._24471394.html

[Camena]

Проблема оказалась сокрыта в таблице Privilege, при попытке ее открытия выскакивает ошибка:

Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x1b99f3d3; actual: 0x4e5668fb). It occurred during a read of page (1:616) in database ID 9 at offset 0x000000004d0000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\org1101_MSCRM.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

Вобщем что-то слетело. Не знаю, можно ли это починить...

[slivka_83]

У Вас вроде что-то с файлом базы данных... может вирус покоцал
Как и следует из ошибки нужно проверить ее целостность: http://msdn.microsoft.com/ru-ru/library/ms176064.aspx

Бэкапы только не забудьте