供应'PWA'：数据库供应失败。 [英] Provisioning 'PWA': Database provisioning failed.
问题描述
hai iam senthil kumar。帮我解决项目服务器2010中的以下错误
无法为站点PWA配置错误：Microsoft.Office.Project.Server.Administration.ProvisionException：无法配置数据库。 ---> System.Data.SqlClient.SqlException：找不到存储过程'sp_dboption'。
at System.Data.SqlClient.SqlConnection.OnError（SqlException exception，Boolean breakConnection）
在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning（TdsParserStateObject stateObj）
在System.Data.SqlClient.TdsParser.Run（RunBehavior runBehavior，SqlCommand cmdHandler，SqlDataReader dataStream，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj）
在System.Data.SqlClient.SqlCommand.FinishExecuteReader（SqlDataReader ds，RunBehavior runBehavior，String resetOptionsString）
在System.Data.SqlClient.SqlCommand.RunExecuteReaderTds（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，Boolean async）
在System.Data.SqlClient.SqlCommand.RunExecuteReader（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，String method，DbAsyncResult result）
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery（DbAsyncResult result，String methodName，Boolean sendToPipe）
在System.Data.SqlClient.SqlCommand.ExecuteNonQuery（）
在Microsoft.Office.Project.Server.Data.SqlSession.ExecuteNonQuery（SqlCommand命令）
在Microsoft.Office.Project.Server.Administration.ProjectDatabase.SetOption（SqlSession会话，字符串databaseName，字符串选项，布尔值）
在Microsoft.Office.Project.Server.Administration.ProjectDatabase.Provision（ProjectDatabaseType databaseType，PjSqlConnectionString databaseConnectString，String installpath，Int32 lcid，Dictionary`2 options）
在Microsoft.Office.Project.Server.Administration.ProjectDatabase.Provision（PjSqlConnectionString databaseConnectString，Int32 lcid，ProjectDatabaseType databaseType，Guid collectionGuid）
在Microsoft.Office.Project.Server.Administration.ProjectSite.ProvisionDatabases（String pubConn，String wrkConn，String verConn，String repConn，String adminUsername，String adminName，String adminEmail，Int32 lcid，Guid collectionGuid）
  在Microsoft.Office.Project.Server.Administration.PsiServiceApplication.EnsureDatabases（ProjectProvisionSettings provset，SPSite pwaSite，String adminName，String adminEmail，ProjectDatabaseStateType& originalDatabaseState，Guid& adminGuid）
---内部异常堆栈跟踪结束---
在Microsoft.Office.Project.Server.Administration.PsiServiceApplication.EnsureDatabases（ProjectProvisionSettings provset，SPSite pwaSite，String adminName，String adminEmail，ProjectDatabaseStateType& originalDatabaseState，Guid& adminGuid）
在Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite（ProjectProvisionSettings provset）
你好 -
您是否尝试在修补程序部署后运行配置向导？您是否尝试在SQL Server 2012上安装PS2010 / SP2010？如果是，请参阅以下文章：
$
http ：//msdn.microsoft.com/en-us/library/hh231665（v = sql.110）.aspx
http://www.gokanozcifci.be/subsite/how-to-install-sql-server-2012-for -sharepoint-2010.html
$
您能提供更多详情吗？
谢谢，
hai iam senthil kumar. help me with this following error in project server 2010
Failed to provision site PWA with error: Microsoft.Office.Project.Server.Administration.ProvisionException: Failed to provision databases. ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'sp_dboption'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Office.Project.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)
at Microsoft.Office.Project.Server.Administration.ProjectDatabase.SetOption(SqlSession session, String databaseName, String option, Boolean value)
at Microsoft.Office.Project.Server.Administration.ProjectDatabase.Provision(ProjectDatabaseType databaseType, PjSqlConnectionString databaseConnectString, String installpath, Int32 lcid, Dictionary`2 options)
at Microsoft.Office.Project.Server.Administration.ProjectDatabase.Provision(PjSqlConnectionString databaseConnectString, Int32 lcid, ProjectDatabaseType databaseType, Guid collectionGuid)
at Microsoft.Office.Project.Server.Administration.ProjectSite.ProvisionDatabases(String pubConn, String wrkConn, String verConn, String repConn, String adminUsername, String adminName, String adminEmail, Int32 lcid, Guid collectionGuid)
at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.EnsureDatabases(ProjectProvisionSettings provset, SPSite pwaSite, String adminName, String adminEmail, ProjectDatabaseStateType& originalDatabaseState, Guid& adminGuid)
--- End of inner exception stack trace ---
at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.EnsureDatabases(ProjectProvisionSettings provset, SPSite pwaSite, String adminName, String adminEmail, ProjectDatabaseStateType& originalDatabaseState, Guid& adminGuid)
at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)
Hi there--
Were you trying to run the configuration wizard after the patch deployment? Are you trying to install the PS2010/SP2010 on SQL server 2012? IF yes, Please see below article:
http://msdn.microsoft.com/en-us/library/hh231665(v=sql.110).aspx
http://www.gokanozcifci.be/subsite/how-to-install-sql-server-2012-for-sharepoint-2010.html
Could you please provide more details?Thanks,
这篇关于供应'PWA'：数据库供应失败。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
