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

0
Read
echiang
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

0
Read
echiang
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

0
Read
echiang
SQL Server Upgrade from 2014 to 2022

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16 https://sqlserverbuilds.blogspot.com/2014/01/sql-server-2014-versions.html Upgrades from earlier versions to SQL Server 2022 SQL Server 2022 (16.x) supports upgrade from the following versions of SQL Server: SQL Server 2012 (11.x) SP4 or later SQL Server 2014 (12.x) SP3 or later SQL Server 2016 (13.x) SP3 or later SQL Server 2017 (14.x) SQL Server 2019 (15.x) Note: Need to... » read more

0
Read
echiang
login failed for user ‘server name\sql server instance$’. reason: could not find a login matching the name provided. [client: ]

Error: Login failed for user ‘DomainName\ServerName$’. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>] Possible Causes: User application that is accessing this database is running under the default Windows service account. Check the user application in Services and make sure it is running under a specific service account and not... » read more

0
Read
echiang