User is authentication as "anonymous login"

• winston Smith

  SSCoach

  Points: 19500

  More actions

  January 20, 2012 at 3:35 am

  #144876

  I have a user who cannot refresh their reports. I ran a profiler trace and can see they are hitting the server with "ANONYMOUS LOGIN" user name, which the server is configured to disallow.

  I cannot figure out why the report ( an excel spreadsheet powerpivot report) is not using the users windows domain credentials (domain\usrname) to log in.

  Any ideas why the report is using ANONYMOUS, instead of windows authentication, seeing as i have specified that it use Windows Authentication?

• winston Smith

  SSCoach

  Points: 19500

  More actions

  January 20, 2012 at 4:31 am

  #1436366

  Stupid mistake, was not using SSPI in my connection string.