MOSS 2007 Development

MOSS 2007 Devel

Filter a Dataviewer based on the value of an ASP Control

Sounds easy.

It is if you know how…

Enable code behind on sharepoint aspx pages

in web.config

< PageParserPaths >
< PageParserPath VirtualPath=”/*” CompilationMode=”Always” AllowServerSideScript=”true” IncludeSubFolders=”true” / >
< /PageParserPaths >

MOSS 2007 Stsadm -o backup gives Error 5

Your UNC backup folder needs to be SHARED and sharepoint service, central admin apid, sql server service need to have read/write on that share.

Similar solutions online:

http://www.davehunter.co.uk/Blog/Lists/Posts/Post.aspx?List=f0e16a1a-6fa9-4130-bcab-baeb97ccc4ff&ID=34

MOSS 2007 – Unable To Delete SSP

Attempting to delete SSP using the ‘Shared Services Administration’ section of Central Administration (or using stsadm) results in the error message:

“An object in the SharePoint administrative framework, “SharedResourceProvider Name=SSP Parent=SPFarm Name=MOSS”, could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation. The dependant objects are as follows: ProjectPSISharedApplicationTimerJob Name=Project Server Synchronizing Job for ‘SSP’ Parent=ProjectApplicationService Name=ProjectApplicationService”

The solution to this problem is to delete the dependant object!

First find the GUID of the dependant object:

SELECT *
FROM [Sharepoint_Config].[dbo].[Objects]
WHERE name like ‘Project Server Synchronizing Job for %’

Now delete the dependant object using stsadm:

stsadm -o deleteconfigurationobject -id “YOUR_GUID_HERE”

Attempt to delete the SSP again!

Similar solutions found online: http://sharepointmadeeasy.blogspot.com/2008/08/unable-to-delete-shared-services.html

MOSS 2007 – The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

Problem

Messages in the event log:

The application-specific permission settings do not grant Local
Activation permission for the COM Server application with CLSID
{61738644-F196-11D0-9953-00C04FD919C1}
and APPID
{61738644-F196-11D0-9953-00C04FD919C1}
to the user xxxx\xxxxxxx SID (S-1-5-21-203257084-1554538351-1551923841-31371)
from address LocalHost (Using LRPC). This security permission can be modified using
the Component Services administrative tool.

Background

61738644-F196-11D0-9953-00C04FD919C1 is the IIS WAMREG admin service.

If you are seeing a different CLSID, fire up regedit and search for the CLSID.

Solution

Open Component Services
Find the IIS WAMREG admin service
Right click, Properties, Security Tab
Grant launch and activate permissions to the account mentioned in the error message

iisreset

MOSS 2007 – Access Denied! Only site admin can access Data Source object from user profile DB

Problem

A runtime exception was detected. Details follow.
Message: Access Denied! Only site admin can access Data Source object from user profile DB.

Techinal Details:
System.UnauthorizedAccessException: Access Denied! Only site admin can access Data Source object from user profile DB.
at Microsoft.Office.Server.UserProfiles.SRPSite.AdminCheck(String message)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(IDataRecord rec)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(String strDSName)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site, Boolean fAllowEveryoneRead)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site)
at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager.GetDataSource()
at Microsoft.Office.Server.UserProfiles.BDCConnector.RefreshConfiguration(String sspName)

Solution

Grant ‘Manage user profiles’ and ‘manage permissions’ to the ‘Farm search service account’.

Similar solutions on the web:

http://www.raregrooverider.com/post/2008/03/12/Office-SharePoint-Server-Error-Event-ID-7888.aspx

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/9ea7f691-a6ec-4b71-b0f2-733032b6ac22

MOSS 2007 Access Denied When Accessing SSP Admin Site

Problem

Browsing to some of the SSP Admin pages yields:

401 UNAUTHORIZED
or ACCESS DENIED
or prompts continuously for a user name

I first came across this problem after restoring an SSP from a backup.

Solution

The SSP service account needs to be granted permissions in the following places:

Central Admin -> Application Management -> Site Collection Administrators

SSP Admin -> Personalization Service Permissions (All)

Central Admin -> Application Management -> Policy for Web Application (Full)

MOSS 2007 Move SSP to another farm

Move An SSP To Another Farm

Use the Technet article Microsoft Technet – Move an SSP to another farm.

The five basic steps are:

Back up the original SSP
Restore the SSP to a new farm
Restore SSP associations and configure the SSP
OPTIONAL – Configure the restored SSP on the new farm to be the default
OPTIONAL – Delete the original SSP

Backup the SSP

Follow the Microsoft instructions.

Also see ../BackupSsp

Restore the SSP to a new farm

Follow the Microsoft instructions.

‘YOU ARE HERE’

Errata

5b – New Configuration!
5c – Use new database names to avoid overwriting existing

Additional

The restore will hang at 90% with lots of errors in the event log
Don’t worry – it has restored the databases and that’s all we need
Cancel the restore.
Delete the restored SSP (not the databases)

See ../UnableToDeleteSsp

Delete the restored SSP Web Application from Central Admin -> Delete Web Application

Restore SSP associations and configure the SSP

Follow the Microsoft instructions.

Additional

Access Denied when accessing SSP Admin site

Set SSP as default on the new farm

Follow the Microsoft instructions.

Delete the original SSP

Follow the Microsoft instructions.

Additional

Unable to delete SSP
Delete the Web Application for the SSP