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
