locked
can not apply permission to secodary replica "Install-CsDatabase -ConfiguredDatabases -SqlServerFqdn “SBDSQL.domain.com” -Update RRS feed

  • Question

  • Dear Forun, currently we can not give permission to secondary replica for my sql server, when I failover to secondary replica all my skype for business user has limit functional and I run apply permission to the secondary has the error.

    Note: when I configure SQL alwaysOn, I don't run this scrip on SQL1, SQL2, so the problem due to I don't run this scrip? Thank all for your sharing.

    USE [master] GO CREATE ENDPOINT [Hadr_endpoint]     AS TCP (LISTENER_PORT = 5022)     FOR DATA_MIRRORING (ROLE = ALL, ENCRYPTION = REQUIRED ALGORITHM AES) GO IF (SELECT state FROM sys.endpoints WHERE name = N'Hadr_endpoint') <> 0 BEGIN     ALTER ENDPOINT [Hadr_endpoint] STATE = STARTED END GRANT CONNECT ON ENDPOINT::[Hadr_endpoint] TO [NT Service\MSSQLSERVER] GRANT CONNECT ON ENDPOINT::[Hadr_endpoint] TO [Adatum\LON-SQL2$]

    Thursday, September 7, 2017 6:55 AM

All replies

  • Hi sophal peang,

    For SFB server, you need to give the specific permission for SQL server, the following document is for your reference

    https://technet.microsoft.com/en-us/library/gg398375(v=ocs.15).aspx

    Which function limitation did you encounter with Skype for Business?

    When you want to apply permission to the second SQL server, what event ID did you encounter in SFB server? Please try to provide the error message for us.

    I will share a document about how to deploy SQL always on for Skype for Business server, please refer to

    https://blogs.technet.microsoft.com/uclobby/2015/05/08/deploying-sql-server-alwayson-availability-group-for-skype-for-business-server-2015/

    Hope this reply is helpful to you.


    Regards,

    Alice Wang


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    • Edited by Alice-Wang Friday, September 8, 2017 2:42 AM
    Friday, September 8, 2017 2:34 AM
  • Hi sophal peang,

    Recently, I seen another similar situation, the root cause for this issue that Skype for Business Log file is full, so we suggest you try to increase log file size, then test again.


    Regards,

    Alice Wang


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, September 11, 2017 5:45 AM
  • Hello Sir, noted and thanks I will increase Skype for Business Log file and try to Apply the permission again. Thank you 
    Tuesday, September 12, 2017 1:27 AM
  • Hi sophal,

    OK, we will wait for your response.


    Regards,

    Alice Wang


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, September 12, 2017 1:32 AM