My Technology Notebook

SharePoint 2007 Move Site Collections between content databases

2011-06-30T12:07:00.000-07:00

Scenario:
Admin's are regularly presented with operational challenges. One of the most common one is to optimize content database size. We do not want to have large content databases as it becomes difficult to backup/restore

Resolution:
If possible, move site collections between content databases so that the size is manageable.

Step1: stsadm -o enumsites -url "web app url" > sites.xml (Concat results to an xml file.)

Step 2: stsadm -o mergecontentdbs -url "web app url" -sourcedatabasename "source db name" -destinationdatabasename "destination db name" -operation 3 -filename "sites.xml"

Step 3: IISReset /noforce

SharePoint 2007 MOSS WSS default.aspx HTTP 404 backup restore

2011-06-30T12:01:00.000-07:00

Scenario / Symptoms:
A site collection is backed up and restored to a different farm. When users navigate to the site default.aspx they receive HTTP 404 error.
Users are able to visit the _layouts/settings.aspx page but not the default.aspx
Default.aspx on some subsites work and some do not.

Resolution:
Make absolutely sure that all custom solutions (wsp) are deployed at the farm level.

This took me a lot of time to figure this out because we never had documentation of all custom solutions on the farm.

SharePoint 2007 Wss 3.0 Site Recycle Bin

2011-06-29T12:19:00.000-07:00

Interesting,
http://governance.codeplex.com/

Most useful: SharePoint Site Recycle Bin

Change sharepoint web application IIS local folder

2011-06-28T14:58:00.001-07:00

If you ever need to change the IIS local folder of a sharepoint web application,

http://www.mattjimison.com/blog/2009/02/26/how-to-change-the-iis-path-for-a-sharepoint-web-application/

OR

Navigate to Central Admin -> Application management
Click on Delete Web application
Drop IIS only! Not Content database
Create new web application with some temp database name and same host header as before.
IISreset
Do not create any site collections
Navigate to content databases -> remove temp database. You can ask your DBA to permanently remove the temp db later
Open command prompt under farm account and type,
stsadm -o addcontentdb -databasename "old db name" -url "url name"

WSS 3.0 MOSS 2007 Installation Steps

2011-06-28T07:44:00.000-07:00

Scenario:
Single Server (Non-Standalone install) on a new domain.
Backup and restore few site collections from an existing SharePoint farm to new farm.

Steps:

Current SharePoint Farm
- Note version of current farm from Central Admin-> Operations -> Servers in farm-> version column. Mine is 12.0.0.6545 hence August 2010 CU patch.
Reference,
https://www.nothingbutsharepoint.com/sites/devwiki/SP2007Admin/Pages/SharePoint%20Versions.aspx

- Since all site collections to be backed up are under 15GB used stsadm -o backup to perform backup.

- Copied backup files over to destination server

New Server Configuration

-Accounts needed
--> Setup account (dbcreator and securityadmin SQL permissions, Local admin on SP server)
--farm account
--pool account(s)
--mysite pool account
--ssp admin pool account
--search access account (used while starting office search service)
--ssp service account (used while provisionsing ssp)

- Web Apps needed
--> Collaboration web apps
--> Central Admin Web App
--> SSP Web App
--> Mysite web app

-install powershell on windows server 2003 which has a dependency on .net framework 2.0 sp1
powershell: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=10512
.net framework 2.0 sp1:
http://www.microsoft.com/download/en/confirmation.aspx?id=6041

- DISABLE LOOPBACK,
http://support.microsoft.com/kb/896861

- Restart server

- Install SQL Server 2005 SP3

- Download and install windows imaging component en-us from here,
http://www.microsoft.com/download/en/details.aspx?id=1385

- Download and install .net framework 3. Remember .net framework 4 will not suffice the prerequisite. If this is not installed it throws a windows workflow foundation exception, http://msdn.microsoft.com/en-us/netframework/bb264589

- Download and install wss 3.0 sp2 from here,
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7006

--> Remember to install Advanced -> Web Front End.
--> Do not run PSConfig now

- Download and install moss 2007 with sp2 full version from your msdn subscription
MOSS 2007 with SP2 includes WSS 3.0.

- Run PSConfig and provide Central Admin details and farm account.

- Install WSS / MOSS Aug 2010 CU
Download and install WSS update: (do not run psconfig)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;2276474

Download and install moss update
http://support.microsoft.com/default.aspx?scid=kb;EN-US;2276474

- Run psconfig or "SharePoint Products and Technologies Configuration Wizard"

- Create web application, e.g. http://sharepointsite.com
-- make sure to host IIS local folder on seperate drive other than c:\
--> NTLM
--> Non-HTTPS
--> New App Pool with independent identity
--> Unique database name

- IISReset /noforce

- Add host file entry to point hostheader "sharepointsite" to current server IP "127.0.0.1"

-Add stsadm as environment variable,
http://www.andrewconnell.com/blog/archive/2006/08/21/3882.aspx

- Add managed paths if required. In my case I had to.

- Create a site collection

- Configure host file on server to point all web application host headers to 127.0.0.1

- Configure site collection quotas from Central Administration or powershell

At this point you are ready to use this site on the server.

- Add DNS entries for using site's hostheader and server IP address and this site is good to go.

ERROR:
The current identity “domain\username” does not have write access to ‘C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files’.

Solution:
Basically asp.net is not correctly installed on the server. hence perform the steps mentioned in this blog to fix. I did not have to add my app pool account to IIS_IUser group.

http://nishantrana.wordpress.com/2010/11/20/the-current-identity-domainusername-does-not-have-write-access-to-%E2%80%98cwindowsmicrosoft-netframework64v2-0-50727temporary-asp-net-files%E2%80%99/

- Set up IIS Logs to a drive which has ample space.
- Set up diagnostic logging to a drive which has ample space.

- If there are multiple domains involved with one-way trust, setup people-picker to read from all domains using,
STSADM.EXE -o setproperty -pn peoplepicker-searchadforests

For me there are some more steps:

- Deploy custom solutions from source farm to destination farm
- Restore site collection to new webapplication using stsadm -o restore

Error: default.aspx is corrupt and site collection root page is returning HTTP 404
http://itbeganin2009.blogspot.com/2011/06/sharepoint-2007-moss-wss-defaultaspx.html

- setup SSP

- Disable SharePoint designer,
http://support.microsoft.com/kb/940958

- If you ever need to change the IIS local folder of a sharepoint web application,

http://www.mattjimison.com/blog/2009/02/26/how-to-change-the-iis-path-for-a-sharepoint-web-application/

OR

Navigate to Central Admin -> Application management
Click on Delete Web application
Drop IIS only! Not Content database
Create new web application with some temp database name and same host header as before.
IISreset
Do not create any site collections
Navigate to content databases -> remove temp database. You can ask your DBA to permanently remove the temp db later
Open command prompt under farm account and type,
stsadm -o addcontentdb -databasename "old db name" -url "url name"

- SSP Creation:
-- pre-req: create mysite, ssp admin webapp, start office sharepoint search service and set indexing server.
-- change index file location to a drive with max space.
-- set ssp account which is different from admin pool account and search access account.

- Configure User profile synchronization
-- configure import connections, if it is the same domain then no need to specify account
-- setup import schedule
--start import

- Configure Search
-- setup content sources
-- setup crawl schedules
-start crawl

-Configure email settings.
Incoming: http://technet.microsoft.com/en-us/library/cc262947(office.12).aspx
Outgoing: http://technet.microsoft.com/en-us/library/cc263462(office.12).aspx
--Exchange connector settings
--SMTP Relay

REFERENCE:
http://officeimg.vo.msecnd.net/en-us/files/669/307/AF010287454.doc

SharePoint 2010 Authenticate multiple providers LiveID, FaceBook, Google

2011-06-27T14:39:00.000-07:00

Authenticate external users in SharePoint 2010 using multiple authentcation providers like Google, LiveID, Facebook etc using Azure ACS (ADFS 2.0 in the Cloud)

Reference:
http://blogs.msdn.com/b/mvpawardprogram/archive/2011/06/17/mvps-for-sharepoint-2010-using-azure-acs-v2-to-authenticate-external-systems-users.aspx

Ubuntu Linux RDP Windows

2011-06-26T19:05:00.000-07:00

How to setup remote desktop to open ubuntu desktop from windows.

Reference:
http://www.makeuseof.com/tag/ubuntu-remote-desktop-builtin-vnc-compatible-dead-easy/

Detailed Steps:

On Ubuntu version 11.04
1. Click Windows + R on keyboard or the top left most ubuntu button.
2. In the search windows type, "remote"
3. Click on the first icon, "remote desktop"
4. Click on "Allow other users to control your desktop" and choose all options under Security and enter a seperate password for additional security.
5. note down the ip address that is displayed.

On Windows or any other machine which supports VNC standards,
1. Download TightVNC from, http://www.tightvnc.com/download.php
2. Install only Desktop Viewer and not the server if you only want to control other ubuntu desktops and not to use the windows machine as a server.
3. Run VNC Viewer and enter IP address and click connect
4. It will ask for the password, enter the one tht was set above.

Connection should be established.

To open a windows desktop using RDP from a ubuntu using the "terminal server client" already installed as part of ubuntu 11.04

Windows LiveID - SharePoint 2010 Integration

2011-06-26T12:00:00.000-07:00

References:
1. http://technet.microsoft.com/en-us/library/ff973114.aspx
2. http://blogs.msdn.com/b/hsalvi/archive/2010/09/01/configuring-windows-live-id-authentication-provider-as-federated-identity-provider-for-sharepoint-2010.aspx

Overview:
1. The Windows Live ID cookie is cached on the client computer and sent to SharePoint Foundation 2010 by way of a POST response to a successful authentication request.
2. SharePoint Foundation 2010 converts the Windows Live ID SAML token to a SharePoint Foundation 2010 SAML token.
3. The PUID for the user is generated based on the user principal name (UPN) claim returned in the SAML token. This value is used throughout SharePoint Foundation 2010 to uniquely identify the user and perform access control.
4. SharePoint Foundation 2010 can augment user tokens with additional claims by using a custom claims provider, which is configured in the SharePoint Foundation 2010 Web application.
5. The SharePoint Foundation 2010 cookie is also returned to the client computer and cached for subsequent requests.
6. When the Windows Live ID or SharePoint Foundation 2010 cookie expires, the user is redirected to a Windows Live ID server.

Ubuntu 11.04 - Install flash

2011-06-25T17:57:00.000-07:00

Perfect example,
http://www.liberiangeek.net/2011/03/install-adobe-flash-player-ubuntu-11-04-natty-narwhal/

Welcome to Ubuntu - LAMP beginner

2011-06-25T16:38:00.001-07:00

Need:
Install ubuntu desktop version and install LAMP stack for beginner.

1. Downloaded and installed ubuntu 11.04 desktop from ubuntu website
2. configured all desktop applications
3. opened terminal
4. sudo apt-get update
5. sudo apt-get install tasksel
6. sudo tasksel install lamp-server
6. Open firefox, http://localhost -> It Works

Reference:
https://help.ubuntu.com/community/ApacheMySQLPHP

New domain name

2011-06-24T10:02:00.001-07:00

http://thomassteve.com was born today !

Why replicate directory changes permission sharepoint 2010 user profile synchronization

2011-06-24T08:04:00.000-07:00

Question: Why are replicate-directory-changes permissions needed to synchronize with AD and on what in AD?

Answer: In order to interrogate AD about “what has changed since time xyz”, we need the replicate-directory-changes permissions on partitions being synchronized, for example the domain partition being synchronized. These permissions are needed in particular to be able to read data within the deleted objects container of the partition. Standard users do not have permissions to read the content of this container, and we cannot simply grant rights over that container to the synchronization account.
In RC we also require these permissions on the cn=configuration container, in order to access the netbios information for the domain (we are working to fix this for RTM, so this container permissions will be required only if your netbios name is different than your domain name)

Question: Do the replicate-directory-change permissions allow the holder to modify AD?
Answer: Holder cannot modify AD using these permissions

Question: What additional privileges are granted (beyond the ability to read and inquire of delta changes) with replicate-directory-changes permissions?
Answer: Holder can read all AD data for the domain, except passwords. Note that most of the directory information is by default readable by everyone, including data in the configuration partition.

Reference:
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/398f3553-5de7-456b-b935-4e22cee26b2f

SharePoint Profile Import using AD.

2011-06-21T13:42:00.000-07:00

This article explains the detailed steps to import profiles from AD to SharePoint,
http://support.microsoft.com/kb/827754

MOSS 2007 search crawler Stopping / Crawling / Crawling Full

2011-06-20T07:47:00.000-07:00

Scenario:
Users are complaining that new documents added to SharePoint platform are not being returned in the search results.

Diagnosis:
Search content source crawler is in Crawling/Crawling Full or Stopping state.

FIX:
1. Run the following command on all the Query and Index server one at a time and make sure that there are no errors.

net stop osearch
net start osearch

2. This command does not drop the search index.

3. After this command has executed correctly on all servers then the content source status should be set to Idle and it will start again as per its regular crawl schedule.

The real reason behind why the the crawl stops intermittently is still not determined in our environment. Also we are looking at options to monitor crawl status either using MS SCOM 2007 or writing custom code so that admins are alerted when crawls do not complete in acceptable amount of time.

Some quick links that may help. Please note that some of the steps may actually drop existing search index or call for creating a new SSP,

http://msmvps.com/blogs/shane/archive/2009/04/13/fixing-moss-search.aspx

http://support.microsoft.com/kb/930887/en-us

Project Server 2007 - Content Database attach / dettach

2011-06-20T07:40:00.000-07:00

Never detach and then attach a content database that hosts project server web access site. It looses its link with the SSP that created it and users will get the below exception when they try to access the web access site,

401 Unauthorized access Exception.

"As best practice maintain all project workspace site collections as part of a different database than the pwa site collection." otherwise they also loose the link the web access.

FIX:
Navigate to SSP which created the PWA
1. Take SQL backups of all PWA databases.
2. Create a new PWA
3. Provide the same name of the pwa that existed along with all the exact same names of databases that are already created.
4. Try to provision the PWA
5. Note that the account used to perform the above activities should be the SSP service account.

Once the PWA is provisioned the site should open fine.

People picker - slow performance

2011-06-17T14:36:00.000-07:00

Use this people picker setting to configure it read user values from specific forests.

Peoplepicker-searchadforests:
http://technet.microsoft.com/en-us/library/cc263460%28office.12%29.aspx

Sharepoint guidance no context retrieve configuration

2011-06-17T14:34:00.000-07:00

IConfigManager configManager = new HierarchicalConfig();
configManager.GetFromPropertyBag(key, site);

SharePoint 2010 search

2011-05-20T14:21:00.001-07:00

SharePoint 2010 search

http://blogs.msdn.com/b/russmax/archive/2010/04/16/search-2010-architecture-and-scale-part-1-crawl.aspx

http://blogs.msdn.com/b/russmax/archive/2010/04/23/search-2010-architecture-and-scale-part-2-query.aspx

STSADM Import Slide library

2011-05-10T13:24:00.000-07:00

FatalError: This file is not a valid presentation file or contains multiple slides.

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/32023ef3-da7d-4372-8071-d5ed151f209c/

sharepoint access denied on local server

2011-05-05T08:24:00.000-07:00

if you get access denied for legitimate users when connecting to a site on the server then it is because of the loopback issue with windows server.

http://support.microsoft.com/kb/896861

Sharepoint People picker slow

2011-05-04T11:52:00.000-07:00

Sharepoint People picker slow

http://www.marc-antho-etc.net/blog/post/2009/05/13/SharePoint-People-Picker-and-Active-Directory-Part-1.aspx

All about sharepoint people picker

2011-04-28T13:03:00.000-07:00

http://blogs.msdn.com/b/rajank/archive/2009/09/01/all-you-want-to-know-about-people-picker-in-sharepoint-functionality-configuration-troubleshooting-part-1.aspx

sp 2010 managed service accounts

2011-04-27T08:19:00.000-07:00

auto password change not a good idea.

http://blog.falchionconsulting.com/index.php/2010/10/service-accounts-and-managed-service-accounts-in-sharepoint-2010/

Toubleshooting sharepoint timer jobs for alerts

2011-04-21T14:04:00.000-07:00

Find out content db for site having issues

Find out timer job service executing server using,
select * from timerlock

Find other info
select * from eventcache where eventdata is not null
select * from eventlog where ListID='xxx'
select * from eventcache order by EventTime DESC

http://sharepointalert.info/2009/11/troubleshooting-sharepoint-alerts-timer-jobs/

SP2010 ULS to SP List External Content Type BCS

2011-04-15T10:07:00.000-07:00

http://gvaro.wordpress.com/2009/12/14/creating-an-external-content-type-to-surface-uls-log-data-into-a-sharepoint-2010-list/