Tuesday, July 01, 2008

SSRS Cannot create a connection to data source 'dataSource1' Report builder



Symptoms:


In report builder getting Error message when trying to run a report :



Login for user XXX failed Cannot create a connection to data source 'dataSource1'





















Solution:

This error is caused by the executing user account (in the SSRS) not having permissions to run the report.

The datasource1 is an internal datasource so don't bother looking for it.

To sort out the problem:

1. Open Report Manager (http:\\localhost\reports)
2. Navigate to Home > Data Sources
3. Make sure Connection string is using Integrated Security=True
4. Select Credentials stored securely in the report server
5. Fill in the Username and password with an admin account on the machine that hosts SSRS
6. Tick Use as Windows credentials when connecting to the data source (to keep your user accounts setup like user folder premisions) working OR just Select credentials are not required

Make sure you unselect Windows integrated security if you are using a windows account that is not an administrator to connect to SSRS server


























































7. Click apply








9 comments:

cristiano said...

Thanks a lot for your useful step-by-step !!!

drikusr said...

The mentioned solution is not the greatest one. Access to the data source is a SQL Server function and the user needs access to it via the database server. Putting the user in question into the group [SQLServer2005ReportServerUser$(Server Name)$SQLEXPRESS] provides access to Reports and then STEP 2: Add the user to the group [SQLServer2005MSSQLUser$(Server Name)$SQLEXPRESS] should solve the problem.

This does not compromise your active directory authentication and you don't have to store local credentials and start impersonating etc.

jagan said...

super solution... it really worked

Anonymous said...

topic49, [url=http://www.chop.edu/forum/user/profile/8207.page]klonopin no prescription[/url], :-) lkd, http://www.chop.edu/forum/user/profile/8207.page klonopin without prescription :-(, [url=http://www.chop.edu/forum/user/profile/8208.page]purchase xanax 2mg[/url], :-( obu, http://www.chop.edu/forum/user/profile/8208.page order xanax 2mg :-(, [url=http://forum.cprs.ca/default.aspx?g=posts&m=6]order adipex online[/url], ;-( foi, http://forum.cprs.ca/default.aspx?g=posts&m=6 order adipex :-(, [url=http://forum.cprs.ca/default.aspx?g=posts&m=7]buy alprazolam without prescription[/url], :-) vuc, http://forum.cprs.ca/default.aspx?g=posts&m=7 alprazolam without prescription *sorry*, [url=http://forum.cprs.ca/default.aspx?g=posts&m=8]order ambien no prescription[/url], :-( uga, http://forum.cprs.ca/default.aspx?g=posts&m=8 order ambien no prescription *sorry*

Anonymous said...

hi! [url=http://esnips.com/web/minnaregina/]Hello. And Bye.
[/url] http://esnips.com/web/minnaregina/ free nude video clips of milfs
thanks!
free nude video clips of milfs

Anonymous said...

Hello!
Amuse look our cheapest prices forAmbien. Most tender guarantied. Self-indulgent Articulation
[url=http://www.testriffic.com/user/MygdsAnge/]edorel.com link web xanax xr[/url]
[url=http://www.testriffic.com/user/KbmxiZucn/]xanax echeck[/url]
[url=http://www.testriffic.com/user/VyrklEzkn/]long term xanax[/url]
[url=http://www.testriffic.com/user/BkrgjYqpj/]dose xanax[/url]
[url=http://www.testriffic.com/user/KszihLcyc/]buspar similarty to xanax[/url]
[url=http://www.testriffic.com/user/AhtonVztu/]3mg xanax pictures[/url]
[url=http://www.testriffic.com/user/KspnhVfvt/]alprazolam blog xanax[/url]
[url=http://www.testriffic.com/user/CeyhuYjkp/]buy com.sg site xanax xanax.html zyworld.com[/url]
[url=http://www.testriffic.com/user/UwfwzMprd/]xanax maoi effexor xr[/url]
[url=http://www.testriffic.com/user/HjlksDftc/]xanax duration and test for it[/url]
[url=http://www.testriffic.com/user/BfbixOxhp/]buy xanax online without prescription[/url]
[url=http://www.testriffic.com/user/MeadqOwto/]hydrocodone xanax[/url]
[url=http://www.testriffic.com/user/BhjhdKnvb/]zoloft vs xanax[/url]
[url=http://www.testriffic.com/user/RgdroFimf/]seroquel xanax[/url]
[url=http://www.testriffic.com/user/XjpemTjci/]order Xanax without rx[/url]
[url=http://www.testriffic.com/user/JzcxbVahh/]drug symptom withdrawal xanax[/url]
[url=http://www.testriffic.com/user/UvmijQgom/]how to withdraw from xanax[/url]
[url=http://www.testriffic.com/user/YwaaiQskb/]20six.co.uk link org purchase site xanax[/url]
[url=http://www.testriffic.com/user/GembzCewv/]buy Xanax drugstore[/url]
[url=http://www.testriffic.com/user/ZipedXkxc/]Xanax buy generic[/url]
[url=http://www.testriffic.com/user/AkalvVbpx/]alprazolam dosage indication stability storage xanax[/url]
[url=http://www.testriffic.com/user/ZclsrHhsq/]Xanax delivery c.o.d. purchase[/url]
[url=http://www.testriffic.com/user/MnxdkHsuc/]ambien buy link online spaces.msn.com xanax[/url]
[url=http://www.testriffic.com/user/FmxccHnbx/]buy eteamz.active.com link xanax xr[/url]
[url=http://www.testriffic.com/user/ClbtzMfvt/]umaxppc valium vs xanax[/url]
[url=http://www.testriffic.com/user/EyfsnEdby/]book buy com esteban guest online site xanax[/url]
[url=http://www.testriffic.com/user/CkcibDkzb/]soma and xanax mix[/url]
[url=http://www.testriffic.com/user/BespfUtkg/]book dk guest site xanax[/url]
[url=http://www.testriffic.com/user/HzdkbAjjb/]find it link now.dynu.net order xanax[/url]
[url=http://www.testriffic.com/user/YmrloEhzg/]dosage get low off very xanax[/url]
[url=http://www.testriffic.com/user/ZhxdqHvxu/]dosage indication stabil storage xanax[/url]
[url=http://www.testriffic.com/user/ZzzmzSnlg/]xanax without a prescription[/url]
[url=http://www.testriffic.com/user/LplbaRqrg/]guestbook.html inurl site submit web xanax[/url]
[url=http://www.testriffic.com/user/OnxenGuyq/]cheap drug xanax[/url]
[url=http://www.testriffic.com/user/YcajnNhcq/]xanax 2mg bars[/url]
[url=http://www.testriffic.com/user/ZawmbHifp/]link online planet.nana.co.il xanax[/url]
[url=http://www.testriffic.com/user/AlfmiYmbd/]generic xanax description[/url]
[url=http://www.testriffic.com/user/LjpqqBezy/]round blue xanax[/url]
[url=http://www.testriffic.com/user/TxufjSauf/]buy Xanax in Hawaii[/url]
[url=http://www.testriffic.com/user/UztbrSuah/]signs of xanax use[/url]

Anonymous said...

Hi!
Amuse look our cheapest prices for SOMA. Most sell guarantied. Connected Distribution
[url=http://vmtoolkit.com/members/Zoloft+and+xanax.aspx]soma sex talk[/url]
[url=http://vmtoolkit.com/members/Paxil+and+xanax+interaction.aspx]dene soma[/url]
[url=http://vmtoolkit.com/members/Soma+fab+smoothie+bicycle+review.aspx]soma temple bingin bali[/url]
[url=http://vmtoolkit.com/members/Soma+shipped+cod.aspx]soma ld50[/url]
[url=http://vmtoolkit.com/members/The+rose+at+soma.aspx]soma taken with tramdol experiences[/url]
[url=http://vmtoolkit.com/members/Aura+soma+usa.aspx]soma dictionary meaning[/url]
[url=http://vmtoolkit.com/members/Soma+bringer+translation.aspx]soma for cramps[/url]
[url=http://vmtoolkit.com/members/Pronstar+soma.aspx]buy discount soma[/url]
[url=http://vmtoolkit.com/members/Orca+dive+club+soma+bay.aspx]soma puzzles solutions[/url]
[url=http://vmtoolkit.com/members/Why+does+soma+give+me+energy.aspx]soma medication[/url]
[url=http://vmtoolkit.com/members/Soma+marijuana+and+jagermeister.aspx]soma cash on delievery[/url]
[url=http://vmtoolkit.com/members/Soma+addiction.aspx]temp soma slippers[/url]
[url=http://vmtoolkit.com/members/Timbuk2+soma.aspx]soma venue[/url]
[url=http://vmtoolkit.com/members/History+of+soma+drug.aspx]soma day spa[/url]
[url=http://vmtoolkit.com/members/Buy+fast+online+private+soma.aspx]soma bringer main theme[/url]
[url=http://vmtoolkit.com/members/Soma+tablets.aspx]chemical composition of neuronal soma[/url]
[url=http://vmtoolkit.com/members/Soma+bringer+follow.aspx]soma for cheap no prescription[/url]
[url=http://vmtoolkit.com/members/Death+from+soma+overdose.aspx]buying soma online[/url]
[url=http://vmtoolkit.com/members/Q+buy+soma+online.aspx]sargento soma mp3[/url]
[url=http://vmtoolkit.com/members/Soma+fit+massage.aspx]soma metabolites[/url]
[url=http://vmtoolkit.com/members/Soma+versus+flexeril.aspx]hydrocodone soma buy online no prescription[/url]
[url=http://vmtoolkit.com/members/Soma+crystal+bottle.aspx]soma trojan horse[/url]
[url=http://vmtoolkit.com/members/Soma+stop.aspx]soma salon bellevue[/url]
[url=http://vmtoolkit.com/members/Drugtests+soma.aspx]soma prescription cod[/url]
[url=http://vmtoolkit.com/members/Soma+salon+sudbury+ma.aspx]soma for pain[/url]
[url=http://vmtoolkit.com/members/Anti+soma.aspx]drugtests soma[/url]
[url=http://vmtoolkit.com/members/Soma+drug+tests.aspx]side effects of soma tabs[/url]
[url=http://vmtoolkit.com/members/Soma+carisoprodol+site.aspx]soma muscular pain[/url]
[url=http://vmtoolkit.com/members/Soma+stores.aspx]buy soma without a prescription[/url]
[url=http://vmtoolkit.com/members/Information+on+soma+the+moon+god.aspx]soma 250 mg sales reps[/url]
[url=http://vmtoolkit.com/members/Soma+mail+medication.aspx]soma vs fioricet[/url]
[url=http://vmtoolkit.com/members/Soma+fury.aspx]cod soma pharmacy[/url]
[url=http://vmtoolkit.com/members/L-o+soma+hotel+inc+sanfrancisco+ca.aspx]soma aryan[/url]
[url=http://vmtoolkit.com/members/Soma+intimites.aspx]skelaxin vs soma[/url]
[url=http://vmtoolkit.com/members/Soma+puzzle+on+a+string.aspx]samurai fm soma records presents[/url]
[url=http://vmtoolkit.com/members/Soma+food+pantry+los+angeles.aspx]soma anti snore pillow[/url]

Reina Sofia said...

I have tried xanax and valium. I highly recommend its use. You can buy it online WWW.MEDSHEAVEN.COM even without prescription.

Reina Sofia said...

I highly entrust the use of xanax and valium which you can buy on WWW.MEDSHEAVEN.COM even without prescription.