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

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

Master Page and Themes on WSS sites in MOSS

Master Page and Themes on WSS sites in MOSS




Applying a Site Master



Create a "team" site (team template)
In site settings, go to site collection features and activate the "Office SharePoint Server Publishing Infrastructure" feature
Under Look and feel in site settings, go to Master Page
for Site Master page choose BlackVertical.master (check the box to apply to sub sites)
Expected result... go to home page and I'd see a fancy site with the black sides (no MS blue right?)

Wrong. Apparently the Site Master applies to publishing pages only (works for Intranet or Internet Portal Templates, but you'll discover it doesn't apply to sub sites with WSS templates)


Applying a System Master


5. Go back to site settings, Master Page, and for System.Master page choose BlackVerticle.Master (check the box to apply to sub sites)

Site Settings looks MS blue
Go to home page.
WooHoo now we have the new master page... ,
Wait the bars on the web parts are MS blue...

9. Go to site settings, under look and feel choose Site themes and choose Obsidian. Click apply.

10. Site settings, now looks like the black obsidian theme, but going to the home page or any list still has the blue web part bar.

So, how do we solve that?


Applying a Custom CSS (from a theme)


11. Go to site settings, click view source, you'll see the reference to the theme in the style sheet just a few lines down... Look for:

12. Copy the href URL path of the css reference (minus the querystring): /sites/tr5iw/_themes/Obsidian/Obsi1011-65001.css

13. Go to Master Page, scroll to the bottom, choose Specify a CSS file to be used and put in the URL to the CSS. "/sites/tr5iw/_themes/Obsidian/Obsi1011-65001.css" check the box to apply to sub sites and “click Apply”

14. Go to homepage

15. We did it. No blue.

Finish… Without opening any tools our UI in our team site has a consistent theme across site settings, the homepage and list pages.

So what did we learn? There is a difference between site.master and system.master in relation to the pages and templates.

Site Master: The site master page will be used by all publishing pages. (That’s great for the Internet and Intranet publishing site, but not for many of the subsites)

System Master: Use the system master page for all forms and view pages in this site. (let me amend this with these are all the site templates and pages that the site master does not apply to, including team sites, document workspaces, web part pages, and all non publishing pages.

MSDN has some good content on modifying master pages:

Master Pages



Customizing Master Pages in Windows SharePoint Services


SharePoint Designer on Office Online has some good info as well..

Troubleshooting for Office SharePoint Server 2007

Troubleshooting for Office SharePoint Server 2007


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