While performing an update or fresh installation of GroupShare, you are encountering the following error message:
SDL Trados GroupShare Fatal Error An exception occurred while executing a Transact-SQL statement or batch Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: View SERVER STATE permission was denied on object 'server', database 'master'.
The service account which is used for SDL Trados GroupShare database connection does not have View Server State permissions on the Microsoft SQL Server. Ideally, the account used to perform any installation/upgrade should have the sysadmin permission on the SQL Server.
Provide the 'View Server State' permission to the SDL Trados GroupShare service account.
Note: Changes to databases and/or configuration should be applied by trained personnel like a database administrator.
From the SQL Server Management Studio:
Connect to the Microsoft SQL instance that is hosting the relevant SDL Trados GroupShare databases.
Navigate to Security > Logins
Right Click the account which was configured for the database connection in SDL Trados GroupShare
Select the Securables page
In Permissions for [SQL INSTANCE NAME], scroll to View Server State