Recent Discussions
SharePoint SE – Unknown SQL Exception 18452 occurred. Login failed.
This month we applied OS updates to the DB Server. Site was up. Then we applied OS Updates to App server, site went down and we reverted it. Then we applied OS updates on WFE server. The site is up. However, in WFE when running Get-SPFarm or running PSConfig on the WFE, it throws the following errors: PowerShell / PSConfig: “Cannot access the local farm. Verify that the local farm is properly configured…” Configuration Wizard: “Failed to detect if this server is joined to a server farm.” The Error Logs: Checking the Windows Event Viewer on the WFE during a database connection attempt shows: Unknown SQL Exception 18452 occurred. Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication. Network connectivity is fully operational. AD Domain trust is healthy. Local machine groups are clean: NT AUTHORITY\SYSTEM is not present inside the local WSS_WPG or IIS_IUSRS groups. DisableLoopbackCheck is already set to 1 in the registry. Any help on how to get the error is greatly appreciated.
Web invoke in power automate says unauthorized but can browse from browser
I am able to browse to this url directly from browser https://my365.crm9.dynamics.com/api/data/v9.2/audits?$filter=objecttypecode%20eq%20%27myissuetable%27%20and%20_objectid_value%20eq%20%271de46d6b-b986-f111-ab0e-001dd80b339b%27&$select=_objectid_value,objecttypecode,changedata,createdon,_userid_value but when i use the invoke http from power automate it says unauthorized. i am using the same account. What is the issue is there anything i need to do so that it works?
SharePoint Multi-geo: accessing a user's home-geo custom SharePoint properties from a different geo
Setup M365 tenant, multi-geo (NAM + EMEA). SharePoint custom user profile properties are synced only in the user’s home geo (their Preferred Data Location). SPFx webparts running on the NAM tenant, using PnP/SP or AadTokenProvider. Goal: when an EMEA user opens a NAM page, read their SharePoint custom properties from the EMEA tenant. Issue 1 — Can’t read profile properties from a different geo-tenant What I’m doing const sp = spfi(emeaTenantUrl).using(SPFx(webpartContext), SPFxToken(webpartContext)); const result = await sp.profiles.getPropertiesFor(basicInfo.data.LoginName); Error Access Denied: This application does not have the required permissions to access profile information. The core problem — token is missing my approved scopes Approved Scopes in webApiPermissionManagement (Office 365 SharePoint Online) in SharePoint Admin Center: Sites.Search.All, AllProfiles.Manage, User.Read, User.Read.All, Files.ReadWrite.All, TermStore.ReadWrite.All, Sites.ReadWrite.All, Sites.FullControl.All. Token issued for the SharePoint resource only contains: Files.ReadWrite.All, M365BillingPlatform.Read.All, Sites.FullControl.All, Sites.ReadWrite.All, TermStore.ReadWrite.All. So AllProfiles.Manage, User.Read.All, Sites.Search.All are not in the token and an unexpected M365BillingPlatform.Read.All is. Also tried calling the SharePoint REST API directly with a token from AadTokenProvider → same Access Denied. Questions Why is the issued token missing my approved scopes (and where is M365BillingPlatform.Read.All coming from)? Is there a supported way to read a user’s SharePoint profile custom properties from a different geo-tenant from an SPFx webpart? Approved Scopes in Admin center Issue 2 — Search query template {User.*} properties not resolving cross-geo What I’m doing A SharePoint Search query in the webpart uses a query template that pulls custom user properties dynamically: {|owstaxidmetadataalltagsinfo:{User.customProperty1}} OR {|owstaxidmetadataalltagsinfo:{User.customProperty2}} The SP object is created the same way as in Issue 1. What’s not working When an EMEA user loads the webpart on the NAM tenant, the {User.*} tokens don’t resolve — the query modification shows the static property name itself instead of the user’s values from EMEA. Question How do I get the query template to resolve {User.customProperty} using the user’s home-geo (EMEA) profile values?
M365 Developer E5 Sandbox provisioning failed despite active Visual Studio Enterprise subscription
Hi everyone, I'm looking for some help with an issue I'm facing while setting up a Microsoft 365 Developer E5 sandbox. I have an active Visual Studio Enterprise subscription (valid until 2029), and it is successfully linked to my Microsoft 365 Developer Program account. What happened I joined the Microsoft 365 Developer Program. I selected Instant Sandbox. I entered the required information and selected my Visual Studio Enterprise subscription. The portal initially displayed the following message: "It's taking longer than expected. Your setup is being processed. There is no action required from you at this time." After waiting for nearly 24 hours, the dashboard changed to: "You don't currently qualify for a Microsoft 365 Developer Program sandbox subscription." What I've verified Visual Studio Enterprise subscription is active and linked to my Developer Program account. A developer tenant appears to have been created. I can access the tenant through the Microsoft Entra Admin Center. An Azure subscription named similar to devProgram_... is visible. In the Microsoft 365 Admin Center (Billing → Your products), only Microsoft Entra ID Free is listed. No Microsoft 365 E5 Developer subscription was provisioned. No sample users or Microsoft 365 workloads (Exchange, Teams, SharePoint, etc.) appear to have been created. My understanding It appears that the developer tenant was created successfully, but the Microsoft 365 Developer E5 sandbox provisioning either failed or never completed. As a result, I don't have a usable Microsoft 365 developer environment for testing Declarative Agents and MCP integrations. Has anyone experienced this before? Is there a way to retry the E5 provisioning without creating a new Developer Program account? Is there anything I can check on my side? Does this require intervention from the Microsoft Developer Program team? Any guidance would be greatly appreciated. Thank you!Changing the License Type and Key of a SharePoint Subscription Farm
Hi everyone, I need some assistance with a licensing issue on a brand new SharePoint Subscription Edition farm. I have 6 servers total 4 Application/Search servers + 2 Web Front End/Distributed Cache servers and current state of farm is Fresh installation no custom code or solutions, no production content web apps configured yet. The Problem: During setup, our systems team accidentally provided a SharePoint Standard Edition product key, which I used during farm creation. We actually require Enterprise Edition, but I am unable to convert the license type through Central Administration. Issue 1: When I go to Central Administration > Upgrade and Migration > Convert farm license type, the Product Key text field and the OK button are both completely grayed out and disabled. Issue 2: When I go to Central Administration > Upgrade and Migration > Enable Enterprise Features and enter our Enterprise key, the process fails with an Unknown Error / SkuUpgradeJob timer job exception ("Post setup configuration failed when attempting post setup configuration task -cmd services -install -cmd installfeatures"). What I Have Tried So Far: Running PSConfig CLI: Ran psconfig.exe -cmd sku -upgrade -key from an elevated Command Prompt. It fails during the installfeatures phase. PowerShell Feature Activation: Attempted to run Enable-SPFeature -Identity PremiumFarm -Force in the SharePoint Management Shell, but feature provisioning fails because the underlying SKU definition hasn't switched. Service Account Privilege Adjustments: Tried restarting the SharePoint Timer Service (SPTimerV4) and changing its logon account to Local System / Local Admin to rule out file permission issues on the 16-Hive directory, but hit SQL permission/authentication blocks. Clearing Timer Jobs and Restarts: Cleared stuck or failed SkuUpgradeJob instances under Timer Job Status, restarted the SharePoint Administration Service and Timer Service across all servers, and performed iisreset. Since this is a completely fresh farm with no customization or data loss risk, what is the cleanest way to force the farm to accept the Enterprise product key without having to completely unjoin and rebuild the 6 servers? Any suggestions or workarounds would be greatly appreciated!SharePoint List Web Parts - New UX
Hey everyone, I am hoping I can get some assistance on the following request. My organization's using SharePoint to manage multiple processes, but am confused with a new UX update that's come in the last few days. Please look at the following example, which is a list with a modern calendar view: For all of my lists, that are used as a web part on a different Site Page, have been given an ability to add a 'New Item', by selecting the title name, which's very frustrating as all of our list processes already have their own system to collect information and it seems as though I cannot turn off this functionality. Any help would be very much appreciated.
Rest API Error:"The parameter Members does not exist in method AddTenantTheme"
Using the following code. $colorPairs = @{ "themePrimary" = "#003538"; "themeLighterAlt" = "#cbe6e7"; "themeLighter" = "#a1cfd1"; "themeLight" = "#7cb8bb"; "themeTertiary" = "#5ba2a5"; "themeSecondary" = "#3f8c90"; "themeDarkAlt" = "#28767a"; "themeDark" = "#166064"; "themeDarker" = "#094b4e"; "neutralLighterAlt" = "#f8f8f8"; "neutralLighter" = "#f4f4f4"; "neutralLight" = "#eaeaea"; "neutralQuaternaryAlt" = "#dadada"; "neutralQuaternary" = "#d0d0d0"; "neutralTertiaryAlt" = "#c8c8c8"; "neutralTertiary" = "#98a9da"; "neutralSecondary" = "#4863b4"; "neutralPrimaryAlt" = "#113191"; "neutralPrimary" = "#002081"; "neutralDark" = "#001963"; "black" = "#001249"; "white" = "#ffffff"; } $content = @{ "name" = "MyCustomTheme" "themeJson" = $jsonBody } | ConvertTo-Json $apiUrl = "https://<<domain>>-admin.sharepoint.com/_api/thememanager/AddTenantTheme" Invoke-PnPSPRestMethod -Url $apiUrl -Method "Post" -Content $content Tried many different combinations but kept getting Invoke-PnPSPRestMethod: {"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The parameter Members does not exist in method AddTenantTheme."}}} Wondering if somebody can run this code successfully and let me know what I am missing.
I have trouble with phone number and Microsoft Authentication when login. Where can I find support?
Hello, Currently, I am unable to log in to my email address removed for privacy reasons account. I have the password. I have a backup email address, but when I try to log in, at the authentication step, I don't have the option to receive the OTP code via email. I can only choose to have it sent to my phone number or the Microsoft Authentication app. But when I tried sending it to the phone number, I got the following error: Error Code: 399287 Request Id: 4d13566b-7aa4-4b3f-a03b-0c9416841000 Correlation Id: 019f785d-514f-7eaa-b1a3-ee66302634ae Timestamp: 2026-07-19T03:13:40Z Also, I can't access the Microsoft Authentication app because I've changed devices multiple times. I couldn't find the support form, so I replied to this email. With the admin account password and backup email, how can I log into the admin panel? Sincerely, ThangStoring and organizing performance review data - SharePoint lists or something else?
My team has been asked to move our performance review records from a legacy HR system into something within M365. Someone suggested SharePoint lists but I'm worried about permissions (employees shouldnt see each others reviews), workflow complexity, and whether it'll scale. We have about 400 employees. Is SharePoint the right tool for this or should I be looking at something purpose-built that integrates with our M365 environment?SharePoint SE - Distributed cache service is not enabled in this deployment.
Hi everyone, I have been struggling for a few weeks now with a Distributed Cache issue in my SharePoint farm. The service configuration seems completely out of sync between my two Web Front Ends (WFEs). 1 Root Cause / History: Originally, the Distributed Cache was working perfectly. However, after a Windows Update, both of our original WFE servers broke completely (we couldn't repair them using DISM). Because of this, we built two brand new WFE servers to replace them. Crucially, because the old servers were broken, we performed the steps in this order: 1. We built and added the two new WFE servers to the farm first. 2. After adding the new ones, we removed the two broken ones using the Configuration Wizard, and subsequently deleted them from Central Administration since they were still showing up. Because the old servers were never gracefully decoupled from the Distributed Cache before they died and were removed, the internal Distributed Cache configuration in the SharePoint configuration database is now corrupted. 2 Environment & Farm Topology: • SharePoint Version: SharePoint Subscription Edition (SE) • OS: Windows Server 2025 • Database: SQL Server 2025 • Topology: 2 Web Application servers (App servers) and 2 brand new Web Front End servers (Server 1 and Server 2). • Note: All required Distributed Cache firewall ports (22233, 22234, 22235, 22236) are completely open on both servers. 3 The Current Symptoms on the New WFEs: • Server 1: The Windows Configuration Wizard runs and completes successfully. However, in Central Administration, the Distributed Cache service status for this server is stuck on "Error Stopping". • Server 2: Distributed Cache does not work at all. Running Get-SPCacheHost prompts for a HostName, indicating it cannot find the host in the cache configuration. • Cache Health Error: Running Get-SPCacheClusterHealth fails completely with: ErrorCode<ERRCAdmin040>:SubStatus<ES0001>:Failed to connect to hosts in the cluster • Health Analyzer Errors: 1. "Distributed cache service is not enabled in this deployment." 2. "Server role configuration isn't correct." (Specifically flagging Server 2). 4 What I Have Tried So Far: 1. Cleaned up old servers from Config: I exported the cache cluster config (Export-SPCacheClusterConfig), manually removed the two old, decommissioned servers from the XML file, and imported it back. 2. Repair via Central Admin: Tried to use the built-in repair and fix options in CA, but without success. 3. Attempted Fix from Microsoft Learn: I followed the steps outlined in this Microsoft Learn thread regarding a renamed server issue: [https://learn.microsoft.com/en-ie/answers/questions/5907941/distributed-cache-not-working-on-a-renamed-sharepo] 4. Forced Deletion on Server 2: Because Remove-SPDistributedCacheServiceInstance failed with a cacheHostInfo is null error, I used PowerShell to force-delete the service instance object on Server 2: PowerShell $instanceName = "SPDistributedCacheService Name=SPCache" $serviceInstance = Get-SPServiceInstance | ? { ($_.Service.ToString()) -eq $instanceName -and ($_.Server.Name) -eq "Server02" } $serviceInstance.Delete() 5. Re-adding Server 2: When I now try to re-add the instance on Server 2 using Add-SPDistributedCacheServiceInstance, it fails with: ErrorCode<HostAlreadyPresent>:SubStatus<ES0001>:Host name Server02 is already present in cluster configuration. 6. Configuration Wizard on Server 2: Running the SharePoint Configuration Wizard (PSConfig) on Server 2 fails with: An exception of type System.InvalidOperationException was thrown. Additional exception information: cacheHostInfo is null. 7. Farm Rejoin: I completely removed Server 2 from the SharePoint farm and added it back again. Unfortunately, this did not resolve the Distributed Cache mismatch. 5 Summary of the Problem: Server 1 is stuck on "Error Stopping" in CA. Server 2 is completely disconnected from the cache cluster (Failed to connect to hosts in the cluster). SharePoint throws HostAlreadyPresent when trying to add Server 2, but throws cacheHostInfo is null when trying to configure or remove it, while complaining that Server 2's role configuration is incorrect. Any help would be greatly appreciated!Can you preserve links when exporting from a list to Excel?
Hi! I have a list with a multiline text field set to support enchanced richtext used to store URLs of files. I am inserting data into this list when people submit a Jotform using Power Automate to connect the two. In Power Automate, I build the field value by looping the uploaded files and building out HTML: <a href="https://www.server.com/path/file.png">file.png</a><br> <a href="https://www.server.com/path/file.pdf">file.pdf</a><br> Problem is, if I go to the list and do Export to Excel, the query.iqy file I get just shows file.png and file.pdf as basic, nonlinked text in the column. Is there any way to get Sharepoint to create an Excel file where the links are preserved?
"labels" in the left navigation pane
Hi, Can anyone advise me if it is possible to add labels in bulk to libraries? What I am asking badly is....I have over a hundred libraries on a site and they need labels adding to them so they are "grouped" in categories. Some of the labels need applying to several libraries. I have been doing smaller sites manually but the bigger ones will be very tedious and time consuming. I hope that makes sense?
Format Power BI report in SharePoint page
Hey everyone, I have a wide and short Power BI report that is 2500 by 350 and I am trying to embed it in a SharePoint page. The problem is that when I embed it there is a ton of negative space below the report. I tried formatting the web part but there are only two display ratios (16:9 and 4:3). Is there a way to shorten the web part or reduce the negative space below the report.SharePoint Online Site Deletion blocked by Retention Policy although no content is retained
Hi everyone, I'm trying to understand whether this behavior is expected or if other organizations are experiencing the same issue. Environment SharePoint Online (Microsoft 365) Microsoft Purview Retention Policy Retention duration: 180 days Trigger: based on last modified date After retention period: Do nothing The intention of the policy is not to automatically delete content. We only want to prevent deletion for 180 days and allow deletion afterwards. Microsoft previously explained to us that retention applies to the content/items, not to the container (the SharePoint site itself). Problem We are currently unable to delete SharePoint sites. When attempting to delete a site from the SharePoint Admin Center we receive the following message: This site can't be deleted at this time because it is blocked by a compliance policy. What we already checked For the affected site: CompliancePolicyIds = empty ArchiveStatus = NotArchived SensitivityLabel = empty The Preservation Hold Library is empty: Preservation Hold Library => Items = 0 We also inspected the internal DLC properties of the site and found entries such as: dlc_sitehaspolicy dlc_sitehasexpirationpolicy dlc_webhasexpirationpolicy Even after clearing these values for testing purposes, the site still could not be deleted. Important Observation If we explicitly exclude the site from the retention policy, deletion becomes possible. This makes it appear that the retention policy is blocking deletion of the site container itself, even though our understanding was that retention should only protect retained content and not permanently prevent deletion of the entire SharePoint site. Has anyone else observed this behavior? Additional OneDrive Issue We are seeing a similar problem with unlicensed OneDrive accounts. Many of these OneDrive sites: are already archived are shown as blocked by retention/compliance cannot be deleted remain present for years For example: ArchiveStatus = FullyArchived CompliancePolicyIds = empty The accounts appear in the list of unlicensed OneDrive accounts, but we are unable to permanently remove them while the retention policy is in effect. Has anyone found a practical way to clean up or remove these orphaned/unlicensed OneDrive sites when a tenant-wide retention policy is configured? Questions Has anyone seen a situation where: CompliancePolicyIds is empty the Preservation Hold Library is empty but site deletion is still blocked by a compliance policy? Does a retention policy configured as: Retain for 180 days Then Do nothing intentionally block deletion of the entire SharePoint site container? Is it expected that excluding a site from the retention policy immediately makes deletion possible? How are other organizations handling site lifecycle management when tenant-wide retention policies are enabled? Has anyone experienced similar issues with unlicensed OneDrive accounts that cannot be deleted because of retention/compliance requirements? Any experiences, recommendations, or explanations would be greatly appreciated. Thanks!
Recycle Bin and Site Content Hidden for Site Members and Site Visitors
I posted this before but made a mistake with my write up, so I am reposting. I have a requirement that the Recycle bin and Site Contents should be be hidden from the Site Members and Site Visitors. Please how can I achieve this because the Server Infrastructure activation is not working for me. Any workarounds? Please helpIssues with SharePoint Product Catalog (Classic)
Is it a known issue for search-based web parts (content search web part or search box, refiners and results) to be interfering with a page layout integrated with catalog item reuse snippets in SharePoint Online (classic)? Due to the limitation in creating a product catalog site in modern experience, we went down the path of creating a classic version of product catalog in SharePoint Online. For a year and a half, the product catalog has been working fine until recently while there were no new changes made to the page or the page layout. The page used to surface catalog item content based on the product tag in the URL (https://[tenantname].sharepoint.com/sites/products/overview.aspx?myproduct=apple) as well as search-based content. Upon investigating the issues, it appears that the catalog item reuse snippets on the page layout and the search-based web parts both are interfering with each other's. If we removed search-based web parts from the page, the catalog item content then surfaces. If the search-based web parts are re-added, the catalog item content then disappears. Has anyone experienced this issue?
Recent Blogs
- In this edition of SharePoint Showcase, we explore how skills work, how to create or install them, and ten practical examples to help SharePoint site owners get started. These examples are not an exh...Jul 28, 2026
- By Sujay Kumar Jauhar, Spriha Chandrayan, Natasha Gaitonde, Zhen Lei, Reed Pankhurst, Anush Sankaran, Amrit Shandilya, Ryen W. White Organizations put their most important content in OneDrive and S...Jul 21, 2026
