Cannot Connect to the Database Server from the Data Link Server

Environment

Service Data (Backend Services)
Feature Data Connectors

Description

When configuring a data connector to a database that requires the Data Link Server, an error occurs after clicking the Test button.

At the same time, opening the Data Link Server URL in a web browser returns Result: OK.

Error Message

Data Link Server Error: Cannot connect to database. [Telerik Platform] The connection to the host [hostname], named instance [instance name] failed. Error: [message]. Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

Cause

The error signifies that the Data Link Server cannot connect to the database even though the connection between Telerik Platform and the Data Link Server is successful.

Solution

Ensure that the supplied connection string is in the correct format for the respective database server:

  • Microsoft SQL Server

    <machine-name>\<database-server-name>;DatabaseName=<database-name>;user=<username>;password=<password-string>

    Example:
    win15\SQLServer;DatabaseName=ExampleDatabase;user=jsmith;password=pa$$

  • Oracle

    <database-server-address>:<port-number>;ServiceName=<database-name>;User=<username>;Password=<password-string>

    Example:
    lnx15.example.com:1521;ServiceName=ORCL;User=jsmith;Password=pa$$

  • MySQL Enterprise

    <database-server-address>:<port-number>;DatabaseName=<database-name>;User=<username>;Password=<password-string>

    Example:
    lnx15.example.com:3306;DatabaseName=ExampleDatabase;User=jsmith;Password=pa$$

  • PostgreSQL

    <database-server-address>:<port-number>;DatabaseName=<database-name>;User=<username>;Password=<password-string>

    Example:
    lnx15.example.com:5432;DatabaseName=ExampleDatabase;User=jsmith;Password=pa$$

See Also

Start a free trial Request a demo
Contact us: +1-888-365-2779
sales@telerik.com
Copyright © 2016-2017, Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.