Answered Archiving Database issue

  • 23 เมษายน 2554 13:21
     
     

    I have following errors reading from the Archiving Db

    Export-CsArchivingData : 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: Named Pipes Provider, error
    : 40 - Could not open a connection to SQL Server)
    At line:1 char:23
    + Export-CsArchivingData <<<<
        + CategoryInfo          : WriteError: (Microsoft.Rtc.A...ArchiveDataImpl:E
       xportArchiveDataImpl) [Export-CsArchivingData], ArchJournalException
        + FullyQualifiedErrorId : Export-CsArchivingData,ExportArchiveData.ExportA
       rchiveDataCmdlet


    Export-CsArchivingData : 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, err
    or: 26 - Error Locating Server/Instance Specified)
    At line:1 char:23
    + Export-CsArchivingData <<<<
        + CategoryInfo          : WriteError: (Microsoft.Rtc.A...ArchiveDataImpl:E
       xportArchiveDataImpl) [Export-CsArchivingData], ArchJournalException
        + FullyQualifiedErrorId : Export-CsArchivingData,ExportArchiveData.ExportA
       rchiveDataCmdlet

    The server is windows 2008 r2 with Sql 2008.

    I use to see the messages runnign SQL query , but now that goes to debugging mode.

    The Powershell command I used was export-archivingdata..

    my sql instance is lync server FQDN\lcslog  .. This db is present.

    I installed SQL in mixed mode with default settings ..

    thanks

     

     

     

ตอบทั้งหมด

  • 24 เมษายน 2554 5:12
     
     
    I can also see the messages in the queue through SQL query .. it is just that the Powershell command is not working . Windows 2008 R2 Sp1 is the archiev server ?
  • 24 เมษายน 2554 7:12
     
     คำตอบ

    Finally Got it.

    Instead of putting fqdn of the sqlservername\dbinstance etc etc.. just typed the netbios server name and it worked. ( no db instance etc).

    I still may be missing something .. but honestly very few docs on Lync .

    Anyway it is working 

     

     

  • 25 เมษายน 2554 1:09
    ผู้ดูแล
     
     

    Hi,

    You can get more docs in MS technet.

    http://technet.microsoft.com/en-us/library/gg293124.aspx

     

    Regards,

    Sharon


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.