SAP Knowledge Base Article - Preview

2281803 - Driver error: SQL Server did not return a response. The connection has been closed. Lumira Desktop connecting to MS SQL 2008

Symptom

  • Attempting to connect Lumira Desktop to SQL Server 2008 using the database account results in the error:

Driver error: SQL Server did not return a response. The connection has been closed.

 2281803.png

  • When using the Advance setting with "instanceName=[Server Name]" the error thrown is:

Driver error: The connection to the host <HOST NAME>, named instance <Instance> failed. Error: "java.net.SocketTimeoutException: Receive timed out (local ports <port number> to address::;, remote unknown port to unknown host)". Verify the server and instance names and check that no firewall is blocking UDP traffic to port <port number>. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

2281803-2.png

Lumira


Read more...

Environment

  • SAP Lumira Desktop

Product

SAP BusinessObjects Business Intelligence, Edge edition 4.0, standard package ; SAP Lumira, desktop edition 1.0

Keywords

database server story microsoft , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , BI-LUM-SRV , SAP Lumira Server , BI-LUM-OD , SAP Lumira Cloud , BI-LUM-LIM , Lumira In-Memory Add-on to BOE , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.