Could you check following?
1. Install Tableau desktop on the server where you have Tableau server. Connect to the same data source. If it is unable to connect, then you have issues with the networks or firewall.
2. Ensure how you published the viz to server. Try with embedded password. If it is successful, then possibly problem is that you do not have rights to the database.
i am able to open remaning workbooks in the server
i have published through embeded password with published separtely.
but when i try to edit the datasource its giving unable to connect data server.
I guess you have issues with networks.
Try to install Tableau desktop on server and try to recreate the viz there.