Deploying MOSS using DBA created databases
When you configure MOSS using "SharePoint Products and Technologies Configuration Wizard", in the first step it creates 2 databases
- SharePoint_config : The configuration database - you will be able to change this name.
- SharePoint_AdminContent_XXXXXXXX_XXXX_XXXX_XXXX_XXXXXXXXXXXX : The Admin content database - wizard doesn't give you any option to change this name.
stsadm -o osearch -action start -roleyou cannot pass "farmcontentaccessaccount" & "farmcontentaccesspassword" parameters for osearch action. Below command shoud be sufficient-farmcontactemail -farmserviceaccount -farmservicepassword -farmcontentaccessaccount -farmcontentaccesspassword
stsadm -o osearch -action start -roleIt is also good idea to Use -setheadername while creating MySites & Web Application-farmcontactemail -farmserviceaccount -farmservicepassword
Friday, June 29, 2007 | 0 Comments
Site Definition "SPS", is it really obsolete???
If you look into webtempsps.xml, you will find first template
<Template Name=”SPS” ID=”20″> <Configuration ID=”0″ Title=”SharePoint Portal Server Site” Type=”0″ Hidden=”TRUE” ImageUrl=”../images/spshome.gif” Description=”This template is obsolete.”> </Configuration> </Template>
The description message “This template is obsolete.” is very misleading. Is this template really obsolete? Does that mean “\12\TEMPLATE\SiteTemplates\SPS\XML\ONET.XML” is not used for any Site Creation?
If you look into the same file webtempsps.xml, you will see another virtual template “SPSPORTAL” (probably the most used Site Definition for creating Intranet Portal)
<Template Name=”SPSPORTAL” ID=”47″> <Configuration ID=”0″ Title=”Collaboration Portal” Type=”0″ Hidden=”FALSE” ImageUrl=”/_layouts/1033/images/template_corp_intranet.png” Description=”A starter site hierarchy for an intranet divisional portal. It includes a home page, a News site, a Site Directory, a Document Center, and a Search Center with Tabs. Typically, this site has nearly as many contributors as readers and is used to host team sites.” ProvisionAssembly=”Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” ProvisionClass=”Microsoft.SharePoint.Publishing.PortalProvisioningProvider” ProvisionData=”SiteTemplates\\WebManifest\\PortalWebManifest.xml” RootWebOnly=”TRUE” DisplayCategory=”Publishing” VisibilityFeatureDependency=”97A2485F-EF4B-401f-9167-FA4FE177C6F6″> </Configuration> </Template>
This above template is Virtual because you don’t find any folder named “SPSPORTAL” in “\12\TEMPLATE\SiteTemplates” instead this site template is driven by ProvisionData (”SiteTemplates\\WebManifest\\PortalWebManifest.xml”), this manifest file is used to create Multiple sites. If you look into “SiteTemplates\\WebManifest\\PortalWebManifest.xml” file, the very first web element points to SPS site definition.
<portal xmlns=”PortalTemplate.xsd”> <web name=”Home” siteDefinition=”SPS” displayName=”$Resources:spscore,PortalManifest_Home_DisplayName;” description=”$Resources:spscore,PortalManifest_Home_Description;”> <webs> <web name=”News” siteDefinition=”SPSNHOME” displayName=”$Resources:spscore,PortalManifest_News_DisplayName;” description=”$Resources:spscore,PortalManifest_News_Description;” /> <web name=”SiteDirectory” siteDefinition=”SPSSITES” displayName=”$Resources:spscore,PortalManifest_SiteDirectory_DisplayName;” description=”$Resources:spscore,PortalManifest_SiteDirectory_Description;” /> <web name=”SearchCenter” siteDefinition=”SRCHCEN” displayName=”$Resources:spscore,PortalManifest_SearchCenter_DisplayName;” description=”$Resources:spscore,PortalManifest_SearchCenter_Description;” /> <web name=”Docs” siteDefinition=”BDR” displayName=”$Resources:spscore,PortalManifest_DocumentCenter_DisplayName;” description=”$Resources:spscore,PortalManifest_DocumentCenter_Description;” /> </webs> </web> </portal>
To prove that Collaboration Portal actually uses SPS Site Definition to create Home Site
- lets rename the “SPS” to “SPS1″ in webtempsps.xml, your template should like
<Template Name=”SPS1″ ID=”20″> <Configuration ID=”0″ Title=”SharePoint Portal Server Site” Type=”0″ Hidden=”TRUE” ImageUrl=”../images/spshome.gif” Description=”This template is obsolete.”> </Configuration> </Template>
- run IISRESET
- Create a Site Collection by selecting “Collaboration Portal” Template, do you get an error???
Note: Make sure that you rename the Template name back to “SPS”.
Monday, June 25, 2007 | 0 Comments
Awesome Video of Kite Flying
I love flying kites, probably I have never seen anyone flying kites like this.
Friday, June 22, 2007 | 0 Comments
DocumentTemplate Element (ContentType) Vs. DocumentTemplate Element (Site)
DocumentTemplate Element could be very confusing, they have totally different set of attributes based on where you are using (Site Definition ONET.XML or Feature). DocumentTemplate Element (Site)
DocumentTemplate Element (ContentType)
I find creating new Document Content Type very easy using "Feature" feature instead of messing with ONET.xml Click here for more info on creating document content types using feature
Tuesday, June 12, 2007 | 0 Comments
Understanding webtemp*.xml
Probably the best way to understand the concept of webtemp*.xml is to create couple of custom site definitions. Recently I stumbled upon a great blog entry from Bill Baer, I wish I had access to this information last year, when I was playing with Site definitions. Below is the excerpt from http://blogs.technet.com/wbaer/archive/2007/03/25/understanding-webtemp-xml.aspx
WEBTEMP.xmlProducts: Microsoft Office SharePoint Server 2007/Windows SharePoint Services 3.0Includes: Team Site, Blank Site, Document Workspace, Basic Meeting Workspace, Blank Meeting Workspace, Decision Meeting Workspace, Social Meeting Workspace, Multipage Meeting Workspace, Central Admin Site, Wiki Site, and Blog templates.webtempsrch.xmlProducts: Microsoft Office SharePoint Server 2007Includes: Search Center template.webtempsps.xmlProducts: Microsoft Office SharePoint Server 2007 Includes: SharePoint Portal Server Site, SharePoint Portal Server Personal Space, Personalization Site, Contents area Template, Topic area Template, News Site, Publishing Site, Press Releases Site, Publishing Site with Workflow, Site Directory, Community area Template, Report Center, Collaboration Portal, Search Center with Tabs, Profiles, Publishing Portal, My Site Host templates.webtempoffile.xmlProducts: Microsoft Office SharePoint Server 2007 Includes: Records Center template.webtempbdr..xml Products: Microsoft Office SharePoint Server 2007 Includes: Document Center template.webtemposrv.xmlProducts: Microsoft Office SharePoint Server 2007 Includes: Shared Services Administration Site template.Configuration Attributes:
Template title text displayed in the Template Selection user interface. Description of the purpose and features of the requested template displayed in the Template Selection user interface. Provides the virtual path to the preview image displayed in the Template Selection user interface. Defines the category where the template should be made available for selection in the Template Selection user interface. Defines the usage scenario in which this template can be applied. Provides the fundamental publishing infrastructure in Microsoft Office SharePoint Server 2007. Defines the class associated with the attribute. Provides the virtual path to the associated Web manifest (%commonprogramfiles%\Microsoft Shared\Web Server Extensions\12\TEMPLATE\SiteTemplates\WebManifest\portalwebmanifest.xml) Feature dependency associated with the template that provides its visibility.
Wednesday, June 06, 2007 | 0 Comments
Reporting Services Add-in : ReportServer Feature in Application Management Site Collection
After debugging multiple errors during installation & errors trace left in event logs, I still find "Reporting Services" section missing in my Application Management. There is one more place to look for error logs "in %temp% directory", reporting services logs information to a log file in the %temp% folder for the user who is installed the Reporting Services Add-in, the file name is RS_SP_ ******* User does not have permission to add feature to site collection: http://machinename:8080
Tuesday, June 05, 2007 | 0 Comments
Reporting Services Add-in Installation Error: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
Reporting Services Add-in is such a pain it hangs on at "removing backup files" screen for hours, never kill that process because that is a wrong message, its not such removing backup files its doing much more than that, if you kill that process everything will seem fine except that any SQL reports won't be generated.
Recently I found out another issue with this add on, the installation will fine with no errors and you will get "Installation Complete" screen but it will leave below errors in Event logs and the Reporting Services section won't appear in the Application Management (Central Administration).
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {61738644-F196-11D0-9953-00C04FD919C1} to the user
You may see this error - more than once - when working with your Microsoft Office SharePoint Server (MOSS) 2007 deployment. This animal / error generally shows itself after you have applied an upgrade to an existing deployment. For example, when upgrading from B2 MOSS to B2TR MOSS - or when applying a special service pack from MSFT - you may begin to see a lot of these errors pop up in the SYSTEM event log. The error CLSID is followed by a class ID for the DCOM+ application that the service account trying to activate that application - does NOT have permission to activate. For example, let's say I installed MOSS on a server, and used the account mossService as the service account (a least privileged, user account you created to run the MOSS service(s))., when I get this error, I could very well see an error like the following: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {61738644-F196-11D0-9953-00C04FD919C1} to the user\mossService SID (S-1-5-21- Copy the GUID following the CLSID above, and Start-->Run-->regedit With the registry editor open, ensure that your cursor is on the computer at the beginning of the tree (make sure you are not in the middle of some previous edit session in the registry editor). Edit-->Find and paste in the GUID. It'll stop at the application entry - and you will want to note the application name on the right side pane. In this example, it was the IIS WAMREG admin service that popped up. Now, open Component Services (typically, from the server - Start-->Administrative Tools-->Component Services), expand Component Services, Computers, My Computer, DCOM Config. Scroll down and find the application (IIS WAMREG in this case). Right-Click-->Properties and select the Security tab. You'll have some options here - the first block Launch and Activation Permissions - ensure that the Customize radio button is selected, and click Edit. Now, add your service account - giving it launch and activate - and in some requirements - remote launch / activate permission. Restart IIS and continue on.). This security permission can be modified using the Component Services administrative tool.
Tuesday, June 05, 2007 | 0 Comments
SQL Server : Reclaim your unused table space
I have a website, and its database has grown to 8 Gigs but my hosting contract supports only 4 gigs. This has become such a big problem. I deleted 6 months of data but still the database was 7 gigs. I cannot afford to buy that kind of database space thought of taking my website down but luckily I was able to figure out how to reclaim usnused space in database. Getting the database size by tables really helped me understand how my data is distributed among tables.
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
Above command gives database size by table and also shows you the unused table space. DBCC CLEANTABLE can be used to clean up the unused space in a table, though this cleaned up my unused table space but it still didn't decrease the database size tries shriking database and file but no luck. ALTER INDEX can be used to rebuild the Indexes, when I rebuilt the indexes the database size decreased to 3.8 gigs... never knew indexes will take up so much space. http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocSP.htm has good list of SQL 2000 undocumented stored procedures.Saturday, June 02, 2007 | 0 Comments
SQL Server Management Studio cannot create diagrams
I always get below error while trying to create a database diagram in SQL Server 2005 Management Studio.
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."From my experience, this problem usually occurs with restored databases and there are two reasons,
- it is always recommended to restore databases with "sa" as owner.
- the database is SQL 2000 database and restored to a SQL 2005 Database engine
- Go to database properties.
- Select Options.
- Change "Compatibility Level" Dropdown to "SQL Server 2005(90)"
Saturday, June 02, 2007 | 0 Comments

