Refresh takes longer for normal user than admin

• Emil B

  SSCertifiable

  Points: 5568

  More actions

  September 21, 2015 at 5:10 am

  #151436

  Hi,

  I have a report in excel that connects to analysis services in order to refresh. The bizarre thing is that it takes about 10-15 minutes to refresh the report for a standard user and about 1 minute for administrator (account for local machine). Can't see anything obvious in the connection string and I'm a bit lost ATM, I read HERE that this might be because normal users use named pipes protocol and administrators TCP/IP but not sure how true it is. Any Ideas where to look?

  ConnString:

  Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Project1;Data Source=Server01\tabular;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error

• Brian Carlson

  SSCarpal Tunnel

  Points: 4170

  More actions

  September 21, 2015 at 11:44 am

  #1828179

  I would try running a server-side trace with SQL Profiler. You may be able to spot some other difference you didn't know was there.