red_75116
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?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers 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.
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?