Link to home
Start Free TrialLog in
Avatar of red_75116
red_75116Flag for United States of America

asked on

Reporting Service Datasource issue

I am having trouble with an installation of reporting server where I have chosen to have the credentials stored securely in the report.  The user I have entered is a domain admin account, but when I test the connection it takes about 30 secs to return the Green connection created successfully.  This is causing all reports to run incredible slow.  When I change  to windows integrated or run the report via SSDT then all reports run in about 1 sec.  Sql has about 75 gb of ram on a server with 100 gb of total memory.  What could be causing this issue?  Is this account messed up?  Should I try another domain account? Any way to test?
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

are SSRS and Sql DB on the same box?
What is your sql -ssrs edition service pack ( need the latest sp)?

"This is causing all reports to run incredible slow"
did you try to run SSRS report query directly on sql server ?
are there any blocking? Sql winodws SSRS errors?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.