Hi @Ratan D , welcome to Microsoft Q&A forum.
This error is mostly related to incorrect login information. While creating the connection through connecting manager, please type the appropriate database name with which you want to connect, as well as check the user name and password once again. Then click on 'Test Connection' to see if it gets succeeded.
if this does not work out, please let us know and we can look further into it.