All about Branch Distribution Points on SCCM 2007

Recently I came across many issues related to "Branch Distribution Points" on SCCM 2007 and was on a search for more documentation on BDP. I hereby sharing my search results which might be beneficial for my future search as well for others.

• Carol Bailey on TechNet blog has documented some most valuable information about BDP: 

FAQs for Branch Distribution Points: 
http://blogs.technet.com/b/wemd_ua_-_sms_writing_team/archive/2008/07/27/faqs-for-branch-distribution-points.aspx

• TechNet Article by PaddyMaddy

DP VS Secondary Site VS BDP - In SCCM 2007 vs SCCM 2012
http://social.technet.microsoft.com/wiki/contents/articles/5292.dp-vs-secondary-site-vs-bdp-in-sccm-2007-vs-sccm-2012.aspx

• Carlos Santiago on TechNet blog has given additional information on Refreshing vs Updating a package on BDP: 

How do we refresh a package located on a Branch Distribution Point?

http://blogs.technet.com/b/carlossantiago/archive/2008/05/16/how-do-we-refresh-a-package-located-on-a-branch-distribution-point.aspx 

Other Useful TechNet articles about BDP:

Choose Between a Standard and Branch Distribution Point
http://technet.microsoft.com/en-us/library/bb932184.aspx 

About On-Demand Package Distribution
http://technet.microsoft.com/en-us/library/bb632582.aspx 

How to Prestage Packages on a Branch Distribution Point
http://technet.microsoft.com/en-us/library/bb681046.aspx 

SCCM Reporting - "SELECT permission was denied on the object"

Sharing you my experience on resolving the SELECT permission error while running a SCCM Web Report. 

Sometimes SCCM may throw an error while running a new report on Web Browser. The same report may work just fine on the SQL server reporting console, but not on web browser.

Detailed error on "Select permission" that appears on the Web browser:
The SELECT permission was denied on the object 'xxxxxxxxx', database 'SMS_ABC', schema 'dbo'.
Error Number: -2147217911
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 229  

I then referred to some online articles for troubleshooting and solved the issue by adding the SELECT permissions for the SQL View on SQL server.

Added below the resolution snapshots for your reference:

Step 1 - SELECT permission error on SCCM Report

Step 2 - View properties - adding permission

Step 3 - Browse and add Database role "smsschm_user"

Step 4 - Choose Select permission for smsschm_user

Step 5 - Add "webreport_approle" and choose Select permission

Step 6 - SCCM Web Report works fine