Author

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