none
Unable to sync address book - Event ID 62011 & 62014 RRS feed

  • Question

  • Anybody familiar with Event ID 62011?

    I receive 62011 & 62014 every five minutes.

    I've tried running ABServer.exe -validateDB and ABServer.exe -syncNow

    It seems that it's not able to read the backend database.

     

    Log Name:      Office Communications Server
    Source:        OCS Address Book and Distribution List Expansion Web Service
    Date:          5/27/2010 12:23:08 PM
    Event ID:      62011
    Task Category: (1024)
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      OCS-FrontEnd.contoso.com
    Description:
    Address Book web service encountered an exception

    Microsoft.LiveServer.DLExpansion.AbWebServiceBackendException: Failed to connect to backend ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.LiveServer.DLExpansion.AbWebServiceBackend.Connect()
       --- End of inner exception stack trace ---
       at Microsoft.LiveServer.DLExpansion.AbWebServiceBackend.Connect()
       at Microsoft.LiveServer.DLExpansion.AbWebServiceSetting.InitBackendConnection()
       at Microsoft.LiveServer.DLExpansion.AbWebServiceSetting.Init()
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="OCS Address Book and Distribution List Expansion Web Service" />
        <EventID Qualifiers="50176">62011</EventID>
        <Level>2</Level>
        <Task>1024</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2010-05-27T17:23:08.000Z" />
        <EventRecordID>22449</EventRecordID>
        <Channel>Office Communications Server</Channel>
        <Computer>OCS-FrontEnd.contoso.com</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Microsoft.LiveServer.DLExpansion.AbWebServiceBackendException: Failed to connect to backend ---&gt; System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.LiveServer.DLExpansion.AbWebServiceBackend.Connect()
       --- End of inner exception stack trace ---
       at Microsoft.LiveServer.DLExpansion.AbWebServiceBackend.Connect()
       at Microsoft.LiveServer.DLExpansion.AbWebServiceSetting.InitBackendConnection()
       at Microsoft.LiveServer.DLExpansion.AbWebServiceSetting.Init()</Data>
      </EventData>
    </Event>

     

     

    Thursday, May 27, 2010 5:33 PM

Answers

  • So it turns out that the Windows Firewall was turned on.

    Not sure how that happened.  I turned it off when I built the server.

    Once I turned it off I was able to successfully run ABServer.exe -validateDB and ABServer.exe -syncNow.

     

    • Marked as answer by SDJCNE Tuesday, June 1, 2010 1:29 PM
    Tuesday, June 1, 2010 1:29 PM

All replies

  • If you install SQL 2008 Client Tools, you must also install SQL 2005 SP2 Backward Compatibility components.

     

    Could you connect to the SQL server with SQL management Studio that installed on FE server?

     

    Select both SQL and windows integrated authentication when installing SQL instances.

     

    Don't forget add exceptions in Firewall on backend SQL server for the connections between the servers.


    Best Regards!
    Friday, May 28, 2010 3:07 AM
  • Some background:

    It's a Win2k8 64-bit Ent server with OCS 2007 R2.

    This issue just started two days ago.  It's been running fine for months.  My other servers (archive & director) are having no problems.

    When I try running ABServer.exe -validateDB and ABServer.exe -syncNow they just hang and then stop.

     

    • Proposed as answer by UBIBASE Thursday, January 18, 2018 7:59 AM
    Friday, May 28, 2010 1:32 PM
  • So it turns out that the Windows Firewall was turned on.

    Not sure how that happened.  I turned it off when I built the server.

    Once I turned it off I was able to successfully run ABServer.exe -validateDB and ABServer.exe -syncNow.

     

    • Marked as answer by SDJCNE Tuesday, June 1, 2010 1:29 PM
    Tuesday, June 1, 2010 1:29 PM