An installation package for the product Microsoft OLE DB Driver for SQL server cannot be found: msoledbsql.msi
Error: Error Description: An installation package for the product Microsoft OLE DB Driver for SQL server cannot be found, Try installing again using a valid copy of the installation package ‘msoledbsql.msi’ Fix: Uninstall all OLE and ODBC drivers and re run the setup. References: https://stackoverflow.com/questions/71857345/error-when-installing-microsoft-sql-server-2019-cannot-find-the-microsoft-ole-d
How to Think Like the SQL Server Engine – Brent Ozar Unlimited® You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In my totally free How to Think Like the Engine class, you’ll... » read more
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
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
Access has been blocked by CORS policy: Request header not allowed by Access-Control-Allow-Headers in preflight response.
Error: Using Blazor WebAssembly app to access .NET 7 WebAPi app. Getting the following error… Fix: Add the following to the WebAPI app… References: https://stackoverflow.com/questions/65858468/access-to-fetch-has-been-blocked-by-cors-policy-blazor-client-web-assembly