Please confirm what error you are getting while testing the connection ?
What is the scope you have selected while creating the data source ?
If you have created on Cell Level, then restart the DMGR and if you have created on node level, then restart the NodeAgent.