无法获得XRMServices/2011/Organization.svc

Question

我试图发现服务端点.../XRMServices/2011/Organization.svc，并出现了以下错误：

发生了错误。

再试一次这个动作。如果问题继续存在，请查看Microsoft Dynamics社区以获得解决方案，或与组织的Microsoft Dynamics管理员联系。最后，您可以与Microsoft支持部门联系。

System.NullReferenceException:对象引用没有设置为对象的实例。在Microsoft.Crm.MainApplication.Application_Error(Object发件人，EventArgs eventArguments)

堆栈跟踪：

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 AUTHORITY\NETWORK 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有什么问题？

Answer 1

我完全重新安装了开发栈，同样的事情再次发生，我重新安装了我的虚拟机，它运行起来了，似乎是一些未知的问题。现在，我将尝试在虚拟机的新实例上复制相同的错误。

(感谢大家)

Answer 2

由于您正在使用网络服务，因此需要确保将the服务器的计算机帐户添加到Active中的SQLAccessGroup中。通常这是在CRM设置期间为您完成的，但是如果您以后想要更改帐户，您必须记住手动将新帐户添加到这个组中。下面是一个描述CRM使用的不同组的链接：

http://ayazahmad.wordpress.com/2007/01/26/active-directory-security-groups-for-mscrm/

Answer 3

当用户没有指定角色时，我看到了类似的消息，但这发生在测试环境中，仍然值得检查。