我试图发现服务端点.../XRMServices/2011/Organization.svc
,但我遇到了以下错误:
出现错误
请重试此操作。如果问题仍然存在,请查看Microsoft Dynamics CRM社区以获取解决方案,或与组织的Microsoft Dynamics CRM管理员联系。最后,您可以联系Microsoft支持部门。系统。NullReferenceException:对象引用未设置为对象的实例。在微软。Crm。主应用程序。Application_Error(对象发送器,EventArgs事件参数)
堆栈跟踪:
Error Description:
Generic SQL error.
Error Details:
Generic SQL error.
Full Stack:
[SqlException: Cannot open database "ASPState" requested by the login. The login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.]
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo, TimeSpan retryInterval)
[HttpException: Unable to connect to SQL Server session database.]
at System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection conn, Exception e)
at System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo, TimeSpan retryInterval)
at System.Web.SessionState.SqlSessionStateStore.GetConnection(String id, Boolean& usePooling)
at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext context, String id, Boolean getExclusive, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags)
at System.Web.SessionState.SqlSessionStateStore.GetItemExclusive(HttpContext context, String id, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags)
at System.Web.SessionState.SessionStateModule.GetSessionStateItem()
at System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData)
at System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
什么可能导致问题,CRM有什么问题?
由于您使用的是NETWORK SERVICE,因此需要确保将Web服务器的计算机帐户添加到Active Directory中的SQLAccessGroup中。通常情况下,这是在CRM设置期间为您完成的,但如果您想稍后更改帐户,您必须记住手动将新帐户添加到此组。这里有一个描述CRM使用的不同组的链接:
http://ayazahmad.wordpress.com/2007/01/26/active-directory-security-groups-for-mscrm/
当用户没有分配角色时,我看到了类似的消息,但这发生在测试环境中,仍然值得检查。
我完全重新安装了开发堆栈,同样的情况再次发生,我重新安装了我的虚拟机,它工作了,似乎是一些未知的问题。现在,我将尝试在虚拟机的新实例上重现相同的错误。
感谢所有)
我在CRM服务器上也看到了这条消息。我所做的只是在IIS上启用和禁用匿名身份验证,这对我来说很有效。我还玩过web.config、服务设置,但后来我恢复了第一次安装CRM时的部分。
在我的评论中,IIS并没有告诉WCF如何进行身份验证,以及几次冷重启,以及启用和禁用匿名身份验证。唤醒WCF。
您的AppPool需要是一个可以访问数据库的用户。
关于WCF服务,检查您的IIS网站身份验证设置,对于需要的WCF服务
- 匿名身份验证已启用
- ASP。NET模拟已启用
- Windows身份验证已启用
用于在AD环境中运行的内部部署安装。我们也遇到了这个问题,并且在重新启动IIS后得到了解决。