配置Secure Store Service以访问Excel Service 2010


??Secure Store Service???Excel Service 2010

 [??:?????????? ,  Office/Project????, ????????????? ]

SharePoint  Server  2010????????????,?????????????????????????????????????????????? (Information Worker)?????Office???????????????????Office???????????,??Office Web App??????????????????????????(?????????,???????),?????????????,????Office????????????????

 

????Office Web App?,Excel Service???????? SharePoint Server 2007???????,?????????????SharePoint Server 2010?Excel Service??????????,?????????SharePoint Server???(??Project Server?Team Foundation Server?)????Excel Service?????????????????????????,?????????Excel Service(??Secure Store Service)??????????????????,????????????????Excel????????????????????????Excel???

 

??Excel Service?????????,???????????????????,????Excel Service???????,?????????(???????????????????????)????????Secure Store Service???Excel Service 2010?????,??????IT?????????

 

????????

 1.       AD?????projdataaccess??,???????db_datareader??,??:

 

2.       AD????????report viewers group?

3.       AD????????report authors group(????????)?

 

??SharePoint????

 

?????Excel Calculation Service???Secure Store Service?

1.       ????SharePoint????-> ????->??????????

 

2.       ??Excel Calculation Service,????????,??????

3.       ?”Secure Store Service,????????,??????

 

 

??Excel Service????

 1.       ??????????-> ????????,??????Excel Services????,??????????????Excel Services????,??????->Excel Services?????

 

2.       ??????,???????????(???????????)???????????

3.       ????????,????????????(?????,???????????)?

 

 

??Secure Store Service

 

???????Secure Store Service,????????Secure Store Service???????????????????(???????“???+DB+ ??GUID”)?

 

??????????,????Secure Store Services->?????????->SharePoint Web Services Default?

 

??State Service

 

?????

 

????????????Web????

 

??????????????Web????????,?????SharePoint????->??????->???????????????:

 

???????:

 

???????,???Excel Service?????Secure Store Service?????????

 

??Secure Store Service

 1.       ????????????,??Secure Store Service????,?????

 

2.       ???????,?????????,???????????Secure Store Service?????

 

3.       ??????????,?????

4.       ????????????????

 

5.       ??????????ID????????????????????:

 

6.       ??????

7.       ??????????ID???????????Windows??,????????????:Windows????Windows?????????,??????

 8.       ????????????????????v9\report viewers group??????????

?:????????????????????????????????

????????????????????????,????????????????

9.       ????,???????????????????????????????,???????

 

10.   ????,????????report viewers group,???????,????,?????????????????????????????????,v9\projdataaccess???????,report viewers group??v9\projdataaccess????????????????

 

11.   ??????,Secure Store Service???????

 

??Excel Service????????

 

?????Excel Service???Excel??????????(?????SQL Server???),?????????1-3????Excel????????????,????????

 1.       ????

a.       ????????????

b.      ??Excel Service????->?????

c.       ??????,??????ID,?????????ExcelServiceTest,???????

 2.       ???????

a.       ??Excel Service????->????????

b.      ????????????

c.       ??Excel????????????,????????????????????????????

d.      ???????

3.       ????????

a.       ??Excel Service????->?????????

b.      ??????????????

c.       ???????????,??????

 4.       ?Excel?????SharePoint???

 a.       ?????????????????????????

b.      ??Excel,??????????????

c.       ?????????????????,?????

d.      ????????????,???????????

e.      ?????????????????,?????????

f.        ??SSS,??SSS ID,??????ExcelServiceTest,??????

g.       ?????

h.      ????????,???SharePoint???????(?????????????)? 

i.        ?????

 

????!

 

??????????report viewers group????,?????????????????report viewers group????????????Excel???,?????:

 

 

????

 

Excel Services ?? (SharePoint Server 2010)

http://technet.microsoft.com/zh-cn/library/ee424405.aspx

 

Excel Services ??????

http://technet.microsoft.com/zh-cn/library/ff604006.aspx

 

?? Excel Services ????????

http://technet.microsoft.com/zh-cn/library/ff604007.aspx

 

?? Excel Services ???? (SharePoint Server 2010)

http://technet.microsoft.com/zh-cn/library/ee662541.aspx#section4

 

?? Project Server 2010 ??(??Excel Service 2010)

http://technet.microsoft.com/zh-cn/library/ee662106.aspx

 

 

 

 

Comments (0)

Skip to main content