locked
Problems with Front End pool servers accessing SQL DB RRS feed

  • Question

  • Good afternoon, Folks... 1st post here, but I'm sure that I'll be here quite a bit as we're implementing a rather large OCS solution here at my company (potentially 10k+ users). 

     

    At the moment, I'm trying to expand our existing front end pool.  I have installed another front end server, and succefully gone through the wizard, starting services and configuring the cert. 

     

    Now that I've got the server in the pool, it looks like it's not fully integrated into the pool.  All of the services show as running on the box, but if I try using the Management console from another server or workstation to look at the pool, I will see it as in the pool, but I'm unable to retrieve any data from it. 

     

    I'm new to these forums, and really would like to learn how to better troubleshoot these kinds of things.  What kind of information should I look for / post?

     

    Here's the error I get from the validation tool

     

    Failure
    [0xC3FC200D] One or more errors were detected

     

    and here are the errors in the even log:

     

    Failed to connect to back-end database. Office Communications Server will continuously attempt to reconnect to the back-end. While this condition persists, incoming messages will receive error responses.

    Back-end Server: ocssqlvirtual Database: rtc Connection string of:

    driver={SQL Server};Trusted_Connection=yes;AutoTranslate=no;server=ocssqlvirtual;database=rtc;

    Cause: Possible issues with back-end database.

    Resolution:

    Ensure the back-end is functioning correctly.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

    The process IMMcuSvc(3820) failed to send health notifications to the MCU factory at https://STNEOCSPool1.stone.ne.gov:444/LiveServer/MCUFactory/.

    Failure occurrences: 5, since 11/19/2008 12:31:52 PM.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

    The process IMMcuSvc(3820) failed to send health notifications to the MCU factory at https://STNEOCSPool1.stone.ne.gov:444/LiveServer/MCUFactory/.

    Failure occurrences: 5, since 11/19/2008 12:31:52 PM.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

    Failed to connect to back-end dynamic database. Office Communications Server will continuously attempt to reconnect to the back-end. While this condition persists, incoming messages will receive error responses.

    Back-end Server: ocssqlvirtual Dynamic Database: rtcdyn Connection string of:

    driver={SQL Server};Trusted_Connection=yes;AutoTranslate=no;server=ocssqlvirtual;database=rtcdyn;

    Error: 800407D0

    Cause: Possible issues with back-end dynamic database.

    Resolution:

    Ensure the back-end is functioning correctly.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

    Thank you very much for any help offered!

    Wednesday, November 19, 2008 8:50 PM

Answers

  • Thanks, that's exactly what it acted like, actually.  I was able to decomission those servers and the problems went away... with a new service account for the front end.  Thanks!

    Monday, December 8, 2008 5:15 PM

All replies

  • Can you verify that your OCS does not have CA installed

    http://support.microsoft.com/kb/938296

     

     

    Wednesday, November 19, 2008 9:31 PM
  • Thank you for the reply.  This is happening on a Standard Edition server which would exclude the possibility that CA is running, I believe.

    Wednesday, November 19, 2008 10:13 PM
  • I do not agree on that one

    You can have CA on all versions except web edition. With Enterprise Edition you do have more flexibility with certs

    Just check if the service "Certificate Services" is running on your box

     

    Wednesday, November 19, 2008 10:22 PM
  • I stand corrected then, thank you.  :-)... but I did check prior to my reply, just to verify that CA was NOT running.

     

    CA is not running on that box

    Wednesday, November 19, 2008 10:49 PM
  • Have you installed a second Enterprise Edition with a loadbalancer in front?

    You have checked the SQL services are running right?

    You used the same Service account?

    Wednesday, November 19, 2008 10:54 PM
  • Have you installed a second Enterprise Edition with a loadbalancer in front?

    Yes, we have an F5 in front, I believe

    You have checked the SQL services are running right?

    Yes, they are running

    You used the same Service account?

    Yes, I am.  Should the service account and guest access accounts have any specific permissions per login to the sql box?  (I didn't start this project, just jumped in in the middle of deployment of this monster).

     

    Right now, I don't see specific logins for the service or guest accounts on the SQL machine.  I see rtc, rtcconfig, and rtcdyn for databases on the machine.  Could anyone give me a breakdown on what rights are needed where?

     

    Thank you for your patience and help!!

     

     

    Thursday, November 20, 2008 2:23 PM
  • Maybe the other FE computer account is used for authentication in SQL?

     

    Friday, November 21, 2008 8:44 PM
  • Thanks, that's exactly what it acted like, actually.  I was able to decomission those servers and the problems went away... with a new service account for the front end.  Thanks!

    Monday, December 8, 2008 5:15 PM