1. 服务器环境拓扑:
拓扑
2. 现状分析:由于公司需求,需要在MOSS中显示一个汇总报表 ,但数据都存储在其他业务系统中,所以需要先从业务数据库中提取数据到SQL server2005中,然后把需要手工输入的数据也读取到SQL中,由Reporting Service自动生成报表,通过Reporting Service的外接程序显示在MOSS中。
 
3. 故障现象:在SQL server 2005服务器中使用Microsoft Office SharePoint server SP1安装好WEB前端后,安装基于MOSS的Reporting Service外接程序报错。如下图:
故障图 4. 解决方案
通过Google搜索到得解决方案为:
Problem:
Event Type:     Error
Event Source:     Windows Sharepoint Services 3
Event Category: Topology
EventID:     5617
Date:          
03.25.2008
Time:         
20:45:34
User:          
N/A
Computer:  MOSS Server
Description: 
The schema version (3.0.149.0) of the database SharePoint_AdminContent_0015a5e2-8907-416d-8672-940a68c2c431 on Database Server is not consistent with the expected database schema version (3.1.3.0) on MOSS Server. Connections to this database from this server have been blocked to avoid data loss. Upgrade the web front end or the content database to ensure that these versions match
Solution:
"stsadm -o upgrade -inplace -url http://{central_admin_url}/"
example., stsadm –o upgrade –inplace –url [url]http://mossserver:17492/[/url]
经过尝试,提示【未将对象引用设置到对象的实例】,看来此药不对此证。
仔细琢磨错误描述,又Google N次后,无意来到这个页面: [url]http://www.mindsharpblogs.com/penny/articles/481.aspx[/url]
Using SharePoint Central Administration Web site SharePoint HTML Site Settings admin pages or IIS Manager, on the web sites properties HTTP Headers tab, virtual servers once extended will show the following version numbers: 
    MOSS 20071 or WSS 3.0 Cumulative update (KB956056 & KB956057)  12.0.0.6327
    MOSS 20071 or WSS 3.0 Infrastructure Update ( KB951695 & KB951297)  12.0.0.6318
    MOSS 20071 or WSS 3.0 post-SP1 hotfix ( KB948945)      12.0.0.6303
    MOSS 20071 or WSS 3.0 post-SP1 hotfix ( KB941274)      12.0.0.6301
    MOSS 20071 or WSS 3.0 post-SP1 hotfix ( KB941422)      12.0.0.6300
    MOSS 20071 or WSS 3.0 SP1   12.0.0.6219
    MOSS 20071 or WSS 3.0 October public update 12.0.0.6039
    MOSS 20071 or WSS 3.0 August 24, 2007 hotfix package 12.0.0.6036 
    MOSS 20071 or WSS 3.0 RTM                                        12.0.0.4518 
    MOSS 20071 or WSS 3.0 Beta 2 TR:                               12.0.0.4407 
    MOSS 20071 or WSS 3.0 Beta 2:                                    12.0.0.4017 
    Office 12 (PDC p_w_picpath - pre-beta):      12.0.0.3111 (This version of Office does not have a support link in the Add/Remove programs dialog box).
1To confirm that a particular service pack is install on SharePoint Server you must either check the version numbers of specific dlls as specified in the related Microsoft Knowledge Based article or select the Show Updates check box in Add and Remove Programs.
    WSS 2.0 SP3                                    6.0.2.8165 
    WSS 2.0 SP2 KB900929 + KB924881 6.0.2.8117
    WSS 2.0 SP2 rollup KB900929           6.0.2.8000
    WSS 2.0 SP2                                    6.0.2.6568
    WSS 2.0 SP2 Beta = R2:                   6.0.2.6551 
    WSS 2.0 SP1 + KB887981                6.0.2.6411
    WSS 2.0 SP1:                                  6.0.2.6361 
    WSS 2.0 Unservice packed:               6.0.2.5530
突然灵感闪现,想到是不是SQL服务器安装好web前端没打补丁导致的版本不一致。
于是立刻打开【SharePoint 管理中心】—【操作】—【服务器场中的服务器】,果然发现了问题所在。
PIC3E2F.tmp
OK,知道问题了,现在的要做的就是安装【KB956056 & KB956057】这两个KB了,赶紧down下来安装好。
注意:两个补丁都安装好之后再执行【产品和技术配置向导】,并且两台服务器都要进行向导。
补丁安装完后,再次查看服务器版本。
2版本一致,之后安装【SharePointRS_x64 for SQL 2005 SP3.msi】外接程序就正常没有报错了。安装成功在控制面板中可以看到
p_w_picpath
注:外接程序需要安装在MOSS服务器上,SQL server服务器虽然可以安装,并且Reporting Service服务也可以正常配置,但在MOSS管理中心中没有Reporting Service相关选项。
 
5. 总结
在多服务器部署MOSS的时候,特别是需要把MOSS的不同角色部署到不同服务器上时,要保证多台服务器上MOSS版本的一致性,不然就会出现相关问题。