配置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)
https://technet.microsoft.com/zh-cn/library/ee424405.aspx
Excel Services ??????
https://technet.microsoft.com/zh-cn/library/ff604006.aspx
?? Excel Services ????????
https://technet.microsoft.com/zh-cn/library/ff604007.aspx
?? Excel Services ???? (SharePoint Server 2010)
https://technet.microsoft.com/zh-cn/library/ee662541.aspx#section4
?? Project Server 2010 ??(??Excel Service 2010)