Error: "Failed to login to SQL Server" error during install or connecting to Instance in LiteSpeed (4352652)

Installed LiteSpeed 4.8.4 without any problems on Active node. No errors highlighted in the Installer Log. However, When starting LiteSpeed Enterprise Console, choosing any instance gives Failed To Login to SQL Server error. All of the following Cluster install instructions have been checked bit still getting the same error.

1. When remote desktop to a cluster, login to the physical node of the active node in the cluster to install LiteSpeed.

2. The remote registration service need to be started with LOCAL SERVICE account.

3. Ensure the login user has the local administrator right on both nodes

4. Ensure there is no terminal service installed on the nodes. The terminal service can make it to run like a Citrix server which prevents msi installer package to have the full admin permission to see the passive node.

LiteSpeed needs OLE DB driver to connect to SQL Server. In this case, sqloledb.dll is not registered correctly onmachine.

To install or upgrade the SQL Server OLE DB drivers, user must install what Microsoft calls MDAC (Microsoft Data Access Components). The latest MDAC can be downloaded from Microsoft: here

https://msdn.microsoft.com/en-us/library/ms810811.aspx

Verify that the sqloledb.dllis registered.
It usually located at: C:\Program Files\Common Files\System\Ole DB

Steps toregister a dll:
Go to the Run item on the Start menu, and type:
regsvr32

1. For additional info on (re)registering files, see;http://consumer.installshield.com/kb.asp?id=Q108199

2. To make sure problem is related to OLE DB driver, try the following connections test or refer to Page: 4 of LiteSpeed Troubleshooting Guide.

Connection Test:
--------------------------

If LiteSpeed is causing issues connecting to SQL Server, perform the following test. This test uses :Microsoft Data Link file to connect to the Database.

1. Create a new file called Connection_Test.udl. A UDL file is a Microsoft Data Link file

2. Double Click the newly created file. This will bring up a screen entitled Data Link Properties.

3. In the provider Tab check to see if OLE DB Provider for SQL Server is listed, if so choose Microsoft OLE DB Provider for SQL Server 4 Copyright 2007 Quest Software, Inc. All Rights Reserved

4. Click next which will take you to the Connection tab

5. Choose the server name that you want to connect. If you cannot find the name of the server you want to connect to, press the refresh button and check again, or simply type in the Server name

6. Choose the method of logon to the server. Either Windows or SQL Server Authentication. It is advisable to try both and test the connection to make sure that its not a permissions issue.

7. Once the logon details have been entered, choose the database you want to connect to.

8. Test Connection. If the connection is successful it should give you a message of Test Connection Succeeded.

9. If the connection fails it will usually give you a description informing why the connection was not successful.