4 replaced http://stackoverflow.com/ with https://stackoverflow.com/
source | link

The following worked for us:

  • Right click on the SQL server database instance
  • Click on the Permissions

**Permissions**

  • Select the user in concern
  • Make sure that View Server State privilege is granted to the user

<code>View Server State privilege</code> is granted to the user

Alternatively, in case of lack of required permissions - ask the sys admin to execute the following code:

use master
go
GRANT VIEW SERVER STATE TO <user_name>

Use the below syntax in case of users in domainusers in domain

use master
go
GRANT VIEW SERVER STATE TO [domain\user]

The following worked for us:

  • Right click on the SQL server database instance
  • Click on the Permissions

**Permissions**

  • Select the user in concern
  • Make sure that View Server State privilege is granted to the user

<code>View Server State privilege</code> is granted to the user

Alternatively, in case of lack of required permissions - ask the sys admin to execute the following code:

use master
go
GRANT VIEW SERVER STATE TO <user_name>

Use the below syntax in case of users in domain

use master
go
GRANT VIEW SERVER STATE TO [domain\user]

The following worked for us:

  • Right click on the SQL server database instance
  • Click on the Permissions

**Permissions**

  • Select the user in concern
  • Make sure that View Server State privilege is granted to the user

<code>View Server State privilege</code> is granted to the user

Alternatively, in case of lack of required permissions - ask the sys admin to execute the following code:

use master
go
GRANT VIEW SERVER STATE TO <user_name>

Use the below syntax in case of users in domain

use master
go
GRANT VIEW SERVER STATE TO [domain\user]
3 replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
source | link

The following worked for us:

  • Right click on the SQL server database instance
  • Click on the Permissions

**Permissions**

  • Select the user in concern
  • Make sure that View Server State privilege is granted to the user

<code>View Server State privilege</code> is granted to the user

Alternatively, in case of lack of required permissions - ask the sys admin to execute the following codefollowing code:

use master
go
GRANT VIEW SERVER STATE TO <user_name>

Use the below syntax in case of users in domain

use master
go
GRANT VIEW SERVER STATE TO [domain\user]

The following worked for us:

  • Right click on the SQL server database instance
  • Click on the Permissions

**Permissions**

  • Select the user in concern
  • Make sure that View Server State privilege is granted to the user

<code>View Server State privilege</code> is granted to the user

Alternatively, in case of lack of required permissions - ask the sys admin to execute the following code:

use master
go
GRANT VIEW SERVER STATE TO <user_name>

Use the below syntax in case of users in domain

use master
go
GRANT VIEW SERVER STATE TO [domain\user]

The following worked for us:

  • Right click on the SQL server database instance
  • Click on the Permissions

**Permissions**

  • Select the user in concern
  • Make sure that View Server State privilege is granted to the user

<code>View Server State privilege</code> is granted to the user

Alternatively, in case of lack of required permissions - ask the sys admin to execute the following code:

use master
go
GRANT VIEW SERVER STATE TO <user_name>

Use the below syntax in case of users in domain

use master
go
GRANT VIEW SERVER STATE TO [domain\user]
2 deleted 45 characters in body
source | link

The following worked for us:

We solved this by making sure that:

  • Right click on the SQL server database instance
  • Click on the Permissions

**Permissions**

  • Select the user in concern
  • Make sure that View Server State privilege is granted to the user

<code>View Server State privilege</code> is granted to the user

Alternatively, in case of lack of required permissions - ask the sys admin to execute the following code:

use master
go
GRANT VIEW SERVER STATE TO <user_name>

Use the below syntax in case of users in domain

use master
go
GRANT VIEW SERVER STATE TO [domain\user]

The following worked for us:

We solved this by making sure that:

  • Right click on the SQL server database instance
  • Click on the Permissions

**Permissions**

  • Select the user in concern
  • Make sure that View Server State privilege is granted to the user

<code>View Server State privilege</code> is granted to the user

Alternatively, in case of lack of required permissions - ask the sys admin to execute the following code:

use master
go
GRANT VIEW SERVER STATE TO <user_name>

Use the below syntax in case of users in domain

use master
go
GRANT VIEW SERVER STATE TO [domain\user]

The following worked for us:

  • Right click on the SQL server database instance
  • Click on the Permissions

**Permissions**

  • Select the user in concern
  • Make sure that View Server State privilege is granted to the user

<code>View Server State privilege</code> is granted to the user

Alternatively, in case of lack of required permissions - ask the sys admin to execute the following code:

use master
go
GRANT VIEW SERVER STATE TO <user_name>

Use the below syntax in case of users in domain

use master
go
GRANT VIEW SERVER STATE TO [domain\user]
1
source | link