Install SSL Certificate on Azure Web App

To secure your site, extract the files from STAR.mydomain.com_cert.zip and STAR.mydomain.com_key.zip on your computer and upload them to your server. Here is a list of the most common server types and how to install SSL on them. If you created a CSR and private key in-browser during SSL activation, you will find key.zip in your downloads folder. How to install an... » read more

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

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