Fabian Williams SharePoint Blog

Solving problems with SharePoint day and night

How To: Strange but True – If you use a permanent marker on a White Board…a simple Fix to get it Off

Synopsis

So i would not believe it if I didn’t see it myself.  Here is what I did.  [Disclaimer] I wasn’t the one who put Permanent Marker and Dry Erase Marker in the same place. :-)

I am about to draw a line on the board to separate an are for “Parking Lot” information.  I took a permanent marker “unbeknownst to me” and drew a 1 meter line from top to bottom. Only after I hear the crys of OMG, that is a permanent marker did i stop… but alas too late.

 

FIX – “Credited to one of the Sessions Participants…”

  1. Take a Dry Erase Marker
  2. Use the Dry Erase marker and cover, really cover, the entry made by the Permanent Marker, be generous in your application but not over kill
  3. Use the Dry Eraser to erase your entry… Voila, the Dry Erase Marker and Permanent Marker entry are gone.
  4. It really works…
Maybe i can get the Sham-Wow Guy to market this for me…

August 18, 2009 Posted by | Strange Stuff | 1 Comment

Fix: Service Pack 2 expiration date issue available for download

Service Pack 2 Update.

The public update for the Service Pack 2 expiration date issue is now available for download. 

The update can be applied before or after Service Pack 2 installation.  If the update is applied prior to installing Service Pack 2 it will prevent the expiration date from being improperly activated during installation of Service Pack 2, if it is applied after Service Pack 2 it will remove the expiration date incorrectly set during installation of Service Pack 2.

The update is applicable to all of the products that this issue affected (see the list in the KB linked below).

Installation instructions and download links for x86 and x64 are available in this KB: http://support.microsoft.com/kb/971620

The direct download link for x86 is: http://download.microsoft.com/download/2/F/5/2F51AB71-1325-49D2-9CB9-18DEC4780E99/office2007-kb971620-fullfile-x86-glb.exe

And for x64: http://download.microsoft.com/download/5/B/B/5BBD34A9-C528-42B0-8A5F-9A8997B25C32/office2007-kb971620-fullfile-x64-glb.exe

 

FAQ

Q: How can I tell if the update has worked?
A: The License Type text on the Convert License Type page in Central Administration no longer contains the word “trial”.

Q: I applied the update and now I can’t enter anything in the Convert License Type page in Central Administration, is this right?
A: This is expected behavior if your license type is “Office SharePoint Server with Enterprise Client Access License”. 

Original Source:  http://blogs.msdn.com/sharepoint/archive/2009/06/25/service-pack-2-update.aspx

August 15, 2009 Posted by | SharePoint Bug, SharePoint Error/Resolution, SharePoint How-To | Leave a comment

How To: Fix Error 3351 on SharePoint Server – SQL Login Failed

Scenario:

You install SharePoint in a Farm and you see the below error in the event viewer.

SharePointError3351_TimerFix

Solution:

Usually this means that your SharePoint Timer Service Account is set to “Local Service Account” rather than the “Domain\Service Account” you created during Install.

You should change the Logon Account in the Services Applet to the Domain Account associated with that Service and your problem should be resolved.

Thank you.

August 14, 2009 Posted by | SharePoint Administration, SharePoint Error/Resolution | , | Leave a comment

How To: The required accounts to install MOSS 2007

Using a strategy of least privileges and domain accounts, here are the accounts listed in the best practice for installing SharePoint

 

 

image

August 14, 2009 Posted by | SharePoint Administration, SharePoint How-To | Leave a comment

Announcing Service Pack 2 for Office SharePoint Server 2007 and Windows SharePoint Services 3.0

Update on 05/21/09 :

Important Notice:

A bug in Service Pack 2 could affect the server farm licensing information, for more information, please refer to the new post here:

http://blogs.msdn.com/sharepoint/archive/2009/05/21/attention-important-information-on-service-pack-2.aspx

KB Article Links

Description of Windows SharePoint Services 3.0 SP2 and of Windows SharePoint Services 3.0 Language Pack SP2
http://support.microsoft.com/kb/953338
Description of 2007 Microsoft Office servers Service Pack 2 (SP2) and of 2007 Microsoft Office servers Language Pack Service Pack 2 (SP2)
http://support.microsoft.com/kb/953334

Download Links

Service Pack 2 for Windows SharePoint Services 3.0, x86 & x64
http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B&displaylang=en

Service Pack 2 for Office SharePoint Server 2007, x86 & x64
http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082&displaylang=en

Slipstream Builds For Windows SharePoint Services 3.0

Windows SharePoint Services 3.0 with SP2, x64
http://www.microsoft.com/downloads/details.aspx?FamilyId=9FB41E51-CB03-4B47-B89A-396786492CBA&displaylang=en
Windows SharePoint Services 3.0 with SP2, x86
http://www.microsoft.com/downloads/details.aspx?FamilyId=EF93E453-75F1-45DF-8C6F-4565E8549C2A&displaylang=en

Installation Steps

To keep all the files in a SharePoint installation up-to-date, the following packages need to be applied on all servers in the farm. Service Pack 2 contains all fixes released through February of this year, so customers can install it directly on RTM build of the products.

  1. Service Pack 2 for Windows SharePoint Services 3.0
  2. Service Pack 2 for Windows SharePoint Services 3.0 Language Pack (if applicable)
  3. Service Pack 2 for Office SharePoint Server 2007
  4. Service Pack 2 for Office SharePoint Server 2007 Language Pack (if applicable)

After applying the preceding updates, run the SharePoint Products and Technologies Configuration Wizard or "psconfig –cmd upgrade –inplace b2b -wait” in command line. This needs to be done on every server in the farm with SharePoint installed.  The version of content databases should be 12.0.0.6421 after successfully applying these updates.

For more in-depth guidance for the update process, we recommend that customers refer to the following articles. These articles provide a correct way to deploy updates, identify known issues (and resolutions), and provide information about creating slipstream builds.

Deploy software updates for Windows SharePoint Services 3.0
http://technet.microsoft.com/en-us/library/cc288269.aspx
Deploy software updates for Office SharePoint Server 2007
http://technet.microsoft.com/en-us/library/cc263467.aspx

Create an installation source that includes software updates (Windows SharePoint Services 3.0)
http://technet.microsoft.com/en-us/library/cc287882.aspx
Create an installation source that includes software updates (Office SharePoint Server 2007)
http://technet.microsoft.com/en-us/library/cc261890.aspx

Benefits

Customers can be benefited from the following enhancements with Service Pack 2.

  • Performance and Availability Improvements

Service Pack 2 includes many fixes and enhancements designed to improve performance, availability, and stability in your server farms, including:

    • New Timer job automatically rebuilds content database index to improve database performance.
    • When a content database is marked as read-only, the user interface will be modified so users cannot perform tasks that require writing to the database.
    • Performance enhancement across nearly all the components.
  • Improved Interoperability

Service Pack 2 continues to improve SharePoint interoperability with other products and platforms.

    • Broader support of browsers
      Internet Explorer 8 is added into Level 1 browser support.
      FireFox 3.0 is added into Level 2 browser support. (Firefox 2.0 is no longer supported by Mozilla)
    • Provide improved client integration user experience with Form Based Authentication. Now the client application can store user credentials instead of asking for them every time. For more technical details please refer to the updated articles on TechNet.
      Configure forms-based authentication (Office SharePoint Server
      http://technet.microsoft.com/en-us/library/cc262201.aspx
      Configure forms-based authentication (Windows SharePoint Services)
      http://technet.microsoft.com/en-us/library/cc288043.aspx
  • Getting Ready for SharePoint Server 2010

A new preupgradecheck operation is added to stsadm tool. It can be used to scan your server farm to establish whether it is ready for upgrade to SharePoint Products and Technologies "14". It identifies issues that could present obstacles to the upgrade process. It checks for several SharePoint Products and Technologies "14" system requirements, including the presence of Microsoft® Windows Server® 2008 and a 64-bit hardware, and provides feedback and best practice recommendations for your current environment, together with information on how to resolve any issues that the tool discovers. 

The full explanation of SP2 benefits can be downloaded here:
http://go.microsoft.com/fwlink/?LinkId=148551

August 14, 2009 Posted by | SharePoint Administration, SharePoint General, SharePoint How-To | Leave a comment

How To: Work around for opening Documents from MOSS 2007 Libraries in Office 2010

You may experience issues opening documents direclty from libraries using Office 2010, here is a work around to the error below:

OpeningDocDirectlyFromLibErrorOffice2010

Solution: 

set up a fake proxy (127.0.0.1) in Internet Explorer with an exception for *.*.  Still don’t know why this works, but it has allowed me to actually check out, edit, and upload/check-in documents from our libraries.

Credit:

http://social.technet.microsoft.com/Forums/en-US/office2010general/thread/700bdff2-229e-4e90-8aae-d0c90c54a3d1

August 12, 2009 Posted by | SharePoint Bug, SharePoint How-To | | Leave a comment

   

Follow

Get every new post delivered to your Inbox.

Join 3,963 other followers