SharePoint 2010 & Office 2010 Launch

Microsoft officially announced the launch date for SharePoint 2010 & Office 2010 on May 12th 11 AM EST.

Register for the events here: http://sharepoint.microsoft.com/businessproductivity/proof/pages/2010-launch-events.aspx

SharePoint 2007 Config LDF File Grown up like Beast

Today my server started throwing low disk space error in C drive. I had more than 60 GB free space in my drive, No clue what happened. Then I started drilling into my folders to find the issue.

Finally, I found the SharePoint_Config_Log file size is 52 GB. :-O

Solution:

Right Click the Database

Select Tasks -> Shrink -> Files

Select Release Unused Space and click OK.

If you still couldn’t get much space.

Shrink the log file using script.

USE SharePoint_Config
GO
DBCC SHRINKFILE (SharePoint_Config_Log, 50)
GO

Unable to Publish the Form as Browser Enabled

Problem:

While publishing InfoPath Browser Enabled form in SharePoint Site, It shows the warning message “This form template is browser-compatible, but it cannot be browser-enabled on the selected site.”

Solution:

Make sure “Enterprise Site Collection Feature” is enabled.

Unable to Publish InfoPath form as Browser enabled in SharePoint 2010 Site

I tried to publish the InfoPath form to SharePoint 2010 as browser enabled. But it had shown the following error while publishing.

Problem:
This form template is browser-compatible, but it cannot be browser-enabled on the selected site

Solution:

State Service need to be enabled in Farm. State Service in SharePoint 2010 is used to store the temporary data in HTTP requests on SQL. Enable state Service in Central Admin using Farm Configuration wizard.

How to Find User/Group Permission in List

To verify the User/Group permission in the specific list,

Click “List” in “List Tools” under Ribbon

Now Select “List Permissions”

Select Check Permission.

Enter the User Name or Group Name and click “Check Now”, you can view list of permission for the specific user/group. The same feature can be used at the item level also.

PDF Full Text Search Configuration for SharePoint 2007 x64

  • Download the Filter for x64 from adobe here, if you are using 32 bit it will be installed by default from your adobe installation.

  • Update default value of the following two registry entries with “{E8978DA6-047F-4E3D-9C78-CDBE46041603}”
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office server\12.0\Search\Setup\ContentIndexCommon\Filters\Extension\.pdf
      {E8978DA6-047F-4E3D-9C78-CDBE46041603}

    • KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Search\Setup\ContentIndexCommon\Filters\Extension\.pdf
      {E8978DA6-047F-4E3D-9C78-CDBE46041603}

  • Open Central Administration
    Go to SharedServices
    Click Search Settings
    Select “File types”
    Create new entry with the extension as “pdf”

  • Go to “Drive:Program Files\Common Files\Microsoft Shared\Web server extensions\12\Template\Images”
    Place the adobe pdf icon image, you can download it from adobe site.
  • Go to “Drive:Program Files\Common Files\Microsoft Shared\Web server extensions\12\Template\Xml”
    Open the Docicon.xml
    Add new entry and replace with the icon image filename “<Mapping Key=”pdf” Value=”filename.gif”/>”

  • Finally update the environment variable Path with “adobe installation path in drive”
  • Restart the search service

Client Object Model in SharePoint 2010 – Part 1

Client Object Model in SharePoint 2010 is one of the developers dream. It enables developers to
access the SharePoint data from client, the code need not to be deployed in to the server.

Client Object Model can be used in the following three ways.

  • .Net CLR
  • Silverlight Object Model
  • JavaScript

.Net CLR Example:

Create the context to the SharePoint site. No traffic/requests will be made to the server until you call the ExecuteQuery()


try

Source Code

{


ClientContext ctx = new
ClientContext(“http://localhost”);


Web site = ctx.Web;

ctx.Load(site);

ctx.ExecuteQuery();

site.Title = “Update from Client Object Model – Win App”;

site.Update();

ctx.ExecuteQuery();


MessageBox.Show(“Update Succeeded”);

}


catch (Exception ex)

{


MessageBox.Show(“Update Failed “ + ex.ToString());

}

Cannot open database requested by the login the login failed

I got into the below issue, when I try to access the site collection search scopes.

Cannot open database “Uday_SharePoint_SSP_Content” requested by the login. The login failed.
Login failed for user ‘Uday\Uday.Ethirajulu$’. at Microsoft.SharePoint.Portal.Search.Admin.Pages.SearchAdminPageBase.ErrorHandler(Object sender, EventArgs e)
at System.Web.UI.TemplateControl.OnError(EventArgs e)
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP._layouts_viewscopes_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\889c1c0c\c362774f\App_Web_viewscopes.aspx.2a428413.5ohducw0.0.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Troubleshoot issues with Windows SharePoint Services.

Resolution:

Change the application pool identity from “Network Service”.

Unable to connect to SQL Server session database the connection string was returned by an instance of the IPartitionResolver type

Today, I was playing with authentication providers for setting up the site with anonymous access.

Suddenly the site started throwing the below error. I have no clue what’s wrong on the DB Server, then I restarted the DB Server no luck L

Exception:

Exception Type: System.Web.HttpException Exception Message: Unable to connect to SQL Server session database. The connection string (server=’Uday\Sharepoint’, database=’Uday_Content_DB’) was returned by an instance of the IPartitionResolver type ‘Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’

Solution:

It’s pretty simple close all your browsers and clear the browser cache J

Somehow the session is getting crashed.

WebCast : Client Object Model in SharePoint 2010

I am planning for a webcast with demo in “Client Object Model in SharePoint 2010” on February 9th 2010.

Register for the event here