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