Brent Ozar Training

Homepage | Brent Ozar Unlimited Brent Ozar Unlimited Level 2 Bundle | Brent Ozar Unlimited The BrentOzar.com Annual Black Friday Sale – Brent Ozar Unlimited® You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the blog regularly, subscribed to the free newsletter, watched some of my YouTube videos, maybe... » read more

Changing Database Column Order

Issue: Changing the order of database table columns. Resolution: Have to re-create the table in order to change the order of the database column. Right click on table -> Designers -> Re-arrange table column -> Save Note: Make sure the “Prevent saving changes that require table re-creation” is unchecked. Change this my going to SQL... » read more

The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Authentication Required.

Error: Resolution: Go to you email account settings at https://myaccount.google.com/ Security settings required by G Suite. A strong password. I create a new strong password. Confirmed. 2-factor auth is off. Confirmed. Access to less secure apps is enabled. Here is screenshot of my settings, the first is the admin console enabling it for users, the... » read more

Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access.

Error: System.Transactions.TransactionManagerCommunicationException: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool. ---> System.Runtime.InteropServices.COMException: The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024) Fix: Configure MSDTC Open Component Services.Or, In Server Manager, select Tools, and... » read more

no runtime pack for Microsoft.AspNetCore.App available for the specified RuntimeIdentifier browser-wasm

Error: There was no runtime pack for Microsoft.AspNetCore.App available for the specified RuntimeIdentifier ‘browser-wasm’. xxxxxxxxxxxx C:\Program Files\dotnet\sdk\7.0.402\Sdks\Microsoft.NET.Sdk\targets\Microsoft.NET.Sdk.FrameworkReferenceResolution.targets Fix: Was able to resolve the issue by removing the project dependency (which I didn’t need in the first place, but accidentally got placed there). In my case, the error wasn’t the result of the Blazor project itself, but a referenced... » read more

Error Using Microsoft Identity Platform Entra (Azure Active Directory) for App Sign In

Error: You get the following error when setting up your web application to use the Entra (Azure Active Directory) for authentication… AADSTS50011: The redirect URI ‘https://xxxxxx/authentication/login-callback’ specified in the request does not match the redirect URIs configured for the application ‘xxxxxxx’. Make sure the redirect URI sent in the request matches one added to your... » read more

Azure Active Directory Entra Group Membership Claims attribute

https://learn.microsoft.com/en-us/aspnet/core/blazor/security/webassembly/microsoft-entra-id-groups-and-roles?view=aspnetcore-7.0 https://learn.microsoft.com/en-us/aspnet/core/blazor/security/webassembly/graph-api?pivots=graph-sdk-5&view=aspnetcore-7.0 https://learn.microsoft.com/en-us/graph/sdks/sdks-overview Scopes To permit Microsoft Graph API calls for user profile, role assignment, and group membership data: A CLIENT app is configured with the User.Read scope (https://graph.microsoft.com/User.Read) in the Azure portal. A SERVER app is configured with the GroupMember.Read.All scope (https://graph.microsoft.com/GroupMember.Read.All) in the Azure portal. The preceding scopes are required in addition to the scopes required in ME-ID deployment scenarios described by the... » read more