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