Friday, April 29, 2011

SharePoint:hiding quick launch bar

Hi All,

There is a way you can hide a quick launch bar in MOSS 2007.

Here are the steps to follow:

(1)Add content editor webpart on page
(2) Click on Modify shared webpart
(3) Click on source editor button
(4) Copy and paste the following HTML

display: none;

(5)Go to layouts section of that webpart and select Hidden.

That's it. Now no more quick launch bar !!!!!

If you want to get quick launch back, just again edit the page and go to modify shared webpart of content editor webpart. Go to source editor button and remove all HTML content and save it.

That's it. Now you will have your quick launch back in place !!!

Wednesday, April 27, 2011

SharePoint2010:Deploying a solution STSADM vs. PowerShell

Monday, April 25, 2011

SharePoint:To get the size's of the sites

stsadm -o enumsites -url http://site/subsite>File.txt

where file.txt is used to write the data in to a text file
you will get the data in MB's

so how it look like...

<Sites Count="1">
StorageMaxMB="0" /> </Sites> 

Wednesday, April 20, 2011

IIS7:Cannot start service W3SVC on computer '.'


Error while restarting IIS
i.e. after stopping IIS when i start again i hot this error
Cannot start service W3SVC on computer '.'


  1. Run -> appwiz.cpl -> Turn windows features on or off -> Check "Windows Process Activation Service"
  2. That's all.
and also check this

You should check to see that all of the following services are started, or at the very least, not disabled: HTTP, Windows Process Activation Service, DCOM Process Launcher, and RPC Endpoint Mapper.
You should also verify t hat no other process is listening on port 80. The simplest way to do this is to issue the following in a command window:
netstat -a -o|findstr 80

Tuesday, April 12, 2011

SharePoint:Export and Importing of SharePoint Site

To take backup of particular sub site and to make it as sub site to another site collection:

1)      First log in to WFE as admin rights
2)      export needed site into .cab file
stsadm –o export –url “
http://siteA/sub%20site1” –filename –versions 4
3)      Do an import to a required location
stsadm –o import –url “
http://siteB/sub%20site1” –filename

Monday, April 11, 2011

SharePoint:The user does not exists or it's not unique


If you have the above issue "The user does not exists or it's not unique"
in my finidngs i found that this may be due to the change in the active directory domain
if there is some migartion done from one site to other site collection


I saw this problem a few times but when I went to user profile, I can see the user is there and all the information is right. But if you go to WSS_Content db and run
select * from userinfo where tp_title like ‘user%’
I found the tp_login data is different from the user who has problem. The problem with this, is that the tp_Login column in the UserInfo table for every site collection in which Margie has permissions, is cached with her previous NT Login Name. There is also no way to update this information with a SPUser object from the SharePoint object model, and SharePoint does not synchronize this from Active Directory once the users is added to a web in the Site Collection.
The only time that SharePoint will automatically update the tp_Login column, is if the users is completely removed from the site collection. The tp_Deleted column is then set for the user in that site collection. On the next occurrence of the user being added to a web, we gather the current information from the domain. You can however, re-sync SharePoint with the current information without removing them completely from the site collection by using SPUserUtil
For a single user you can use
stsadm.exe -o migrateuser -oldlogin MYDOMAIN\prhranki -newlogin MYDOMAIN\LUHRANKI -ignoresidhistory
If you need to do a batch of users, I personally think WSSUserUtil and SPSUserUtil is the way to go.
See this two references:

SharePoint:Hit counter or stats of SharePoint Site

If you have enabled "Usage Analysis Processing" in SharePoint Central Administration, there is a hidden URL that lets you view the stats for any page/section/area of the Portal (and WSS). Just navigate to the area where you wish to view stats and add
to the URL. Note the string above replaces the filename so if you are in the "News" home page
will become

If you use
instead it will show a summary including Total Hits, Number of Users etc.

SharePoint:Field Lengths in SharePoint Lists


We have a field lent restrictions in SharePoint
Single Line Field : 255 chars
Multi line field (document, forms, picture library) : 255 chars
Multi line field (everywhere else) : no limit

SharePoint:How to change the Maximum File Upload Size


By default SharePoint allows a maximum file size of 50MB that can be uploaded into any document library. This might be too much as you might not want users downloading 50MB files over your LAN/WAN. To change the maximum file size
1. Goto SharePoint Central Administration > Configure Virtual Server Settings from Virtual Server List Page.
2. Select your server
3. Goto Virtual Server General Settings (in Virtual Server Management)
4. Change the value of the Maximum Upload Size in MB's.

If you increase the file size limit, your site might occassionally time out for users while they are uploading files. To accomodate this increase the default time out property for IIS.

Thursday, April 7, 2011

SharePoint:System Center Operations Manager 2007

Hi ,

I have found that there is a tool available for monitoring SharePoint related issues
System Center Operations Manager 2007 is a tool that will help for monitoring the issues in SharePoint but you need to have a addon for this i.e. Microsoft Office SharePoint Server 2007 Management Pack to the above software for more details just look into this links....

Wednesday, April 6, 2011

InfoPath:Excellent site for InfoPath forms with SharePoint

InfoPath:How to create and deploy an InfoPath browser form template to SharePoint

In this InfoPath video, you learned…

  • How to create a SharePoint form library and enable it to display InfoPath browser forms.
  • How to check whether InfoPath Forms Services is correctly configured on SharePoint.
  • How to create a browser-compatible InfoPath form template.
  • How to deploy an InfoPath browser form template to SharePoint.

InfoPath:How to publish an InfoPath 2007 browser form to SharePoint

Learn which actions you have to take both in InfoPath and SharePoint before deploying an InfoPath form template to SharePoint so that it can be opened and/or filled out using a browser.


You have an InfoPath form template, which you want to open and/or fill it out using a browser.


There are several actions you have to take both in InfoPath and SharePoint before deploying a form template to SharePoint so that it can be opened and/or filled out using a browser. The solution described in this article is for InfoPath form templates that do not require administrator approval before deployment, that is, they do not contain .NET managed code.

Prerequisites on the Server

  1. Windows SharePoint Services 3.0 must be installed.
  2. Forms Server 2007 must be installed.
  3. InfoPath Forms Services must be activated.
Refer to the SharePoint documentation for guidance on installing and activating InfoPath Forms Services.

Preparing a form template in InfoPath to become a browser-form

An InfoPath form template must be:
  1. Browser-compatible
  2. Browser-enabled
to be able to be displayed in a browser. You can make a form template browser-compatible by specifying compatibility setting, either up-front, when you first create the form template, or later, when you design the form template.
For more information on InfoPath browser-compatible forms, see
  • Introduction to browser-compatible form templates

Setting browser-compatibility up front

When you first open the InfoPath client application you are presented with the Design a Form Template dialog box. You can check the Enable browser-compatible features only checkbox to make an InfoPath form template browser-compatible.
What this means is that the InfoPath designer will only present you with those features of InfoPath that are supported in both the InfoPath editor as well as the browser.
The benefit of choosing this option so early in the design phase is that you will not run the chance of using options that are not available to browser-forms and then have to change your form's design at a later stage because of this.

Figure 1. Enabling browser-compatible features when creating a new form template.
For more information on setting browser-compatibility, see
  • Specify the compatibility settings for a form template
  • Creating InfoPath Form Templates That Work With Forms Services

Setting browser-compatibility afterwards

You can set browser-compatibility after you have designed your form template by going to the Tools menu, and selecting the Form Options menu item to open the Form Options dialog box, and then clicking on the Compatibility category.
If you created a form template that contains features that are incompatible with InfoPath Forms Services, InfoPath will warn you of this and you will have to modify your form template to satisfy the compability requirements for browser-forms. You will have to fix the incompatibilities before proceeding.
If you don't fix the errors, you can still publish the browser-compatible form template to a server running InfoPath Forms Services. However, the form template may not work as intended/desired.
For a list of the features that are and are not supported in browser-forms, see
  • Web browser compatibility in InfoPath Forms Services
  • InfoPath 2007 features that are unavailable in InfoPath Forms Services
  • View server-generated errors and messages in the Design Checker task pane
Tip: Specify browser-compatibility settings up front to avoid having to adjust your form template afterwards.

                                           Figure 2. Enabling browser-compatible features through the Form Options dialog box.

Browser-enabling a form template

Once you have designed your InfoPath form to be browser-compatible and are ready to publish it to SharePoint, you must make it browser-enabled before doing so.
While you can publish a browser-compatible form template to SharePoint without making it browser-enabled, you will not be able to open or fill out this form in a browser until you browser-enable it. This is an important fact to understand.

So how do you browser-enable an InfoPath form template?

Here is where InfoPath and SharePoint have to work together to make it able for you to browser-enable a form:
  1. In InfoPath: Ensure that the form template does not contain any errors reported by the Design Checker.
  2. In SharePoint: Configure InfoPath Forms Services to Allow users to browser-enable form templates (see figure 3).
  3. In InfoPath: Check the Enable this form to be filled out by a browser checkbox when publishing the form template (see figure 4). 

                            Figure 3. Configuring Forms Services in SharePoint Central Administration Application Management
                                               Figure 4. Browser-enabling a form template in the Publishing Wizard.
If you do not configure InfoPath Forms Services before you try to browser-enable a form template, you will be presented with the following message in the Publishing Wizard:
"This form template is browser-compatible, but it cannot be browser-enabled on the selected site."
                           Figure 5. This form template cannot be browser-enabled message in the Publishing Wizard.
Warning: If you ignore this message and continue to publish the form template, you will not be able to open or fill out the form using a browser, not even if you configure InfoPath Forms Services after you have published the form template. If you configure Forms Services after you have published a browser-compatible form template, you will have to re-publish the form template from within InfoPath and browser-enable it while re-publishing it.

Note: This was taken from the site 


Windows:Event ID 7888(SharePoint AD user profile import error)


When starting a full or incremental import of Active Directory, either manually or scheduled, the import is successful, but there is an error thrown as soon as the import is initiated. My assumption is the AD import kicks off several simulateous jobs such as updating users "My SharePoint Sites" in the MOSS and Office 2007 environments.
For reference, to kick off a manual import of AD: Central Administration > Shared Services > User Profile and Properties

Event ID 7888

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server General
Event ID: 7888

Description: A runtime exception was detected. Details follow.

Message: Access Denied! Only site admin can access Data Source object from user profile DB.

Technical 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)


  1. Navigate to: Central Administration > Operations > Services on Server > Office SharePoint Server Search.
  2. In the "Configure Office SharePoint Server Search Service Settings" page, locate the account defined for "Farm Search Service Account" and write down the account name.
    1. For reference, the account defined serves as the account for the AD "Configure Profile Account" access account.
    2. For reference, you can get to AD Profile Account page: Central Administration > Shared Services > User Profile and Properties > Configure Profile Import.
  3. Navigate to: Central Administration > Shared Services > Personalization services permissions.
  4. On the "Manage Permissions: Shared Service Rights" page, add the account from before (or edit if already exists). The account needs one of the following permissions; I couldn't figure out which one:
    1. Manage user profiles
    2. Manage permissions
I've tested this resolution several times with success.
For reference, I've updated my Farm Search Service Account with the following permissions since the account in question will most likely be accessing the types of content referenced in the permissions at one point or another:
  • Manage user profiles
  • Manage audiences
  • Manage permissions
  • Manage usage analytics

Other Thoughts

As with Event ID 2424 I wrote about, I noticed that Event ID 7888 began around the time I installed the following WSS/MOSS security patches which came out prior to the SharePoint SP1 patch:
I'm going to make the assumption that this error will occur as soon as you install the SharePoint SP1 patch as well.


Somewhere along the line, the WSS/MOSS and/or SharePoint SP1 update(s) are modifying existing permissions… Shame on the updates.
I've read other posts whose resolution is to add the account in question to the local administrators group. Although their resolution may work, the profile import account should not be a server administrator; the administrator role should be reserved for the global MOSS service account admin (the account used to install MOSS) and the configuration account (the account MOSS uses to provision databases and other content that was defined during the MOSS install).

Tuesday, April 5, 2011

Good site for SharePoint quiries

Check this out...

SharePoint:"Access is denied. Check that the Default Content Access Account has access to this content"

If you have this issue....

Check the steps

The resolution for this was to add the following registry key
1) Click Start, click Run, type regedit, and then click OK.
2) In Registry Editor, locate and then click the following registry key:
3) Right-click Lsa, point to New, and then click DWORD Value.
4) Type DisableLoopbackCheck, and then press ENTER.
5) Right-click DisableLoopbackCheck, and then click Modify.
6) In the Value data box, type 1, and then click OK.
7) Quit Registry Editor, and then restart your computer.

SharePoint:The password for the content access account cannot be decrypted because it was stored with different credentials. Re-type the password for the account used to crawl this content.


Our search is not working. The crawl log indicates following error: "Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. (The item was deleted because it was either not found or the crawler was denied access to it.)".


ad this problem and solved it by using user@domain.local instead of domain\user when specifying the Default Content Access Account. 

Central Administration --> SSP --> Search Administration | Default Content Access Account.

SharePoint:Alert : Percentage of committed memory in use is too high


Alert Description : The threshold for the memory\committed byte in use performance counter has been exceeded. The value that exceeded the threshold  is 81.35668827192.
I am getting this alert at my SCE Box having 3 GB of RAM. How can i resolve this issue as accourding to the alert description i have checked with the performance counters at system monitor ( perfmon) .

Several Microsoft products including Exchange, SQL Server, and the Operations Manager ROM will use all available memory. This is especially noticeable on 64-bit platforms where memory can scale-out more effectively for the applications.


Configured the server to have a 95% threshold instead of 80%. To do it:

1)    Navigate to authoring pane -> Management Pack Objects -> Monitors.
2)    Find the monitor at "Windows Server 2003 Operating System"  -> Entity Health ->Performance -> "Percentage of committed Memory in Use"
3)    Right click it and select “Overrides” -> "Override the monitor" -> "For all objects of type: Windows Server 2003 Operating System".
4)    Specify the threshold value 95% instead 80% and click to apply.

Hope it helps.

Friday, April 1, 2011

SharePoint:Adding template to the subsites


Some days back i have not seen the Publising site template in the Template selection in the subsite


If you want to see the templates that are available in sitecollection in the subsites you nee to do this:

Check your WEBTEMP.XML file under \12\TEMPLATE\1033\XML folder.
Most probably templates you'd like to see are set to Hidden="TRUE". Make them false.


If your site is a publishing site, go to Page Layout and Site Templates Settings and add the templates that you want your subsites to use.
(Site Actions > Site Settings > Modify All Site Settings > Look and Feel > Page layouts and site templates)