ProjectServer2010+SharepointServer2010 错误
环境为:win2008R2+sqlserver2008R2+project server2010+sharepoint server2010
按照文档操作,当创建PWA时 日志报如下错误,如果一切正常,会看到状态为“已提供”
设置“PWA”: 未能设置数据库。出现异常: Failed to grant login on primary server.。
设置“PWA”: 未能授予登录主服务器上的“ERPUCC\Administrator”的权限。
日志名称: Application
来源: Microsoft-SharePoint Products-Project Server
日期: 2012/12/1 19:39:11
事件 ID: 6971
任务类别: 设置
级别: 错误
关键字:
用户: ERPUCC\Administrator
计算机: WIN-9PL98AEOT2C.erpucc.com
描述:
未能设置网站 PWA,出现错误: Microsoft.Office.Project.Server.Administration.ProvisionException: Failed to provision databases. ---> Microsoft.Office.Project.Server.Administration.ProvisionException: Failed to get schema version of Published database - Data Source=WIN-9PL98AEOT2C\MSSQLSERVER2008;Initial Catalog=ProjectServer_Published
在 Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CheckDatabaseVersion(String dbName, Version verBuild, String strConn, String guid)
在 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)
事件 Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint Products-Project Server" Guid="{B2178104-1B5B-4C20-8C8F-960678CED9E5}" />
<EventID>6971</EventID>
<Version>14</Version>
<Level>2</Level>
<Task>20</Task>
<Opcode>0</Opcode>
<Keywords>0x4000000000000000</Keywords>
<TimeCreated SystemTime="2012-12-01T11:39:11.578125000Z" />
<EventRecordID>9483</EventRecordID>
<Correlation ActivityID="{0DEBD1FB-1A24-4FB9-BE7C-A280106BB7BD}" />
<Execution ProcessID="2612" ThreadID="4608" />
<Channel>Application</Channel>
<Computer>WIN-9PL98AEOT2C.erpucc.com</Computer>
<Security UserID="S-1-5-21-882539310-63186765-1390247964-500" />
</System>
<EventData>
<Data Name="string0">PWA</Data>
<Data Name="string1">Microsoft.Office.Project.Server.Administration.ProvisionException: Failed to provision databases. ---> Microsoft.Office.Project.Server.Administration.ProvisionException: Failed to get schema version of Published database - Data Source=WIN-9PL98AEOT2C\MSSQLSERVER2008;Initial Catalog=ProjectServer_Published
在 Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CheckDatabaseVersion(String dbName, Version verBuild, String strConn, String guid)
在 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)</Data>
</EventData>
</Event>
---------------------------------------------------------------------------------------------------------------------------------------------
解决流程:
1、我先偿试搜索是否有补丁,结果没有找到
2、由于明确提到没有权限的问题,我偿试对IIS及数据的权限检查了一下,无果。
3、问题比较糢糊的是,数据文件可以恢复到数据库中,但是却给出 “未能授予登录主服务器上的“ERPUCC\Administrator”的权限”
4、我顺便查看一下恢复的数据库字符集。
sp_helpdb
--select DATABASEPROPERTYEX( 'dbname ', 'Collation ')
select DATABASEPROPERTYEX( 'ProjectServer_Published ', 'Collation ')
输出:Chinese_PRC_CI_AS
--修改数据库字符集
alter database DBName collate Chinese_PRC_CI_AS
5、我偿试更改 msqlserver服务的启动方式为 域\\用户名 ,本次具体为 erpucc\administrator ,由于之前安装 project server与sharepoit server 计算机是加入域的,并且在安全选项--》用户,删除本机系统验证用户 计算机名\\administrator ,再次添加一个 erpucc\administrator ,并且在用户指定 server roles为sysadmin,再次配制sharepoint server-->应用程序管理--》管理服务应用程序--》Project Server Service App-->创建Project web app网站,至次成功。