Updated from 3.x to 4 - insufficient credentials error now

• 
  Hello,
  
  I've never seen SQL Monitor 3.x try to write to tempdb, so it must be part of the new performance analysis in v4. Most users would have the ability to write to tempdb as it's used implicitly by SQL Server as storage space for joins and other things. Thanks for pointing that out.

  Brian Donahue January 13, 2014 09:23

  - 0 +
• 
  Thanks for the reply - are these permissions (db_datareader/writer) going to be reflected in the official documentation?

  joshuawferguson January 13, 2014 09:32

  - 0 +
• 
  I've requested that this is included in future.

  Brian Donahue January 17, 2014 07:08

  - 0 +
• 
  I know this is a bit after the fact, but I found (on another server) that if sqlmonitor's login doesn't have ddl_admin rights on tempdb, it also fails. By default (without this ddl_admin right) the login should be capable of creating temporary tables (with the # prefix) in tempdb. Why is sqlmonitor trying to create permanent tables in tempdb? Seems very counter intuitive. . .

  joshuawferguson January 28, 2014 11:48

  - 0 +
• 
  Thanks for this topic, it helped me too. I encountered this same issue on a fresh install of version 4.
  I agree, this was not mentioned in the official documentation page (http://documentation.red-gate.com/display/SM4/Requirements) at time of this post.

  thtwill February 13, 2014 12:01

  - 0 +
• 
  the same happens on the hosted beta of SQL Monitor: it tries to create "permanent" tables in TempDB.

  TheLonelyDBA March 11, 2014 15:41

  - 0 +
• 
  Hello all,
  
  I know it's quite a bit after the fact, but for anyone reading I wanted to mention the documentation has now been updated to include the need for db_datareader and db_datawriter on tempdb.
  
  Kind regards,
  Alex

  Alex B August 02, 2016 15:59

  - 0 +

Add comment

Please sign in to leave a comment.