Customizing SharePoint Themes with SharePoint Designer 2007 and IE8

 

Whilst battling with customisations of SharePoint Online, I found the following information on Kirk Evans Blog… The following post is a really good set of instructions on how to modify out of the box Themes in SharePoint 2007,

It turns out to be pretty easy to customize the look and feel of a SharePoint site using SharePoint Designer 2007 and Internet Explorer 8. Using IE8, you can easily find the CSS class for a particular element and modify it, and SharePoint Designer 2007 makes it easy to make changes to the styles for a site. This is really cool because you can do this even when you don’t have console access to the box or administrative rights to deploy new features.

This may even work with SharePoint Online instances

Apply an Out of Box Theme to Your Site

To get started, create a new site in SharePoint. I am going to create a site called “ThemeDemo” using my MySite, which I don’t have administrative access for in Microsoft’s internal network. Go to Site Actions / Create / Sites and Workspaces” and create a new site called “ThemeDemo” using the “Team Site” template. What you will end up with is the familiar SharePoint look and feel.

image

Open up SharePoint Designer 2007. On the File menu, choose “Open Site” and use the URL to the site you just created. The URL I will use is “http://my/sites/kirke/themedemo”. The thing to notice is the Folder List pane, it will look like this:

image

The next step is to apply an out-of-box theme to the site. Go back to Internet Explorer. Go to Site Actions / Site Settings. Look under the “Look and Feel” column and you’ll see a link to manage the Site theme.

image

The will pull up a new page where you can select from a set of pre-defined themes. I chose the “Reflector” theme. Once you have chosen, click “Apply”.

image

Now that your site has a theme applied to it, you might want to customize it a little bit. For instance, the “Recycle Bin” link is green. Let’s see how you can make modifications like this.

Customizing an Out of Box Theme

Internet Explorer 8 introduces the Developer Tools feature that enables you to inspect a web page’s various components such as HTML layout, CSS, images, JavaScript DOM, etc. You can find this in Internet Explorer 8 by clicking Tools / Developer Tools or simply hitting F12 on a web page to bring up a new window. In the Developer Tools window’s menu, choose “Find / Select Element by Click”. Then switch back over to the IE8 window and click the Recycle Bin link. The Developer Tools window should now jump to the HTML that is used to render the link, and the pane on the right shows the CSS style being applied.

image

We can use the information in this window to customize the theme. At the bottom right, we see that the file Refl1011-65001.css contains a CSS rule “TABLE.ms-recyclebin TD A” with a colour value of #008800. We’ll customize this value to change the Recycle Bin link colour to blue.

Go back to SharePoint Designer 2007 and hit F5 to refresh the site. You’ll see a new folder in the Folder List called “_themes”.

image

Open that folder and expand the Reflector node. Scroll down a bit and you’ll find a file, Refl1011-65001.css. Open that file and look for the CSS rule “table.ms-recyclebin td a” and click on it. You’ll see a wealth of information about that style.

image

Now, it’s as simple as going to the CSS Properties and changing the color. Perhaps you want the color of the link to match another color elsewhere in the page. It’s as simple as going to the CSS Properties pane and clicking on the color property. Choose “More Colors” in that dropdown.

image

In the More Colours dialog, click the “Select” button with the eyedropper icon to select a colour.

image

In IE8 or IE9, hover over the element that has the colour you want. You will see the colour change in the More Colours dialog from green to whatever colour you are hovering over. When you finally pick the colour you want, click and the colour will be chosen. Click OK to choose that colour, and the new colour will be reflected in SharePoint Designer 2007. Finally, click the Save button in SharePoint Designer 2007 to apply the change.

Go back to IE8 and refresh the page to see the change.

image

Does That Change All the Sites?!?!

When you use this method to customize the theme for a site, you are only customizing the current site you are working with. You can verify this by creating a new site and choosing the Reflector theme like we did previously, you’ll see that the Recycle Bin link is still green. If you decide you want to undo all of your modifications to the current site, you can go to the Site Settings menu and choose an out of box theme… all of your modifications will be discarded.

What If You Want to Create a Reusable Theme?

If you want to create a custom theme and make it available to others, see the post “Create a custom site theme and make it available to others”.

Fantastic 40 templates on SharePoint 2010

 

WARNING: RESULTS MIGHT VARY !!!

So, if you are:

1. migrating from SP 2007 and you have Fantastic 40 templates that are not working anymore

2. or you are starting with a fresh SP 2010 Portal and you want to use these templates in your new environment.

 
Either way, the fantastic 40 templates are a great deal…They are delivered from Microsoft and contain good examples of real life needs in organisations.

Just to refresh your memory, here they are again:
Server Admin templates
Absence Request and Vacation Schedule Management
Help Desk
Budgeting and Tracking Multiple Projects
Inventory Tracking
Bug Database
IT Team Workspace
Call Center
Job Requisition and Interview Management
Change Request Management
Knowledge Base
Compliance Process Support Site
Lending Library
Contacts Management
Physical Asset Tracking and Management
Document Library and Review
Project Tracking Workspace
Event Planning
Room and Equipment Reservations
Expense Reimbursement and Approval Site
Sales Lead Pipeline

You can try them out here on the TechSol Blog Site.
These work great in any SharePoint 2007 environment (the free WSS version or the non-free MOSS versions).
But now you are running SP2010 and you want this functionality too ? Well, that is possible for the Server Admin Templates!!

 
Steps:
1. Download the fantastic 40 here at the Microsoft site.
2. Unpack them in the following directory: “C:\Unpacked” on your front end SharePoint server.
3. Use this Batch script to add en deploy the 40 solutions (created by Dessie Lunsford )
4. create your new Fantastic 40 site.

The batch adds the solution to the 14 hive.

Compare editions of SharePoint

 

If you ever need to compare versions of Sharepoint (Foundation, Standard, Enterprise) check out the following site:

http://sharepoint.microsoft.com/en-us/buy/Pages/Editions-Comparison.aspx

This page offers a break down of all SharePoint features, by version. Each feature is demonstrated by a video overview of the functionality.
A great resource for anyone, sales/business analyst/dev, who needs to describe SharePoint features to end users.

SharePoint 2010 Product Documentation

SharePoint Server 2010:

  • SharePoint Server 2010 Tech Center is a gateway into the IT Pro documentation for SharePoint Server 2010 and a location for RSS feeds of new content.
  • Resource Centers provide information across the product lifecycle for activities and solutions.
  • TechNet articles are organized by the product lifecycle – evaluate, plan, deploy, operate, etc. Content includes a newly published page with an RSS feed, so you can keep up with what we’ve published, and a roadmap to the content.
  • Worksheets are Microsoft Excel files that you can use to record information that you gather and decisions that you make as you plan your deployment of Microsoft SharePoint Server 2010.
  • Models are poster-sized illustrations of Microsoft SharePoint Server 2010 architecture and concepts.

SharePoint Foundation 2010:

  • SharePoint Foundation 2010 Tech Center is a gateway into the IT Pro documentation for SharePoint Foundation 2010 and a location for RSS feeds of new content.
  • Resource Centers provide information across the product lifecycle for activities and solutions.
  • TechNet articles are organized by the product lifecycle – evaluate, plan, deploy, operate, etc. Content includes a newly published page with an RSS feed, so you can keep up with what we’ve published, and a roadmap to the content.
  • Worksheets are Microsoft Excel files that you can use to record information that you gather and decisions that you make as you plan your deployment of Microsoft SharePoint Foundation 2010.
  • Models are poster-sized illustrations of Microsoft SharePoint Foundation 2010 architecture and concepts.

SharePoint 2010 Administration Toolkit V1

 

First version of SharePoint 2010 Administration Toolkit is now available. The toolkit included a couple of tools that were shipped releases and are now adapted to SharePoint 2010, along with two new tools.

User Profile Replication Engine 2010 (UPRE2010): this tool got a complete overhaul and was converted to PowerShell. It now allows you to replicate Profile and Social data between SharePoint 2010’s User Profile Application (UPA), as well as backward compatibility with SharePoint 2007’s SSP. You can replicate between SSP’s or UPA services, as well as across versions. (Note that only Profile data can be replicated across versions, as SSP contains no Social activity tracking).

The Security Configuration (SCW) Manifest: SCW is an attack surface reduction feature in Windows Server. This manifest adds roles for SharePoint 2010 Products to Windows Server 2008 with SP2 or Windows Server 2008 R2.

The Content Management Interoperability Services (CMIS) Connector: enables SharePoint users to interact with content stored in any repository that has implemented the CMIS standard, as well as making SharePoint 2010 content available to any application that has implemented the CMIS standard.

The Load Testing Kit (LTK): LTK generates a Visual Studio Team System 2008 (VSTS) load test based on Windows SharePoint Services 3.0 IIS logs. The VSTS load test can be used to generate synthetic load against Microsoft SharePoint Foundation 2010 as part of a capacity planning exercise or a pre-upgrade stress test.

The toolkit can be downloaded from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=718447d8-0814-427a-81c3-c9c3d84c456e&displaylang=en

The toolkit documentation can be found here:

SharePoint Foundation 2010: http://technet.microsoft.com/en-us/library/cc508986.aspx

SharePoint Server 2010: http://technet.microsoft.com/en-us/library/cc508851.aspx

Installing BlackBerry Enterprise Server Express for Exchange 2010

BlackBerry Logo

The BlackBerry Enterprise Server Express Edition offers businesses the ability to enable their staff to use BlackBerry devices to receive push-based email from an existing Microsoft Exchange installation – both standalone Exchange servers and the Microsoft Small Business Server product.
A free download from the BlackBerry web site, the solution is not limited to any set number of users and requires only that users have a BlackBerry data tariff on their SIM card with their network operator.
A 10,000 user CAL is supplied with the download by default:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Features

BES Express is based on the BES 5.0.1 MR1 code, and as such offers much (but not all) of the same functionality:

  • Web-based administration
  • 6 pre-defined administrative roles
  • BlackBerry Web Desktop
  • Over 35 IT policies for device management (see below), including device wipe
  • HTML email support
  • Flag emails for follow-up
  • Mail folder management
  • Remote email search
  • Set out of office status and message
  • Forward calendar appointments
  • Open attachments in calendar appointments
  • Free / Busy lookup
  • Remote file access
  • Support for audio (AWE, WAV, MP3, WMA) files

The following features are NOT available in BES Express:

  • Cradle-less enterprise activation (when used with the BIS tariff on client devices)
  • Ability to define multiple administrative roles
  • BlackBerry Monitoring Service
  • BlackBerry Enterprise Transporter Tool
  • High Availability deployment options
  • Support for BlackBerry Mobile Voice System (MVS)
  • Support for enterprise instant messaging and social networking integration

At the time of writing, BES Express is only available in English.
BES Express is not compatible with Lotus Domino or Novell Groupwise installations.

System Requirements

Operating System

  • Windows Server 2003 SP2 (32-bit or 64-bit)
  • Windows Server 2003 R2 SP2 (32-bit or 4-bit)
  • Windows Server 2008 SP2 (32-bit or 64-bit)
  • Windows Small Business Server 2003
  • Windows Small Business Server 2008

Microsoft Exchange Messaging Server

  • Microsoft Exchange 2003 SP2
  • Microsoft Exchange 2007 SP1
  • Microsoft Exchange 2010 including Update Rollup 1

Microsoft Exchange System Tools

  • (Exchange 2003) Microsoft Exchange 2003 SP2 System Manager or MAPI client and CDO 1.2.1 version 6.5.8039.0 or later
  • (Exchange 2007) MAPI client and CDO 1.2.1 version 6.5.8067.0 or later
  • (Exchange 2010) MAPI client and CDO 1.2.1 version 6.5.8146.0 or later

Hardware

    (Up to 200 users)

  • Single processor, 2.0GHz Intel Xeon (2 processors recommended)
  • 2GB memory
  • 2 HDDs, RAID 1

    (Up to 500 users)

  • Two processors, 2.0GHz Intel Xeon
  • 2GB memory
  • 2 HDDs, RAID 1

    (Up to 1000 users)

  • Two processors, 2.0GHz Intel Xeon
  • 3GB memory
  • 2 HDDs, RAID 1

Database

Any of the following database management systems are supported:

  • MSDE 2000 SP3
  • Microsoft SQL Server 2005 SP3 (32-bit or 64-bit)
  • Microsoft SQL Server 2005 Express Edition SP3
  • Microsoft SQL Server 2008 SP1 (32-bit or 64-bit)
  • Microsoft SQL Server 2008 Express Edition SP1 (32-bit or 64-bit)

If using a database system earlier than SQL 2005 SP3, the following hotfix should be installed on the database server – http://support.microsoft.com/?kbid=960082

Miscellaneous

In order to provide support for audio attachments, Windows Media Player 9 or later is required on the BES.

Internet Explorer 6 or later is required to access the web administration console.

Firewall

The BES requires outbound-initiated, bi-directional access to the Internet on TCP port 3101 as well as access to DNS.

RIM recommend operating up to a maximum of 75 users if the BES Express software is being installed directly onto the Exchange server itself. On a standalone server, BES Express can support up to 2,000 users. Multiple BES Express servers can be deployed in the same BlackBerry domain.

Preparing an Exchange 2010 environment

NOTE – this article assumes an Exchange 2010 installation only. Visit the BES Express section of the blog for details on installing the solution against Exchange 2003 or 2007.

Ensure that Exchange 2010 Update Rollup 1 is installed on the Exchange 2010 server. This package is available here – http://www.microsoft.com/downloads/details.aspx?FamilyID=371add31-d7a0-4…

If installing the BES Express software on the Exchange server itself, the Exchange server should NOT itself also be a domain controller.

Create a domain user account called BesAdmin

On the Exchange server, in the Active Directory Users and Computers console, create a domain user called “BesAdmin” and assign it an Exchange mailbox. Set the user account password to never expire.

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Send an email to the BesAdmin user to initialise the Exchange mailbox.

Assign the BesAdmin user local administrative rights

On the server that is to host the BES Express, make the BesAdmin domain user a member of the local administrator group. NOTE – the BES Express server will first need to have been added to the Domain if not done already.
To do this, on the BES Express server, right click on the icon for My Computer and select Manage. Browse to Local Users and Groups –> Groups –> Administrators and add the BesAdmin user:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Assign the BesAdmin user “log on as a service” rights

On the BES Express server, also assign the BesAdmin domain user account “log on as a service” rights. To do this, select Administrative Tools –> Local Security Policy –> User Rights Assignment –> Log on as a service and add the BesAdmin user:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Assign “Receive As” and “Administer Information Store” rights to the BesAdmin user

On the Exchange server, launch the Exchange PowerShell and issue the following command:

Get-MailboxDatabase | Add-ADPermission -User "BesAdmin" -AccessRights
ExtendedRight -ExtendedRights Receive-As, ms-Exch-Store-Admin

Installing BlackBerry Enterprise Server Express Edition on Exchange 2010

Assign Exchange View-Only Administrator rights to the BesAdmin user

Still within the Exchange PowerShell, now issue the following command:

Add -RoleGroupMember "View-Only Organization Management" -Member "BesAdmin"

Installing BlackBerry Enterprise Server Express Edition on Exchange 2010

Assign “Send As” rights on the domain to the BesAdmin user

Within the Active Directory Users and Computers console, open the View menu and select the option to display Advanced Features.

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Right click on the domain and select Properties. Click on the Security tab:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Click on the Advanced button:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Click on Add and type in the name of the BesAdmin user:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Select the option to Apply Onto User Objects.

Scroll down to the bottom and tick the option to enable Send As rights:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

For good measure, also enable Send As rights on the Exchange server itself within the Exchange PowerShell. Launch the console and issue the following command:

Add-ADPermission -InheritedObjectType User -InheritanceType Descendents -ExtendedRights
Send-As -User "BesAdmin" -Identity "CN=Users,DC=domain,DC=com"

Installing BlackBerry Enterprise Server Express Edition on Exchange 2010

(where “domain” and “com” should be substituted for your specific domain details, eg: DC=brightpoint,DC=co,DC=uk and so on)

To force all of the above changes to take effect on the domain, it may be worth running a group policy update. On the Exchange server click Start –> Run and issue the command “gpupdate /force”

Turn off Exchange 2010 Client Throttling

Exchange 2010 uses client throttling by default to protect the Exchange server from excessive user demands. RIM recommend turning off this feature as it can have an adverse affect on the performance of the BES solution. This is done within the Exchange PowerShell console.

Launch the console and issue the following command to get the “Identity” of the default throttling policy”

Get-ThrottlingPolicy | Where-Object {$_.IsDefault -eq "True"} | FL Identity

the Identity will be displayed:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2010

Now issue the following command:

Set-ThrottlingPolicy -RCAMaxConcurrency $null

You will be prompted to enter the Identity to apply the policy to, enter the result returned above:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2010

Increase the maximum number of connections to the Exchange Address Book Service

On the Exchange Server (or specifically the Client Access Server in a multi-box deployment), browse to C:\Program Files\Microsoft\Exchange Server\V14\Bin and locate the file “microsoft.exchange.addressbook.service.exe.config” and open it in NotePad:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2010

Locate the line “MaxSessionsPerUser”:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2010

Increase the value to 100000. Save the file then restart the Address Book Service:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2010

Install the Exchange MAPI CDO 1.2.1 package

The Microsoft Exchange MAPI CDO 1.2.1 package must be installed to provide the BesAdmin user a MAPI connection to Exchange mailboxes as well as access to calendaring information.

Download here: http://www.microsoft.com/downloads/en/details.aspx?FamilyId=2714320D-C997-4DE1-986F-24F081725D36&displaylang=en

Run the installer and accept the license agreement:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Now you’re ready to install the BES Express software.

Installing the BlackBerry Enterprise Server Express software

LOG INTO THE BES EXPRESS SERVER AS THE BESADMIN USER!

Launch the BES Express installer, you will be prompted to confirm that you are indeed logged in as the correct user:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Click Continue Installation:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Choose your country and read the license agreement. Select the option to accept if you agree to the terms and conditions:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Select the option to Create a BlackBerry Configuration Database:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Select the option to install a BlackBerry Enterprise Server:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Verify that all pre-requisite checks are completed successfully, paying attention to any warnings or failures:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

In this article I am allowing the BES Express installer to install a local copy of SQL Server Express, if you intend to use a dedicated SQL Server, select this option and enter the details of the server address:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Enter the password for the BesAdmin account and enter in a name for the BES Express server: this name can be a ‘friendly’ one and is used to identify it in the Web Administration interface:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

If you are warned that the server does not have sufficient free disk space available, free up some space before continuing:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

A summary of the installation options will be displayed:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Click Install, the required components will now be installed, this process may take a while. When complete you will be prompted to reboot the server:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Click Yes. Once rebooted, log back in as the BesAdmin user. The installation will resume automatically:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Enter a name for the Configuration Database – this should ideally be left at the default unless specifically required. Click Next:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

You will be prompted to create the database, click Yes:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

When created, click OK:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Enter in the 10,000-user CAL, SRP key and SRP authentification key you were supplied along with the BES Express download. Verify connectivity to the RIM Relay on TCP port 3101. Click Next:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

The MAPI connection settings will now be required, enter in the name of the Exchange server as well as the BesAdmin user account mailbox. Click OK:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Enter in the name you wish to use for the Administration web site. Again this should be left at the default if you are unsure as to what this means. Any name you choose should be resolvable via DNS if not using the default option.

Enter in a password for the SSL certificate – this is generated automatically by the installer and assigned to the Apache-based administration web site (the site does not run within IIS). The certificate is generated based on the name entered.

By default the administration web site runs on port 3443 – this can be altered if desired but again leave this value at the default unless specifically required. Click Next:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Enter in the details of the BesAdmin user account again and click Next:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Specify whether you wish access to the administration web site to be authenticated based on Active Directory credentials, or whether you want to use the built-in BlackBerry Administration Service authentication. If you select the second option, enter in a password for the default admin account.

NOTE – if you select BlackBerry Administration Service authentication, the default admin username is “ADMIN”, NOT “BESADMIN”.

Click Next:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Select the option to Start Services and verify that all services start successfully:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Click Next:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

You will be reminded what the address is to access the administration web site. Click Finish.

The software is now installed and ready to use. To access the web administration site, a link will have been added to the Programs folder on the Start menu:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Selecting the link will launch the default browser on the server (which needs to be Internet Explorer 6 or later):

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Log in ether as the BesAdmin user (using Windows authentication) or as the Admin user (using BlackBerry authentication):

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Add the web site to the Trusted Sites group in the Internet Explorer security options area:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

And add the web site certificate to the trusted certificate authority folder:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Adding Users

In the Administration web site, select the option to Create a user:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Selecting Search will display a list of all available users:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Tick the user(s) you want to add and click Continue:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Select the BES Server the users should be added to (you’ll only have one option) and click Next. The users will now be added to the BES Server.

To associate a device to a user, the BlackBerry handheld itself can be connected directly to the BES Express server via USB. In the Administration web site browse to Devices –> Attached Devices –> Overview:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

When the device is connected, its PIN details will be displayed:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Select the option to Assign current device to a user. Select the user you want to associate the device with:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

The device will now be associated to the user and will automatically activate itself and begin to download user mailbox data.

Troubleshooting

If you encounter any problems adding or activating users, first verify that all BlackBerry services have started and are running correctly:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Exchange Permissions

The commonest cause of problems when troubleshooting issues with a BES installation is that the correct permissions have not been assigned to the BesAdmin user on the domain and the Exchange server as detailed above.

Included with the BES Express software is a utility called “IEMSTEST” which can verify the BesAdmin user’s access to specific user mailboxes.

The utility lives in the C:\Program Files\Research In Motion\BlackBerry Enterprise Server\Utility folder and needs to be run at the command line:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Select the BlackBerryServer MAPI profile when prompted:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Select the user account you wish to query:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

The permissions will be tested:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

As you can see from the above screenshot this test has indicated that the BesAdmin account does not have Send As rights on my James Liddiard user account. Once I verify my permissions, re-running the test indicates that all test have passed successfully:

Installing BlackBerry Enterprise Server Express Edition on Exchange 2003

Resolving Windows 7 Service Pack 1 error

‘Fatal error C0000034’ on boot after Service Pack 1 for 64-bit systems install

After Installing Windows 7 Service Pack 1 for 64-bit systems on my laptop after it appeared on Windows Update. The install seemed to go alright, however, when I restarted the computer at the prompt of Windows Update, it gets as far as the Starting Windows screen, before throwing ‘Fatal Error C0000034 applying update operation 282 of 114599 (_00000…)’

At this point, the start-up sequence hangs and go’s no further. I restarted again by switching off at the mains, and this time was prompted to run Start-up Repair. I tried this, however the Start-up Repair program hung (I left it for several hours with apparently no effect). I then proceeded to try the following things:

-Boot in Safe Mode
This led to the start-up to hang at the ‘Loaded: CLASSPNP.SYS’, ‘Please wait…’ stage. Again, left for several hours, no progress.

– Run the recovery CD to restore from a System Restore point.
The program hung at the restoring system stage – again, left for several hours, nothing happens.

– Booting from last known good configuration
This just resulted in the same error as when I boot it normally

The Following is how to fix this issue.

It essentially involves doing a manual system restore.

– Open the recovery console – To get to the Windows 7 recovery Console Press F8 at system restart before it trys to load Windows, and you are presented with the following menu:

When the recovery console has loaded select Command Prompt from the menu options:

When the command prompt is open complete the following:

– Change working directory to whatever the root folder of the Windows install is (might be D: or some other letter for some people):
cd /d C:\windows\system32\config

Rename the following files by typing the following:

ren default default.old
ren sam sam.old
ren security security.old
ren software software.old
ren system system.old

– Change the working directory:
cd regback
– Copy the files from this directory to the previous directory as follows:
copy default c:\windows\system32\config
copy sam c:\windows\system32\config
copy security c:\windows\system32\config
copy software c:\windows\system32\config
copy system c:\windows\system32\config

– Having done this, I restarted my computer, and it booted all the way with no errors. However, it seemed somewhat unstable, so I booted into Safe Mode and ran CHKDSK (chkdsk /B) and conducted a normal system restore to before the service pack install using the normal method. To fix remaining problems, I ran sfc /scannow. My computer now seems to be running as well as ever.

SharePoint 2010 – SQL Server has an unsupported version 10.0.2531.0

 

I am trying to perform a database attach upgrade to SharePoint Foundation 2010.

At this point I am trying to attach the content database to a Web application by using Windows Powershell:

Mount-SPContentDatabase -Name -DatabaseServer -WebApplication [-Updateuserexperience]

I am following the directions from this TechNet article: Attach databases and upgrade to SharePoint Foundation 2010.  When I go to mount the content database I am receiving this error:

Mount-SPContentDatabase : Could not connect to [DATABASE_SERVER] using integrated security: SQL server at [DATABASE_SERVER] has an unsupported version 10.0.2531.0. Please refer to “http://go.microsoft.com/fwlink/?LinkId=165761” for information on the minimum required SQL Server versions and how to download them.

At first this did not make sense because the default SharePoint Foundation 2010 website was running just fine.  But then I realized that the default SharePoint Foundation site runs off of SQL Server Express and that I had just installed SQL Server Web Edition (since the database is greater than 4GB) and restored the database to this version of SQL Server.

Checking the documentation link above I see that SharePoint Server 2010 requires a 64-bit edition of SQL Server with the minimum required SQL Server versions as follows:

  • SQL Server 2008 Express Edition Service Pack 1, version number 10.0.2531
  • SQL Server 2005 Service Pack 3 cumulative update package 3, version number 9.00.4220.00
  • SQL Server 2008 Service Pack 1 cumulative update package 2, version number 10.00.2714.00

    The version of SQL Server 2008 Web Edition with Service Pack 1 (the version I installed on this machine) is 10.0.2531.0.

    SELECT @@VERSION:
    Microsoft SQL Server 2008 (SP1) – 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Web Edition (64-bit) on Windows NT 6.1 (Build 7600: ) (VM)

    But I had to read the article several times since the minimum version number for SQL Server Express is 10.0.2531.0.  At first I thought I was good with the version of SQL Server 2008 Web that I had installed, also 10.0.2531.0.  But then I read further to see that there is a cumulative update (hotfix) for SQL Server 2008 SP1 (NOT the Express edition) that is required for SharePoint 2010 and will bump the version number to 10.0.2714.00.

    So the solution was to install the Cumulative update package 2 for SQL Server 2008 Service Pack 1 on my SQL Server 2008 Standard Edition to allow SharePoint 2010 to work with SQL Server 2008 (other than the SQL Server 2008 Express version).

    SELECT @@VERSION (After installing Cumulative update package 2):
    Microsoft SQL Server 2008 (SP1) – 10.0.2714.0 (X64)   May 14 2009 16:08:52   Copyright (c) 1988-2008 Microsoft Corporation  Web Edition (64-bit) on Windows NT 6.1 (Build 7600: ) (VM)

  • Adobe Reader Integration To SharePoint 2010

     

    SharePoint 2010 and Adobe PDF

    SharePoint Server 2010, like its predecessors, includes indexing and search capabilities. But what doesn’t come out of the box is the ability to index and search for PDF documents. PDF is a format owned by Adobe, not Microsoft. If you want to be able to find Adobe PDF documents, or have the PDF icon appear when viewing PDF files in a SharePoint document library (see image above), you will need to set it up for yourself. This post describes how to.

    1. Download and install Adobe’s 64-bit PDF iFilter*1http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025
    2. Download the Adobe PDF icon (select Small 17 x 17) – http://www.adobe.com/misc/linking.html
      1. Give the icon a name or accept the default: ‘pdficon_small.gif’
      2. Save the icon (or copy to) C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES
    3. Edit the DOCICON.XML file to include the PDF icon
      1. In Windows Explorer, navigate to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML
      2. Edit the DOCICON.XML file (I open it in NotePad, you can also use the built-in XML Editor)
      3. Ignore the section and scroll down to the section of the file
      4. Within the section, insert attribute. The easiest way is to copy an existing one – I usually just copy the line that starts <Mapping Key=”png”… and replace the parameters for Key and Value (see image below)
      5. Save and close the file
        SharePoint 2010 and Adobe PDF DOCICON.XML
    4. Add PDF to the list of supported file types within SharePoint
      1. In the web browser, open SharePoint Central Administration
      2. Under Application Management, click on Manage service applications
      3. Scroll down the list of service apps and click on Search Service Application
      4. Within the Search Administration dashboard, in the sidebar on the left, click File Types
      5. Click ‘New File Type’ and enter PDF in the File extension box. Click OK
      6. Scroll down the list of file types and check that PDF is now listed and displaying the pdf icon.
      7. Close the web browser
    5. Stop and restart Internet Information Server (IIS)*2 Note: this will temporarily take SharePoint offline. Open a command line (Start – Run – enter ‘cmd’) and type ‘iisreset’
    6. Perform a full crawl of your index. Note: An incremental crawl is not sufficient when you have added a new file type. SharePoint only indexes file names with the extensions listed under File Types and ignores everything else. When you add a new file type, you then have to perform a full crawl to forcibly identify all files with the now relevant file extension.

    That’s it. If you now perform a search, PDF files should be displayed in results where they match the search query, along with the PDF icon on display in results. The icon should also be visible in any document libraries that contain PDF files.

    SharePoint 2010 – Default MySite Quota’s

     

    PROBLEM !!! – What Problem

    I am using SharePoint 2010 server.

    I tried to uploaded documents to SharePoint my site Shared Document Library, and got the following error,

    Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit.
    You must save your work to another location.  Contact your administrator to change the quota limits for the Web site

    I run SharePoint Central Administration Tool, selected the web application from the dropdown listbox,  I changed the Quota limit, created Quota template, assigned the new Quota template. But no matter what I did, It seems the quota did not changed

    When I go back to my site I still getting the above error. Anyone can tell me what I did wrong?

    Fortunately there is a FREE and very useful tool from CodePlex that will take the pain away from managing Quotas on Mysite….. the tool looks like this:

    image

    Application for change user profile site disk quota, if you have too much my site web.

    Because SharePoint implicitly cannot change my site quota templates for all my site web at once, you can use this applications.

    This project is beta version. You can read more on this blogs.

    There are three requirements before you publish:

    – Run only on server with SharePoint Portal Server 2007 / 2010
    – Run under SharePoint Farm system account

    To Download the tools go to the following link: http://spmysitequota.codeplex.com/

    or if you like the STSADM tool try the following command:

    stsadm -o gl-syncquotas -scope webapplication -url http://mysites -quota “Personal Site” –setquota