locked
Server 2016 TP5 - Applications cannot connect to SQL / ODBC entries not found / when RDP Session Host is installed RRS feed

  • Question

  • Hi everyone,

    im testing the new TP5 of Windows Server 2016.

    We have an Application which needs a 32bit ODBC System entry to connect to the SQL Server.

    This works normaly.

    But after i installed the RDP Session Host (installed over RDS 2016 Broker, then i created a Farm) all my Applications cannot connect to the SQL Server anymore.

    I also tried to install the RDS Session host directly standalone on the server without any Gateway or Broker behind.

    Then i got the same problem.

    After removing the RDS Session Host Role from the Server and rebooting, the Applications work all again without errors.

    This is a LOG of one of our appliactions which do not work anymore after installing RDP Session host on the Machine.

    Software: BMD NTCS 

    Error LOG, when the Session Host is installed.

    OLE DB error occurred. Code 80004005h
    Class: TBMDSDACDatabase
    Methode:SC
    (0137512E){BMDNTCS.exe } [0177612E] OLEDBAccess.TOLEDBConnector.OLEDBError (Line 1690, "OLEDBAccess.pas" + 120) + $3
    (013747B6){BMDNTCS.exe } [017757B6] OLEDBAccess.TOLEDBConnector.Check (Line 1447, "OLEDBAccess.pas" + 2) + $13
    (0137741B){BMDNTCS.exe } [0177841B] OLEDBAccess.TOLEDBConnector.Connect (Line 2327, "OLEDBAccess.pas" + 71) + $15
    (0001A241){oleaut32.dll} [7430B241] VariantClear + $81
    (00036BA1){BMDNTCS.exe } [00437BA1] Variants.@VarClear + $D
    (00036BA9){BMDNTCS.exe } [00437BA9] Variants.@VarClr + $1
    (012055A6){BMDNTCS.exe } [016065A6] DBAccess.TDATransaction.SetITransaction (Line 17434, "DBAccess.pas" + 13) + $1B
    (01368337){BMDNTCS.exe } [01769337] MSClasses.TMSSQLConnection.Connect (Line 1190, "MSClasses.pas" + 7) + $8
    (011E2BEE){BMDNTCS.exe } [015E3BEE] DBAccess.TCustomDAConnection.DoConnect (Line 4065, "DBAccess.pas" + 16) + $D
    (013A8080){BMDNTCS.exe } [017A9080] MSAccess.TCustomMSConnection.DoConnect (Line 2089, "MSAccess.pas" + 1) + $3
    (011E2FB7){BMDNTCS.exe } [015E3FB7] DBAccess.TCustomDAConnection.PerformConnect (Line 4181, "DBAccess.pas" + 8) + $5
    (011E6371){BMDNTCS.exe } [015E7371] DBAccess.TCustomDAConnection.SetConnected (Line 5184, "DBAccess.pas" + 91) + $5
    (0000B9B9){BMDNTCS.exe } [0040C9B9] System.UnicodeToUtf8 + $31
    (0004342A){BMDNTCS.exe } [0044442A] TypInfo.SetOrdProp + $36
    (000429EC){BMDNTCS.exe } [004439EC] TypInfo.SetPropValue + $180
    (00042683){BMDNTCS.exe } [00443683] TypInfo.SetPropValue + $2B
    (02A539E8){BMDNTCS.exe } [02E549E8] BMDDatabase.TBMDDatabase.SetConnected (Line 585, "BMDDatabase.pas" + 8) + $19
    (0147B136){BMDNTCS.exe } [0187C136] BMDSDACDatabase.TBMDSDACDatabase.SetConnected (Line 367, "BMDSDACDatabase.pas" + 4) + $6
    (02A53D7F){BMDNTCS.exe } [02E54D7F] BMDDatabase.TBMDDatabase.DoDatabaseLogin (Line 661, "BMDDatabase.pas" + 25) + $7
    (017C76E8){BMDNTCS.exe } [01BC86E8] BMDLoginDM.TBMDDMLogin.DoDatabaseLogin (Line 216, "BMDLoginDM.pas" + 13) + $1A
    (015ED2D2){BMDNTCS.exe } [019EE2D2] BMDEdit.TBMDEdit.GetText (Line 1360, "BMDEdit.pas" + 1) + $6
    (02B54CCA){BMDNTCS.exe } [02F55CCA] BMDLoginFrm.TBMDFRMLogin.DoDatabaseLogin (Line 1125, "BMDLoginFrm.pas" + 1) + $5A
    (0018ED90){BMDNTCS.exe } [0058FD90] Forms.TCustomForm.Hide (Line 6569, "Forms.pas" + 1) + $5
    (02B566A4){BMDNTCS.exe } [02F576A4] BMDLoginFrm.TBMDFRMLogin.OnBtnLoginClick (Line 1558, "BMDLoginFrm.pas" + 14) + $5
    (000B27D8){BMDNTCS.exe } [004B37D8] Controls.TControl.Click (Line 7190, "Controls.pas" + 9) + $C
    (000F321D){BMDNTCS.exe } [004F421D] StdCtrls.TCustomButton.Click (Line 4562, "StdCtrls.pas" + 3) + $3
    (000F41AF){BMDNTCS.exe } [004F51AF] StdCtrls.TCustomButton.CMDialogKey (Line 5033, "StdCtrls.pas" + 6) + $7
    (000B219F){BMDNTCS.exe } [004B319F] Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $8
    (000FC51D){gdi32full.dll} [756ED51D] Unknown function at ftsWordBreak + $119AD
    (000EF7A0){gdi32full.dll} [756E07A0] Unknown function at ftsWordBreak + $4C30
    (000B7B70){BMDNTCS.exe } [004B8B70] Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
    (000132FC){KERNEL32.DLL} [73F342FC] Unknown function at GlobalFindAtomW + $CC
    (000B7B70){BMDNTCS.exe } [004B8B70] Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
    (000F2D7A){BMDNTCS.exe } [004F3D7A] StdCtrls.TButtonControl.WndProc (Line 4409, "StdCtrls.pas" + 13) + $6
    (000B6034){BMDNTCS.exe } [004B7034] Controls.TWinControl.Broadcast (Line 8984, "Controls.pas" + 3) + $13
    (000BA472){BMDNTCS.exe } [004BB472] Controls.TWinControl.CMDialogKey (Line 11233, "Controls.pas" + 1) + $6
    (000B219F){BMDNTCS.exe } [004B319F] Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $8
    (00189673){BMDNTCS.exe } [0058A673] Forms.TCustomForm.WndProc (Line 3961, "Forms.pas" + 191) + $6
    (000C2BE8){gdi32full.dll} [756B3BE8] Unknown function at UspFreeMem + $15C8
    (02B56B01){BMDNTCS.exe } [02F57B01] BMDLoginFrm.TBMDFRMLogin.WndProc (Line 1658, "BMDLoginFrm.pas" + 4) + $6
    (000BA456){BMDNTCS.exe } [004BB456] Controls.TWinControl.CMChildKey (Line 11227, "Controls.pas" + 1) + $15
    (000B219F){BMDNTCS.exe } [004B319F] Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $8
    (0000D48D){USER32.dll  } [753EE48D] Unknown function at MapWindowPoints + $96D
    (000288EA){USER32.dll  } [754098EA] Unknown function at GetScrollInfo + $40A
    (0000D350){USER32.dll  } [753EE350] Unknown function at MapWindowPoints + $830
    (000B7B70){BMDNTCS.exe } [004B8B70] Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
    (0003D01D){USER32.dll  } [7541E01D] Unknown function at EndTask + $765D
    (000B5F9F){BMDNTCS.exe } [004B6F9F] Controls.TWinControl.GetControl (Line 8955, "Controls.pas" + 4) + $F
    (000B6034){BMDNTCS.exe } [004B7034] Controls.TWinControl.Broadcast (Line 8984, "Controls.pas" + 3) + $13
    (000BA472){BMDNTCS.exe } [004BB472] Controls.TWinControl.CMDialogKey (Line 11233, "Controls.pas" + 1) + $6
    (000B219F){BMDNTCS.exe } [004B319F] Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $8
    (0006ADED){comctl32.dll} [73A9BDED] Unknown function at SizeBoxHwnd + $CBD
    (00042C2B){ntdll.dll   } [772A3C2B] RtlDeactivateActivationContextUnsafeFast + $9B
    (0004061E){ntdll.dll   } [772A161E] RtlActivateActivationContextUnsafeFast + $6E
    (000BA456){BMDNTCS.exe } [004BB456] Controls.TWinControl.CMChildKey (Line 11227, "Controls.pas" + 1) + $15
    (000337A1){USER32.dll  } [754147A1] Unknown function at SetManipulationInputTarget + $51
    (0000C0BC){USER32.dll  } [753ED0BC] Unknown function at DispatchMessageW + $77C
    (000058FA){win32u.dll  } [73DF68FA] NtUserSetThreadDpiAwarenessContext + $A
    (0000C350){USER32.dll  } [753ED350] Unknown function at DispatchMessageW + $A10
    (0000C0E1){USER32.dll  } [753ED0E1] Unknown function at DispatchMessageW + $7A1
    (0000C10E){USER32.dll  } [753ED10E] Unknown function at DispatchMessageW + $7CE
    (0000BF57){USER32.dll  } [753ECF57] Unknown function at DispatchMessageW + $617
    (0000C33F){USER32.dll  } [753ED33F] Unknown function at DispatchMessageW + $9FF
    (000B7B70){BMDNTCS.exe } [004B8B70] Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
    (000B5F9F){BMDNTCS.exe } [004B6F9F] Controls.TWinControl.GetControl (Line 8955, "Controls.pas" + 4) + $F
    (000B6034){BMDNTCS.exe } [004B7034] Controls.TWinControl.Broadcast (Line 8984, "Controls.pas" + 3) + $13
    (000BA472){BMDNTCS.exe } [004BB472] Controls.TWinControl.CMDialogKey (Line 11233, "Controls.pas" + 1) + $6
    (0018DFF3){BMDNTCS.exe } [0058EFF3] Forms.TCustomForm.CMDialogKey (Line 6171, "Forms.pas" + 26) + $6
    (000B219F){BMDNTCS.exe } [004B319F] Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $8
    (0002FD8B){apphelp.dll } [73CB0D8B] Unknown function at SdbGetFileImageTypeEx + $18B
    (000B7CD1){BMDNTCS.exe } [004B8CD1] Controls.TWinControl.DefaultHandler (Line 9872, "Controls.pas" + 30) + $28
    (000EEE8A){BMDNTCS.exe } [004EFE8A] StdCtrls.TCustomEdit.DefaultHandler (Line 2592, "StdCtrls.pas" + 32) + $6
    (000B219F){BMDNTCS.exe } [004B319F] Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $8
    (0000BDCA){USER32.dll  } [753ECDCA] Unknown function at DispatchMessageW + $48A
    (000161F7){USER32.dll  } [753F71F7] Unknown function at GetWindowThreadProcessId + $3D7
    (0007341A){ntdll.dll   } [772D441A] ZwCallbackReturn + $A
    (0001620B){USER32.dll  } [753F720B] Unknown function at GetWindowThreadProcessId + $3EB
    (00075664){ntdll.dll   } [772D6664] KiUserCallbackDispatcher + $34
    (000014CA){win32u.dll  } [73DF24CA] NtUserMessageCall + $A
    (0000E739){USER32.dll  } [753EF739] Unknown function at SendMessageW + $309
    (000B7B70){BMDNTCS.exe } [004B8B70] Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
    (0000E748){USER32.dll  } [753EF748] Unknown function at SendMessageW + $318
    (0018F6A4){BMDNTCS.exe } [005906A4] Forms.DispatchShortCut (Line 6863, "Forms.pas" + 3) + $3
    (00189673){BMDNTCS.exe } [0058A673] Forms.TCustomForm.WndProc (Line 3961, "Forms.pas" + 191) + $6
    (0000E56B){USER32.dll  } [753EF56B] SendMessageW + $13B
    (0000E579){USER32.dll  } [753EF579] SendMessageW + $149
    (0018F6F8){BMDNTCS.exe } [005906F8] Forms.DispatchShortCut (Line 6876, "Forms.pas" + 16) + $7
    (02B56B01){BMDNTCS.exe } [02F57B01] BMDLoginFrm.TBMDFRMLogin.WndProc (Line 1658, "BMDLoginFrm.pas" + 4) + $6
    (000B1C7A){BMDNTCS.exe } [004B2C7A] Controls.TControl.Perform (Line 6852, "Controls.pas" + 10) + $9
    (0018590B){BMDNTCS.exe } [0058690B] Forms.GetParentForm (Line 2184, "Forms.pas" + 6) + $6
    (000BAB08){BMDNTCS.exe } [004BBB08] Controls.TWinControl.CNKeyDown (Line 11497, "Controls.pas" + 23) + $53
    (015ED27F){BMDNTCS.exe } [019EE27F] BMDEdit.TBMDEdit.CNKeyDown (Line 1334, "BMDEdit.pas" + 3) + $6
    (000B219F){BMDNTCS.exe } [004B319F] Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $8
    (0000BF57){USER32.dll  } [753ECF57] Unknown function at DispatchMessageW + $617
    (0000C33F){USER32.dll  } [753ED33F] Unknown function at DispatchMessageW + $9FF
    (0000B8C2){USER32.dll  } [753EC8C2] CallWindowProcW + $92
    (0000B8CF){USER32.dll  } [753EC8CF] CallWindowProcW + $9F
    (0002FD83){apphelp.dll } [73CB0D83] Unknown function at SdbGetFileImageTypeEx + $183
    (0002FD8B){apphelp.dll } [73CB0D8B] Unknown function at SdbGetFileImageTypeEx + $18B
    (000B7CD1){BMDNTCS.exe } [004B8CD1] Controls.TWinControl.DefaultHandler (Line 9872, "Controls.pas" + 30) + $28
    (0001DE6F){MSCTF.dll   } [747BEE6F]
    (00021082){MSCTF.dll   } [747C2082]
    (00021095){MSCTF.dll   } [747C2095]
    (001858CD){BMDNTCS.exe } [005868CD] Forms.GetRealParentForm (Line 2171, "Forms.pas" + 3) + $9
    (000B7B70){BMDNTCS.exe } [004B8B70] Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
    (000B7753){BMDNTCS.exe } [004B8753] Controls.TWinControl.WndProc (Line 9711, "Controls.pas" + 24) + $6
    (000068BA){BMDNTCS.exe } [004078BA] System.TMonitor.TryEnter + $26
    (000064B8){BMDNTCS.exe } [004074B8] System.TMonitor.Enter + $10
    (0000638C){BMDNTCS.exe } [0040738C] System.TMonitor.CheckOwningThread + $4
    (00006662){BMDNTCS.exe } [00407662] System.TMonitor.Exit + $22
    (0000669B){BMDNTCS.exe } [0040769B] System.TMonitor.Exit + $F
    (00092C61){BMDNTCS.exe } [00493C61] Graphics.FreeMemoryContexts (Line 7021, "Graphics.pas" + 12) + $E
    (000B710C){BMDNTCS.exe } [004B810C] Controls.TWinControl.MainWndProc (Line 9552, "Controls.pas" + 3) + $9
    (00065B00){BMDNTCS.exe } [00466B00] Classes.StdWndProc + $14
    (000337A1){USER32.dll  } [754147A1] Unknown function at SetManipulationInputTarget + $51
    (0000C0BC){USER32.dll  } [753ED0BC] Unknown function at DispatchMessageW + $77C
    (0001EDCF){MSCTF.dll   } [747BFDCF]
    (000250EE){MSCTF.dll   } [747C60EE] Unknown function at TF_Notify + $FCE
    (00024F36){MSCTF.dll   } [747C5F36] Unknown function at TF_Notify + $E16
    (000184C6){USER32.dll  } [753F94C6] GetKeyboardLayout + $16
    (000248DA){MSCTF.dll   } [747C58DA] Unknown function at TF_Notify + $7BA
    (0000BF57){USER32.dll  } [753ECF57] Unknown function at DispatchMessageW + $617
    (0000BDCA){USER32.dll  } [753ECDCA] Unknown function at DispatchMessageW + $48A
    (000161F7){USER32.dll  } [753F71F7] Unknown function at GetWindowThreadProcessId + $3D7
    (00075664){ntdll.dll   } [772D6664] KiUserCallbackDispatcher + $34
    (000014CA){win32u.dll  } [73DF24CA] NtUserMessageCall + $A
    (0000E739){USER32.dll  } [753EF739] Unknown function at SendMessageW + $309
    (0007350A){ntdll.dll   } [772D450A] ZwFindAtom + $A
    (00013319){KERNEL32.DLL} [73F34319] Unknown function at GlobalFindAtomW + $E9
    (0000E56B){USER32.dll  } [753EF56B] SendMessageW + $13B
    (000AB31C){BMDNTCS.exe } [004AC31C] Controls.FindControl (Line 3378, "Controls.pas" + 6) + $C
    (001945BF){BMDNTCS.exe } [005955BF] Forms.TApplication.IsKeyMsg (Line 9668, "Forms.pas" + 25) + $1E
    (0019493C){BMDNTCS.exe } [0059593C] Forms.TApplication.ProcessMessage (Line 9754, "Forms.pas" + 17) + $39
    (001949B7){BMDNTCS.exe } [005959B7] Forms.TApplication.HandleMessage (Line 9790, "Forms.pas" + 1) + $6
    (0018F05D){BMDNTCS.exe } [0059005D] Forms.TCustomForm.ShowModal (Line 6648, "Forms.pas" + 33) + $5
    (02B04942){BMDNTCS.exe } [02F05942] BMDForm.TBMDForm.ShowModal (Line 1422, "BMDForm.pas" + 19) + $3
    (02B54573){BMDNTCS.exe } [02F55573] BMDLoginFrm.TBMDFRMLogin.ShowModal (Line 971, "BMDLoginFrm.pas" + 54) + $3
    (02B51F00){BMDNTCS.exe } [02F52F00] BMDLoginFrm.DoDatabaseLogin (Line 458, "BMDLoginFrm.pas" + 24) + $5
    (02B573E7){BMDNTCS.exe } [02F583E7] BMDNTCSMainSession.TBMDNTCSMainSession.DoDatabaseLogin (Line 152, "BMDNTCSMainSession.pas" + 5) + $39
    (111BD9B1){BMDNTCS.exe } [115BE9B1] BMDNTCSDPR.RunBMDNTCS (Line 129, "BMDNTCSDPR.pas" + 4) + $23
    (111C1CEB){BMDNTCS.exe } [115C2CEB] BMDNTCSDPR.RunBMD (Line 841, "BMDNTCSDPR.pas" + 28) + $0
    (113492AB){BMDNTCS.exe } [1174A2AB] BMDNTCS.BMDNTCS (Line 26, "" + 6) + $0
    (00014CF2){KERNEL32.DLL} [73F35CF2] BaseThreadInitThunk + $22
    (00066F57){ntdll.dll   } [772C7F57] Unknown function at RtlMakeSelfRelativeSD + $277
    (00066F1F){ntdll.dll   } [772C7F1F] Unknown function at RtlMakeSelfRelativeSD + $23F




    Monday, May 9, 2016 11:57 AM

All replies

  • Hi,

    Please provide more information about your deployment:
    1. Both SQL and RDS are installed on one WS 2016 TP5?
    2. What is the SQL version?
    3. What is the “Application” you mentioned? 

    Please provide the deployment reference link/document if possible(any). And, I will try to reproduce this problem if possible and check the result.

    Before that, I recommend you to reference - Steps to troubleshoot SQL connectivity issues – and try to narrow down this problem:
    https://blogs.msdn.microsoft.com/sql_protocols/2008/04/30/steps-to-troubleshoot-sql-connectivity-issues/

    Best Regards,
    Eve Wang

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Tuesday, May 10, 2016 8:04 AM
  • Hi,

    SQL Server OS is Windows Server 2008 with SQL Server 2008

    RDS Broker + Gateway = WS 2016 TP5
    RDS Session Hosts = 2x WS 2016 TP5

    The Applications are BMD NTCS and MehrData mds Faktura

    http://www.bmd.com/ueber-bmd/business-software/bmd-ntcs.html

    Both Software stuck already in the beginning because they cannot Connect to SQL Server

    One of the 2 Applications also need a OBDC Entry. But the software says odbc entry "FAKTURA1" cannot be found.

    As i said if i remove the RDS Session Host role from the RDS Session Host, then everything works as expected, i can use both applications and also the SQL Connect works!

    We have the same configuration running on WS 2012R2 (1x Broker + GW / 3x RDS Session Host)

    Here everything works well. This configuration connects to the same SQL Server.

    Some Pictures of Settings and errors...

    

    Tuesday, May 10, 2016 1:32 PM