Export (0) Print
Expand All

Connecting to Archiving and Monitoring Databases

 

Topic Last Modified: 2013-06-26

This topic describes how to connect to the Lync Online archiving and monitoring databases.

Use the following SQL Server fully qualified domain name (FQDN) for connectivity to the archiving and monitoring databases: archive.xxxd.mgd.msft.net where xxx is the number assigned to your domain (for example 997).

The database names are:

  • LcsLog_2400. Archiving database daily snapshot.

  • LcsCDR_2400. Call Detail Records (CDR) database daily snapshot.

  • QoEMetrics_2400. Quality of Experience (QoE) database daily snapshot.

To use SQL Management Studio to connect to the database:

  1. Click Start, All Programs, Microsoft SQL Server 2008. and then SQL Server Management Studio.

  2. In the Connect to Server dialog box, type archive.xxxd.mgd.msft.net where xxx is the number assigned to your customer domain. Then click Connect.

    5f4f7889-f4f8-4825-ba5e-527a8db526fc


    NoteNote:
    Ensure the user account you’re using to connect is a member of the Active Directory groups explicitly given permissions to the databases.
  3. After you’ve successfully connected to the SQL Server, expand Databases and then expand Database Snapshots as shown below. It’s possible to explore the databases in SQL Management Studio as you would any other database.

    f73250bb-bec0-4bd7-a0c0-197f56667799

It’s also possible to simply use ODBC data sources to connect to the databases. The following procedure describes how to create an ODBC data source that any ODBC-aware application can use to connect to the databases.

  1. Click Start, Control Panel, Administrative Tools, and then click Data Sources (ODBC).

  2. In the ODBC Data Source Administrator dialog box, click System DSN and then click Add.

    671cc4f2-9732-4c8c-ae11-6ff9738b61e4
  3. Highlight SQL Server and then click Finish.

    56085253-7350-4356-9857-bc950b0bccf9
  1. In the next dialog box, enter the data source name and type the FQDN of the SQL Server that has the relevant snapshots of the databases you're connecting to. This FQDN is always archiving.xxxd.mgd.msft.net where xxx is the number for your domain. Click Next.

    243b8e6a-71a7-4ed9-ae25-2eb2d63ec306
  2. In the next dialog box, select to use your current Active Directory credentials to connect to SQL and then click Next.

    dc42f6b3-1610-4f0e-88fa-83baf8aba873
  3. In the next dialog box, select the relevant database snapshot to query under Change the default database to: (for example, LcsCDR_2400, LcsLog_2400, or QoEMetrics_2400) and then click Next.

    e0f1ce74-ef0d-463c-9c0b-00ddaad40437
  4. Click Finish and then Test Connection. If the connection is successful you should see the following dialog box displayed. If connectivity or authentication fails, ensure you can resolve the FQDN of the SQL server, that you can telnet to it on TCP port 1433, and that the account you’re attempting to use has permissions necessary to connect to SQL and read from the database you’re attempting to access.

    72aae6b9-99c3-44b2-a2dd-1dd36ba9b5cf
  5. After the tests complete successfully, click OK, and then OK again. At this point the data source has been created and can be used by other applications to connect to the database. The screenshot below shows the data source that you created.

    867d95c4-5824-4c75-91c9-5dcaf24a0d5c

To learn how to use Excel to connect to the databases, see the Report Customization section in chapter two of the Microsoft Lync Server 2010 Resource Kit documentation (free download). Be sure to use the server and database names specified in the Server and Database Names section for connectivity.

 
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft