Last week, I’d was instructed to draw out some Archived conversation for auditing purposes and while accessing the Lync Archiving Report, an error was thrown to me when running the query:

ArchSQL_Err1

An error has occurred during report processing. (rsProcessingAborted). Cannot create a connection to the data source “DataSource1″. (rsErrorOpeningConnection) 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: Name pipe Provider, error: 40 – Could not open a connection to SQL Server)

After affirming the followings are functioning:

  • SQL Server Services (Archiving Instance Name) is running
  • SQL Database is remotely accessible using the SQL Management Server
  • SQL Services listening on port 1433

I’d to check the SQL Reporting configuration.

From the top of the web page, anchor onto Lync Archiving Report, in which the page will bring you into the SQL Server Reporting Services:

Archiving_SQL Server Reporting Services

Move the mouse cursor over to the Lync Archiving Report > Select Manage to open up the Configuration Page

SSRS_Manage

 

SSRS - Test Connection Error

To solve this issue, change the parameters under the custom data source:

Data Source=SQLServerFQDN\Instance;Initial Catalog=LCSLog

Run the Test Connection to confirm the configuration and click on Apply. Go back to the Archiving Query page and there should be output on the Archived Messages

Arching Report

 

About these ads