SQL Server Permissions warning issue

[bagrationi]

 Hello,

After Enterprise Vault 8.0 server deployment i have received the error event id's - named: Storage management, Error ID: 13360 in event viewer.


In general, i have seen also the warning message in deployment scanner results:



SQL Server Permissions

Warning


SQL: The user Domain\vault_user does not have VIEW SERVER STATE permission required by Enterprise Vault Monitoring



I think that, those two issues above are  in touch.


Anybody have the solution about this warning and how to resolve it ?


Thanks in advance,

[GertjanA]

Hello,

You need to set this in SQL Management Studio (or enterprise manager on older versions of SQL)
See installing and configuring pdf file. page 45

Gertjan

[bagrationi]

 I have SQL Server 2005 Enterprise, and as installing and configuring pdf manual page 45 says, on SQL server 2005 we should create only a SQL login account and give vault service account dbcreator permission.

Generally, nothing was said about  "VIEW SERVER STATE"  permission in SQL Server 2005 section in this manual.

GRANT VIEW SERVER STATE permssion, was mentioned only in SQL Server 2008 section in installing and configuring manual.


So, what action should i take.... could you advice me ?


thanks,

[Batmanfail · Accepted solution]

Granted, I have the EV8.0SP3 Installing and Configuring Guide (not the base EV8.0), but on Page 45 it does say;

In the toolbar, click New Query.

Enter the following script:

use Master

GRANT VIEW SERVER STATE TO "domain\vsa_account"

GO

where domain\vsa_account is the domain and name of the Vault Service

account.

Click Execute.

...for SQL2005...

[bagrationi]

  Ok thanks, I will try it...

[bagrationi]

  
 Thank you guys, it work.

Usually i have symantec enterprise vault 8.0 SP2 documentation and within nothing was wrote about "view server state" permission in SQL 2005.

.... Fortunately it was in SP3 EVault version

thanks,  

[GertjanA]

Ciao Bagrationi,

Can you pls mark a post as a solution?
Otherwise people will open this thread, and see it actually is resolved.
Adding a solution also gives people having the same issue a lead to a possible solution for them.

Thanks.