供应'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屋!