Tag: Microsoft MSSQL

Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

Published on Author JFLeave a comment

When using Microsoft SQL Server Import and Export Wizard you might get this error when attempting to import an XLSX file: TITLE: SQL Server Import and Export WizardThe operation could not be completed.ADDITIONAL INFORMATION:The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)BUTTONS:OK This is because the default wizard is launches the 32 bit… Continue reading Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine →

How to search the Microsoft SQL Full Text Search index

Published on Author JFLeave a comment

Use this query in SQL Management Studio to directly search the Full Text Search index. select * from sys.dm_fts_parser(‘”search term”‘, 1033, NULL, 0) Note that there are upcoming changes to FTI, including many deprecated functions, so if you’re using it extensively you probably have some work to do.

TLS 1.2 Support for MSSQL

Published on Author JFLeave a comment

Like many people, you’re still running Windows 2008 R2. You removed SSL and TLS 1.0 and other various security related connection configurations and protocols and you want to now install Microsoft SQL Server 2008 R2! Note: if you have not disabled these open wounds of Internet communication you should do so now! Note: there are… Continue reading TLS 1.2 Support for MSSQL →