none
Create Data Source Connection Timeout

    Question

  • Hi all, 

    I'm trying to create a data source from SQL Server.

    This is my script

    CREATE DATA SOURCE SQLServerDataSource
    FROM SQLSERVER
    WITH
    (
        PROVIDER_STRING = "Database=WideWorldImporters;Integrated Security=False;Encrypt=True",
        CREDENTIAL = WWI_Secret,
        REMOTABLE_TYPES = (bool, byte, /*sbyte,*/ short, /*ushort,*/ int, /*uint,*/ long, /*ulong,*/ decimal, float, double, string, DateTime)
    );

    This is the error message I get:

    <label class="msportalfx-text-label" data-bind="text: titleLabel">Error</label>
    E_CSC_SYSTEM_INTERNAL
    <label class="msportalfx-text-label" data-bind="text: messageLabel">Message</label>
    Internal error! Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=5; handshake=29983; 

    Is there anything that I can do to resolve this issue?

    Thanks in advance, 

    Ust

    Tuesday, February 7, 2017 3:28 PM