I tried to run OSQL.exe to check execute the below
osql -S database\instance -U username -P password - but it failed
I uninstalled DCS and deleted the users created in SQL server then reinstalled DCS - Login was not successfuly
Then we found that...in SQL we dont't see the USER NAME row under the tables..
so i created new instance in SQL for SDCSS
Uninstalled DCS server and console
Reinstalled DCS and pointed to the new instance SDCSS then it worked fine...
Thanks for all your inputs and ideas..