Spotlight Error Provider cannot be found. It may not be properly installed. (4240287)

When installing Spotlight the following error appears:

Spotlight on SQL Server could not establish a connection to "SQL_Server_Name". Check your connection details and try again. Provider cannot be found. It may not be properly installed.

Indicates that there is likely an OLEDB configuration problem or a bad installation of OLEDB. SQL LiteSpeed uses OLEDB to make connections to the database.

Register OLEDB:

1. At a command prompt, change to the "C:\Program Files\Common Files\System\Ole DB" folder.

2. At a command prompt, type the following command: regsvr32 sqloledb.dll

3. A confirmation should be received stating that the DLL is registered successfully