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 ‘UdayUday.Ethirajulu$’. at Microsoft.SharePoint.Portal.Search.Admin.Pages.SearchAdminPageBase.ErrorHandler(Object sender, EventArgs ઈ)
at System.Web.UI.TemplateControl.OnError(EventArgs ઈ)
at System.Web.UI.Page.HandleError(અપવાદ ઈ)
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:\WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesroot889c1c0cc362774fApp_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.
ઠરાવ:
Change the application pool identity from “Network Service”.
Unless you’re the only developer working on the site, it would be better to use a service account (rather than your own login) for the app pool identity.
I agree, I didnt mean using the own identity, Wanna make sure to update the account from Network Service to Identity