These instructions help you configure your Skype for Business phone system to work with TIM Plus. Contact your system maintainer if you are not familiar with the configuration of your PBX.

<a id="Configure the SMDR output"></a>

Configuring the SMDR output

By default, the Skype for  Business phone system writes its CDR data to a MSSQL database called LcsCdr. In order for TIM Plus to connect to the database and collect the call logging data, a Windows or SQL authenticated login will have to be created to allow access. Contact your system maintainer if you are not familiar with this procedure.

The following information is required for TIM Plus to connect to the LcsCdr database:

• IP address or hostname of the SQL Server where the LcsCdr database resides.
• Username and Password of the LcsCdr database.

<a id="Setting up a DSN connection"></a>

Setting up a DSN connection

To enable TIM Plus to work with your Skype for Business phone system, you first need to set up a DSN connection by following the steps below:

1. Open Windows Control Panel and select the  icon

2. Double-click on the Data Sources (ODBC) icon to open the ODBC Data Source Administrator window

   For a 64 bit system, access the ODBC Data Source Administrator from the following location C:\Windows\SysWOW64\odbcad32.exe

3. Click on the System DSN tab
4. Click on the Add button
5. Select SQL Native Client from the driver list and click Finish.
6. In the Name field, enter lync
7. In the Description field, enter TIM Plus link to LcsCDR
   
8. In the Server field, enter the IP address or hostname of your SQL server
9. In the Username field, enter the username for your LcsCdr database
10. In the Password field, enter the password for your LcsCdr database
11. In the Database drop-down list, select  
12. Click on the Test button to confirm the information you entered is correct and that the connection is successful
13. Click on the OK button to close the window
    
    

An example of an ODBC entry is shown below: