Database Connection Issue While Profiling

• 
  Just to clarify - everything is running on the same server as APP?

  Russell D January 14, 2019 08:36

  - 0 +
• 
  Yep, this is all my local dev environment.

  JasonBock January 14, 2019 14:01

  - 0 +
• 
  Hi Jason, most likely your SQL server uses Windows/AD authentication. You should run you profiler under account having access to Sql.
  

  Check "Show server options/Manually specify ASP account details" setting when starting profiling.
  

  AlexanderMz January 14, 2019 14:07

  - 0 +
• 
  So here's what I tried. I went into the profiling configuration and tried to change "Manually specify ASP account details".
  
  If I don't use the same account used for the app pool that the API runs under, I get this error (the REDACTED is client-specific info):
  
  

  [SqlException]: Cannot open database "REDACTED" requested by the login. The login failed.
  Login failed for user 'REDACTED$'.
  
  
  If I use the same account used for the app pool that the API runs under, I get this error:
  
  [MethodAccessException]: Attempt by security transparent method 'System.Net.Http.HttpClient.FinishSendAsync(System.Threading.Tasks.Task`1<System.Net.Http.HttpResponseMessage>, System.Net.Http.HttpRequestMessage, System.Threading.CancellationTokenSource, Boolean)' to call native code through method '<Module>._ANTS_Begin_Async()' failed.  Methods must be security critical or security safe-critical to call native code.
  
  So....not sure where to go from here. Any other ideas? Or am I not setting the profiling session up correctly?
  
  

  JasonBock January 14, 2019 20:47

  - 0 +
• 
  @JasonBock for the latter exception, find LineLevelBlacklist.xml file (%LocalAppData%\Red Gate\ANTS Performance Profiler 10\LineLevelBlacklist.xml) and put the following line there:
  

    <assemblyName>System.Net.Http</assemblyName>
  

  
  
  
  
  

  AlexanderMz January 15, 2019 07:44

  - 0 +
• 
  I'll give that a whirl...

  JasonBock January 15, 2019 14:01

  - 0 +
• 
  AleanderMz, that did the trick! Thanks for the help.

  JasonBock January 16, 2019 20:33

  - 0 +

Add comment

Please sign in to leave a comment.