Not able to execute any report due unable to connect to datasources

[tushar gaurav]

Not able to execute any report due unable to connect to datasources.
e.g when I execute a report a small window get popped up asking about credentials to connect to datasource used in the report, but even when the credentials given the window is not accepting it.
Due to this issue I am not able to execute the report.

[bdbits]

(Please do not send a personal message only hours after you post a question to which I have not even responded. This is not a help desk, and I was still getting my desperately needed beauty rest when you posted.)

Basic things to check are whether the drivers for your datasource are installed on the server, whether your credentials work from a native query tool, what you can see in the database with those credentials, etc.

Since you are posting in admin group, I assume you have administrator access and that you already know which datasource the package is trying to use. Test the connection from the Configuration Tab in Data Source Connections. Click on the datasource, then get properties on a connection. Click the Connection tab then "Test the connection..." link. You have to get this working before anything else.

When all this has been validated and is working, then try the report.

[MFGF]

Please do not send a personal message only hours after you post a question to which I have not even responded. This is not a help desk, and I was still getting my desperately needed beauty rest when you posted

Folks, please don't abuse the kindness of our forum members by re-sending them your posted questions in a PM like this. Anyone who responds to a post does so because they feel they have something helpful to offer, and they are under no obligation to reply at all. Sending someone a problem in a PM puts them in a position where they might feel pressured to respond, and it's really not fair to put them in this position. Please just be patient when looking for answers. There are many helpful people on the forum from all around the globe, and someone with an answer might not be awake when you post your question. Similarly, they might not be online for days because of pressures of their day-to-day job. There are many smart, kind people like bdbits on here who post regularly to try to help others - please do not take advantage of their generosity.

MF.