配置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)

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