PowerPivot on SharePoint 2010

PowerPivot on SharePoint 2010 are useful, but SharePoint must be "Server Farm" version. because standalone version couldn't add PowerPivot farm into SP2010.
view document :  PowerPivot for SharePoint – Existing Farm Installation
and this : http://msdn.microsoft.com/en-us/library/ee210616.aspx
and this: http://msdn.microsoft.com/en-us/library/ee210708.aspx

7/20 update. I created a document to know how to use Powerpivot and how to post pivot chart on SharePoint, document on Google Drive. Name is "Power Pivot for Excel and SharePoint"

prefix on IP setting

Prefix size	Network mask	Available subnets	Usable hosts per subnet	Total usable hosts
/24	255.255.255.0	1	254	254
/25	255.255.255.128	2	126	252
/26	255.255.255.192	4	62	248
/27	255.255.255.224	8	30	240
/28	255.255.255.240	16	14	224
/29	255.255.255.248	32	6	192
/30	255.255.255.252	64	2	128
/31	255.255.255.254	128	2 *	256

Cancel pending on Symantec backup Exec

Copy From : http://www.symantec.com/business/support/index?page=content&id=TECH87507

Problem

When trying to cancel an active backup job, the status shows as "Cancel Pending" for a long period of time and may appear to be hung

Cause

When trying to cancel an active job, the job status may show as "Cancel Pending" (see image below) for a long period of time.  Note that the time takes to cancel a running job varies depends on the activities run before the cancelling.  The cancelling job will stay in "Cancel Pending" until the activities timeout before the job terminated completely.  If the job stay in "Cancel Pending" for excessively long period of time, it may appear hung with the following reasons:

• Backup exec services not responding.
• Process of cancellation stuck,and process still running.
• Eg. Common behavior of applications when hung due to slow system performance .
• Respond time of the process or service with the Operating System.

Solution

WARNING / NOTES:

• Job needs to  be cancled manualy.
• This method will cancel ALL jobs that are currently running.

STEPS:

 In the Backup Exec Console-
1. Click on "Tools" > " Backup Exec Services" to open the servicesmgr.exe2. Click on "Restart all services" (In most cases, this process will get to the bengine service and appear hung)
3. Open Windows task manager and click on the "Processes" tab
4. Enable "Show Processes from all users"
5. Click on the "Image Name" column to sort alphabetically
6. Locate and highlight the following services .

• Pvlsvr.exe(Backup  exec device and media service)
• Beengine.exe(Backup exec job engine service)
• Beremote.exe(backup exec Remote Agent for Windows Server service)

7.Right Click on the above services in order and click on "End Process Tree" to terminate this process.

8.Close the task manager and return to the services manager

9.After the services are terminated in Windows-

10."Restart all services" process in the services manager should continue and complete.

Once this has completed, Open Backup Exec console and the backup job that was hung will no longer show in the active jobs.

Check the  Job history below.The cancled job will be displayed with the Error RPC services were restarted by user .No action required.

How to Manage Administrator Permissions on My Sites

Get from RyanT ( http://blogs.syrinx.com/blogs/sharepoint/archive/2007/10/19/how-to-manage-administrator-permissions-on-my-sites.aspx )

How to Manage Administrator Permissions on My Sites

A number of our clients have been confused by the concept of SharePoint 2007 My Sites because of some of the perceived and legitimate architectural difference between the My Site Web Application and traditional Web Applications created by administrators for use in portals and standard Site Collections.

This article will not dive into all differences between a My Site Web Application and other Web Applications, but will merely show you how can assure your ability to administer and manage individual My Sites, or the entire My Site Web Application by giving administration rights to those users and groups that need it.

Manage users via the entire Web Application

If you want to give user or group access to the entire My Site Web Application, you can do this the same way you would with a traditional Web Application via the following steps:

1. Go to SharePoint Central Administration -->Application Management

2. Choose "Policy for Web Application" under the "Application Security" group.

3. Make sure you select the correct Web Application for your My Site in the "Web Application" drop down list on the right.

4. Select "Add Users" on the upper left.

5. Choose "All Zones" by default on the "Add Users" screen and click "Next".

6. Add the appropriate user(s) or Active Directory group that you want to have control over your My Site Web Application.  Select the level of control. Click "Finish".

These users should now have appropriate access to all My Sites in the Web Application. Administrator groups given "Full Control" can now browse to individual My Sites and should see the "Site Actions" button to make administration available.

Manage individual My Site administrators via Central Administration

A lot of people don't realize that every My Site is an individual Site Collection, not just a Site or Web. For the purpose of this article, it makes sense to architect My Sites like this from an administration perspective because Site Collections represent the top level for user permissions and management. This methodology allows individual My Site owners to manage the permissions of their own My Site without requiring assistance or requests from the SharePoint administrators.

To add a specific user or Active Directory group to an individual My Site from Central Administration, follow these steps:

1. Go to SharePoint Central Administration -->  Application Management

2. Click "Site Collection Administrators" under the "SharePoint Site Management" group.

3. Make sure you select the correct Site Collection for your My Site in the "Site Collection" drop down list on the right.

4. The "Primary Site Administrator" is most likely the user that owns the My Site.

5. You can add a user or Active Directory group as the "Secondary site collection administrator" in the box below the primary admin.  Click "OK".

Using this method you can use Central Administration to assign administration rights to specific My Sites.

Manage user permissions via the individual My Site

You can also manage permissions on any My Site where you already have Site Collection Administration access by navigating directly to the specific My Site.  Central Administration access is not required.

1. Navigate directly to any My Site where you already have administration access and go to "Site Settings" via the "Site Actions" button.  If you don't see the "Site Actions" button and cannot navigate to: /personal//_layouts/settings.aspx">http://<web_application>/personal/<user_name>/_layouts/settings.aspxthen you do not have administration or "Full Control" permissions on this Site Collection.

2.From "Site Settings" select "Site collection administrators" from the "Users and Permissions" group on the left-hand side.

3. The "Site Collection Administrators" link allows you to create additional users or groups with Site Collection Administration permissions on this My Site.  Simply add the users or Active Directory groups and click "OK".

Although beyond the scope of this article, if you select "People and Groups" instead of "Site collection administrators" in step #3, you can manage more granular permissions on the My Site as you can with any traditional Site Collection. You can also assign individual users or groups specific permissions on list or list items within your My Site.

How to update site collection quota and lock

作者：jiania |出處：博客園| 2011/12/22 13:19:19 |閱讀43次

出至 http://www.haogongju.net/art/1138698

我們在創建網站集的時候，在頁面的最後一項，有一個“配額模板”的選項，通過它可以設置該網站集的容量大小。默認有兩種選擇“無配額”及“個人模板”。

除了創建網站集的時候進行限制外，默認情況下，對於每個用戶的個人站點是使用“個人模板”進行限制的，每個個人網站限制為100M。

一、創建配額模板

在“管理中心”的“應用程序管理”頁面，點擊“SharePoint網站管理”下的“配額模板”。

在“模板名稱”處，默認選擇的是“編輯現有模板”，可以通過下拉菜單選擇現有模板進行修改。也可以選擇“新建配額模板”創建一個新的。

在“存儲限制值”處，分別填入相關數字即可。

二、修改網站集配額

在“管理中心”的“應用程序管理”頁面，點擊“SharePoint網站管理”下的“網站集配額和鎖定”。

在“網站集”處可以選擇要設置的網站集。

“網站鎖定信息”可以對選擇的網站集的狀態進行設定。

在“網站配額信息”處，可以選擇一個配額模板。如果網站空間已經有使用過的，還會在最下面顯示一行“當前所用的存儲空間”來告訴你已經使用了多少。

三、個人網站配額設置

在存儲個人網站的網站集中，還可以單獨對每一個個人網站進行配額的限制。這樣方便我們的設置。例如老闆的個人網站就可以放寬一些限制了，哈哈。

在“網站集配額和設定”頁面，點擊“網站集”後面的小箭頭，點擊“更改網站集”。

在“選擇網站集”頁麵點擊“更改Web應用程序”

選擇存放個人網站的網站集，這裡選擇“SharePoint - 9000”。

返回後可以看到左邊的“URL”下面會列出目前存在的個人網站。選擇一個需要修改的，例如“/personal/ynzf ”。

在“網站配置信息”中，可以選擇相應的配額模板或者自定義配額的大小。

注：配額限制的大小，有時候會出現超過存儲空間限制的情況。例如限制了100M的大小。你先上傳一個80M的文件，因為沒有超過限制，還可以繼續上傳，上傳的文件如果超過了限制大小也可以，例如你還可以繼續上傳一個80M的文件。當超過限制後就無法再繼續操作了

how to integrate the report service into SharePoint 2010

Report Service 可以整合進 SharePoint 2010. 因此 user 可在不同的site執行已經定義好的報表.例如我可以在sales的site執行跟sales 有關的報表且該報表受site permission管理.
設定如下:
1. 開啟 reporting services configuration manager
2. 進入 Database -> Change database -> select "sharepoint Integrated Mode" and DB Name is RS_SharePoint
3. RS will created a DB under SQL\MSSQLSERVER ( default instant name)
4. open Central Administrator by admin
5. select "General Application Setting -> Report Service Integration
6. set "report server web service URL to http://servername:80/reportserver and use "windows authentication"
7. SharePoint will auto configurate, sometime we need manually to turn on ( activate) Report service
8. click "Site Action" -> site setting
9. select "Site Collection features" under "Site Collection Administration" and active "Report Server Integration Feature" & "Report Server Central Administration Feature"
10. upload .rdl to document
11. right click this rdl to open setting.
12. run this report on SP

主內的弟兄 Eddit & Stella

二月時,我們就知道Stella 來日不多,但是依然見她燦爛的笑容在虛弱的身體上.因此她說她希望組個詩班在復活節時獻唱.我們就義不容辭的參加這個詩班.在此期間的周日她都教導我們如何獻唱
雖然她已不太容易站立.復活節後她就沒來教會了.今天Jimmy 告訴我說她大概快進天家了.讓我十分感傷.一方面是朋友的離去另方面是敬佩她對主的愛.讓她如此的奉獻.
同樣的我也看到Stella 的先生 Eddit 為 Stella 的付出.這幾個月他每周一開車帶 Stella 到 LA看中醫.並且當天來回. 70多歲的人除了愛之外我想不出還有任何力量能支持12小時的車程.
在此為文紀念她!!
Stella, 我們愛你,主也愛你.
5/14/2012: Stella 於5/7/2012蒙主恩召回到天國,5/6/2012 主日,他們全家在教會獻詩並於晚間共餐.5/18/2012舉行葬禮火化.