New-CsPresencePolicy : The EXECUTE permission was denied on the object

Hi,

Am getting the above error on trying to create a second Presence policy,

(New-CsPresencePolicy -Identity "LargerPolicy" -MaxPromptedSubscriber 400 -MaxCategorySubscription 2000)

Believe I have all access required, is this a formatting or other error, or actually permission?

Thanks

April 13th, 2015 10:00am

Is that the complete error? Or does it also give a database name after Object?

Something similar to this.

The EXECUTE permission was denied on the object 'XdsPublishItems', database 'xds', schema 'dbo'"

Free Windows Admin Tool Kit Click here and download it now
April 13th, 2015 11:05am

yes , similar to that, can try again later and check, to confirm i am a CSAdministartor on Lync here.
April 13th, 2015 11:12am

Is that the complete error? Or does it also give a database name after Object?

Something similar to this.

The EXECUTE permission was denied on the object 'XdsPublishItems', database 'xds', schema 'dbo'"

Free Windows Admin Tool Kit Click here and download it now
April 13th, 2015 11:43am

This error typically refers to a permission issue on SQL.

Check whether you have appropriate permissions on the database mentioned in the error message.


April 13th, 2015 11:44am

See if this helps.

1.    Open SQL Server Management Studio.

2.    Go to Security > Logins

3.    Add the user who is executing the powershell command.

4.    Open the properties of the newly added user and click on User Mapping.

5.    Under User Mapping, click on Cpsdyn.

6.    Select Public under Database role membership for cpsdyn.

7.    Click on OK. 

Free Windows Admin Tool Kit Click here and download it now
April 13th, 2015 11:49am

nope.

Apparently you also need to be a RTCUniversalServerAdmin despite what teh documentation says. Works now.

April 21st, 2015 12:45pm

nope.

Apparently you also need to be a RTCUniversalServerAdmin despite what teh documentation says. Works now.

  • Marked as answer by J_help_thanks Tuesday, April 21, 2015 4:43 PM
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2015 4:43pm

nope.

Apparently you also need to be a RTCUniversalServerAdmin despite what teh documentation says. Works now.

  • Marked as answer by J_help_thanks Tuesday, April 21, 2015 4:43 PM
April 21st, 2015 4:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics