Thanks for your response !!!Yes I have followed the same steps mentioned in that link.If I try connecting login.salesforce.com as host url , I can connect to SFDC whereas I need to connect with test.salesforce.com(sandbox).Kindly take a note on this.Dhinu

I have tried to connect SalesForce(test.salesforce.com) from AEM Cloud service but it is not able to establish the connection.Please find the attached Screenshot of error displayed.Kindly help on this.