Disclaimer . . .

We DO NOT host or upload any of the videos or any other content that are available on this Weblog. We merely search on INTERNET and index popular files/links to other blogs /videos openly available to anyone. The most popular websites are YOUTUBE videos. These videos and other content are uploaded to the respective websites by their User Communities from all over the World and NOT by us. Please Contact Us through E-Mail, if you feel that any Content including Videos on this Weblog are objectionable or violating your copyrights. The objectionable content shall be promptly removed from our Weblog.


Jul 4, 2009

Customize your sharepoint site using Sample master pages

Source
************

http://office.microsoft.com/en-us/sharepointdesigner/HA102223711033.aspx

Download the sample master pages from the below location ,

http://www.microsoft.com/downloads/details.aspx?FamilyID=7C05CA44-869A-463B-84D7-57B053711A96&displaylang=en

Instructions
***************************
To install this download:

***************************

1. Run MasterPage.exe to unpack the master page package to a location on your computer.
2. Right click on the extracted file, MasterPageExamples.zip and select "Extract All..."
3. Complete the Extraction Wizard.
4. Open your Windows SharePoint Service 3.0 site in Microsoft Office SharePoint Designer 2007.
1. Open SharePoint Designer.
2. On the File menu, click Open Site.
3. In the Open Site dialog box, type the URL of the site that you want to open in the Site name box, and then click Open.
5. Import the master page files into your site.
1. On the File menu, select Import > File...
2. In the Import dialog box, select Add Folder...
3. Browse to location of the extracted master page files, and then browse to a specific master page set.
4. Select the "_catalogs" folder and click Open.
5. Repeat steps 2-4 for the "images" folder and the "styles" folder.
6. Click Ok to finish importing the files.

Instructions for use:
***********************************

To set the imported master page as the default master page:

1. Open the Folder List. On the Task Panes menu, select Folder List.
2. On the Folder List, within the _catalogs folder, open the masterpage folder.
3. In the master page folder, find the master page style and color you want to apply, right-click on the file and then click "Set as Default Master Page" on the shortcut menu.

Please refer to the Microsoft Office SharePoint Designer Master Pages site for additional help and how-to articles that cover the use of master pages.

To remove this download:
*********************************

* Delete the package and uncompressed files from your computer.

Jul 3, 2009

Reporting Services GUI Configuration

Reporting Services GUI Configuration with WSS 3.0 / MOSS
****************************************************************


http://blogs.msdn.com/sharepointbi/archive/2009/05/29/ssrs-integrated-mode-with-sharepoint-and-report-builder-2-0.aspx

http://www.helloitsliam.com/archive/2007/10/23/moss2007-%E2%80%93-reporting-services-general-ui-configuration.aspx



Key words
------------

SSRS with sharepoint ,

Configure Excel Services

http://technet.microsoft.com/en-us/library/cc263517.aspx



http://msdn.microsoft.com/en-us/library/ms496823.aspx



http://msdn.microsoft.com/en-us/library/cc514223.aspx#MOSS2007TenTips_QuickTipsforCommonExcelServicesIssues

Jun 28, 2009

SharePoint IIS Traffic Analysis


SharePoint IIS Traffic Analysis

SharePoint IIS Traffic Analysis
***************************************

Internally we have experienced situations where internal users have built tools or solutions which have negatively affected performance for our SharePoint users. This can be done in different ways such as Setting up multiple MOSS Farms to crawl our customer facing front ends at high performance setting or creating a custom application to execute against various MOSS web services without throttling the application in any way. From that need spawned a little tool we created with the help of log parser J The following is an example of how you could setup a scheduled task to notify you on number of Hits against your moss environments and how much bandwidth each user is consuming.



Please remember to never perform any of the following on production without first trying it out in a test environment, all items here are merely examples of how you ‘could’ perform such an action. J



Skills and Items required / assumed to perform this task.

· A SQL 2005 server with XP_CMDSHELL enabled

· Read Permissions for SQL Server Account Granted to the IIS Log directory of your SharePoint Servers

· Access to create and modify databases on your SQL Server

· Logparser 2.2 Installed on your SQL Server

· Good Understanding of SQL Server and TSQL

· Good Understanding of IIS

· Access to all customer Facing SharePoint Front Ends

· Good Understanding of SharePoint J





Step 1: Create a reporting database on your SQL Server, for the benefit of this blog entry we will call this database IISReports. Set that reporting database to autogrow for the data file and log file.



Step 2: Grant read permissions to all IIS log directories where your Web application Logs are stored on all servers you wish to report on.

Example: %WINDIR%\System32\Logfiles\ex080218.log For better performance internally we place our IIS Log files on a serperate drive



Step 3: Install Logparser 2.2 to a directory on your sql server(make note of this directory) For the purpose of this entry we will call this c:\temp\logparser.exe

Logparser 2.2 can be downloaded @ http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx



Step 4: Create Tables that we will use to pull in and manipulate the data

Click Here to open example Script

Step 5: execute the Create script for the stored procedure that will be used to pull the data.

Click Here to Open example Script – Make sure to read the /**notes**/ as they direct you to make changes to the script to cater to your environment.

Step 6: If everything has been followed and updated accordingly you can now run the following in SQL.. shortly there after you will receive an email similar to the following J



use [IISReports]

go

exec IISLogtracking

go

Configure Kerberos authentication (Office SharePoint Server)

Other useful articles
*************************
http://blogs.msdn.com/martinkearn/archive/2007/04/23/configuring-kerberos-for-sharepoint-2007-part-1-base-configuration-for-sharepoint.aspx

Testing SharePoint Kerberos Configuration
******************************************

http://www.wssdemo.com/Blog/archive/2009/06/12/Testing-SharePoint-Kerberos-Configuration.aspx