Run as account does not exist MSSQL management pack

All replies

• 

  

  0

  Sign in to vote

  I give this rights because it's a hell of a job to give rights to every database. With Sysadmin rights the MP has enough rights to do the job. 

  Monday, August 18, 2014 9:16 AM
• 

  

  0

  Sign in to vote

  Hi,

  Check the SQL Server Configuration manager. Do you have TCP/IP enabled in SQL Server Network Configuration?

  ---

  http://OpsMgr.ru/

  Monday, August 18, 2014 9:16 AM
• 

  

  0

  Sign in to vote

  Yes we use it to configure our instance.

  Monday, August 18, 2014 9:41 AM
• 

  

  0

  Sign in to vote

  Hi,

  Please check whether the action account is added to the local admin group on the SQL server.

  Have you configured a specif account for SQL monitoring and if you have do you have it distributed to the SQL servers in Question?

  http://blogs.technet.com/b/kevinholman/archive/2010/09/08/configuring-run-as-accounts-and-profiles-in-r2-a-sql-management-pack-example.aspx

  For more details:

  http://technet.microsoft.com/en-us/library/bb735423.aspx

  Regards,

  Yan Li

  ---

  Regards, Yan Li

  
  

  • Edited by Yan Li_ Thursday, August 21, 2014 2:58 AM edit
  • Marked as answer by Yan Li_ Friday, August 29, 2014 4:39 AM

  Thursday, August 21, 2014 2:51 AM
• 

  

  0

  Sign in to vote

  Verify the credential of Run As Account. and follow below steps in below link for this issue

  http://blog.coretech.dk/msk/run-as-account-does-not-exist-on-the-target-system-or-does-not-have-enough-permissions/

  http://blogs.technet.com/b/kevinholman/archive/2010/09/08/configuring-run-as-accounts-and-profiles-in-r2-a-sql-management-pack-example.aspx

  ---

  Please remember, if you see a post that helped you please click "Vote As Helpful" and if it answered your question, please click "Mark As Answer" Mai Ali | My blog: Technical | Twitter: Mai Ali

  • Edited by Mai AliMVP Thursday, August 21, 2014 12:59 PM
  • Marked as answer by Yan Li_ Friday, August 29, 2014 4:39 AM

  Thursday, August 21, 2014 12:58 PM
• 

  

  0

  Sign in to vote

  The alert message description indicated that there is a permisson issue in running GetSQL2008DBFileGroupFreeSpace.vbs. This indicated that your action account, SQL Server Monitoring Acccout has no permission in your SQL server. Make sure that the account scom.msa is a SQL Server Monitoring Account on a problematic SQL server.
  For how to configure Run as account and profiles, pls. refer to
  http://blogs.technet.com/b/kevinholman/archive/2010/09/08/configuring-run-as-accounts-and-profiles-in-r2-a-sql-management-pack-example.aspx

  Roger

  • Marked as answer by Yan Li_ Friday, August 29, 2014 4:39 AM

  Monday, August 25, 2014 9:18 AM
• 

  

  0

  Sign in to vote

  Hi Mai,

  I really liked the first article. It gives a good summary of whats needed.

  Kind regards,

  André

  Friday, August 29, 2014 7:14 AM