Timeline for Unable to create a datasource. Datasource fails to 'test successfully' for SSRS
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 31, 2014 at 2:28 | comment | added | Sir Swears-a-lot | Wow. Good find :) glad you have resolved it. | |
| Oct 31, 2014 at 1:56 | answer | added | Normoe | timeline score: 2 | |
| Oct 31, 2014 at 1:49 | comment | added | Normoe | Peter thanks for hanging in there and helping. I made a discovery it was a windows AD issue specific with that service account. I think i should post the answer below | |
| Oct 30, 2014 at 6:49 | comment | added | Sir Swears-a-lot | Can you confirm you're connecting from 2008 SSRS instance to remote db. And also from 2012 SSRS instance to same remote db? You're talking about 3 servers. | |
| Oct 30, 2014 at 6:44 | comment | added | Sir Swears-a-lot | Can you change the password for user data source just to rule it out? Does the password use unusual characters? | |
| Oct 29, 2014 at 23:57 | comment | added | Normoe | Hi @peter. Thanks for Suggestion, I tried manually created another datasource but still get error msg: 'Log on failed. Ensure the user name and password are correct.' when attempting to 'test connection' On older SSRS 2008 server I can create a new datasource using same login/pw but 'Succeeds' so I can confirm login/pw ok. Also on new server I can use my own domain login/pw 'Succeeds' this validates no firewall issues. | |
| Oct 28, 2014 at 8:52 | comment | added | Sir Swears-a-lot | Does your ssrs server have ssms? And can you log into it with remote desktop? If so you could connect to your source db from the server using ssms and your data source credentials to rule out firewall issues. | |
| Oct 28, 2014 at 8:48 | comment | added | Sir Swears-a-lot | You should be able to manually create another data source on your 2012 instance. Just give it a different name. My hunch is that your script doesn't have the credentials correct. | |
| Oct 27, 2014 at 23:45 | history | asked | Normoe | CC BY-SA 3.0 |