Unable to remotely Connect to SQL 2014 Databases.

  • Just built Windows 2012 R2 two Node Cluster SQL 2012 Enterprise

    I have three databases added

    1, Veeam Enterprise Manager Software using SQL Database running on a Windows 2012 R2 Server connecting remotely and works great
    2. ORF Fusion Software for Exchange 2010 on Windows 2008 the SQL Database connects to a Windows 2008 R2 and SQL  2008 Enterprise Server works fine there
    3. Manage Engine Ad Manager using SQL Database Running on Same Server as Number 1 and uses the same SQL Server as Number 2

    Task is to move databases Number 2 & 3 to the luster SQL server.

    I stopped the services and detached the databases from the SQL 2008 Server
    I attached the SQL databases to the SQL Cluster server.
    Created the logons required by each software product.

    When I started the service I get failed to connect messages.

     ADManager that Fails
    transaction_isolation = TRANSACTION_READ_COMMITTED
    sqlgenerator = com.adventnet.db.adapter.mssql.MssqlSQLGenerator
    url = jdbc:jtds:sqlserver://SERV014-N1-SQLC:1433/ADManagerDB;ssl=request
    dbadapter = com.adventnet.db.adapter.mssql.MssqlDBAdapter
    username = sa
    exceptionsorterclassname = com.adventnet.db.adapter.mssql.MssqlExceptionSorter
    maxsize = 20
    drivername = net.sourceforge.jtds.jdbc.Driver
    minsize = 1
    password = 0e09d8c940fe7404e8665a43de89a943

    ADManager that works
    transaction_isolation = TRANSACTION_READ_COMMITTED
    sqlgenerator = com.adventnet.db.adapter.mssql.MssqlSQLGenerator
    url = jdbc:jtds:sqlserver://SERV010:1433/ADManagerDB;ssl=request
    dbadapter = com.adventnet.db.adapter.mssql.MssqlDBAdapter
    username = sa
    exceptionsorterclassname = com.adventnet.db.adapter.mssql.MssqlExceptionSorter
    maxsize = 20
    drivername = net.sourceforge.jtds.jdbc.Driver
    minsize = 1
    password = 0e09d8c940fe7404e8665a43de89a943

    ORF that works
    Provider=sqlncli10;server=serv010,1433;database=ORF;UserId=orfuser;Password=myeyesonly55;DataTypeCompatibility=80; 

     ORF that fails
    Provider=sqlncli10;server=serv014-N1-SQLC,1433;database=ORF;UserId=orfuser;Password=myeyesonly55;DataTypeCompatibility=80;

    Any way I can test the SQL connection remotely from the two computers?

    Any ideas

    Thank you

    Tom

  • Hi,
    you can use an udl file:
    https://blogs.msdn.microsoft.com/farukcelik/2007/12/31/basics-first-udl-test/
    It is quite simple to use
    best regards,
    Andreas

  • trgrassijr - Saturday, May 12, 2018 6:32 PM

    When I started the service I get failed to connect messages.

    Please post the text for those error messages. Also check the SQL Server error log and post the details for the errors.

    Sue

  • Thank you for responding.

    I had to install SQLNCLI11  on the Exch and I had to change the SQL Server Authentication Mode to MIXED

    Now I can connect.

    Thank you for all the help

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply