none
DPM 2012 - SQL 2008R2 - error 964 RRS feed

  • Question

  • I am new to this forum but i am getting this error with one of my 2008 R2 databases using DPM2012sp1.

    DPM could not enumerate application component TGPROSQL01\PROZONE\master on protected computer tgprosql01.saintsfc.co.uk. (ID: 964)

    Please make sure that writer is in good state.

    I have checked the vss state and all looks fine

    PS C:\Windows\system32> vssadmin list writers
    vssadmin 1.1 - Volume Shadow Copy Service administrative command-line t
    (C) Copyright 2001-2005 Microsoft Corp.

    Writer name: 'Task Scheduler Writer'
       Writer Id: {d61d61c8-d73a-4eee-8cdd-f6f9786b7124}
       Writer Instance Id: {1bddd48e-5052-49db-9b07-b96f96727e6b}
       State: [1] Stable
       Last error: No error

    Writer name: 'VSS Metadata Store Writer'
       Writer Id: {75dfb225-e2e4-4d39-9ac9-ffaff65ddf06}
       Writer Instance Id: {088e7a7d-09a8-4cc6-a609-ad90e75ddc93}
       State: [1] Stable
       Last error: No error

    Writer name: 'Performance Counters Writer'
       Writer Id: {0bada1de-01a9-4625-8278-69e735f39dd2}
       Writer Instance Id: {f0086dda-9efc-47c5-8eb6-a944c3d09381}
       State: [1] Stable
       Last error: No error

    Writer name: 'System Writer'
       Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}
       Writer Instance Id: {dc29d415-b4a1-4a4b-8cff-1e23e4a724d7}
       State: [1] Stable
       Last error: No error

    Writer name: 'SqlServerWriter'
       Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
       Writer Instance Id: {b168eaaa-9233-49a7-9163-404cd0c5fd8e}
       State: [1] Stable
       Last error: No error

    Writer name: 'ASR Writer'
       Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}
       Writer Instance Id: {a34a86ae-904f-4e4b-83fc-3af465549a95}
       State: [1] Stable
       Last error: No error

    Writer name: 'WMI Writer'
       Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}
       Writer Instance Id: {39c7216a-b0a7-47f9-b1a8-c81934e0152d}
       State: [1] Stable
       Last error: No error

    Writer name: 'COM+ REGDB Writer'
       Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}
       Writer Instance Id: {fc4dfb96-42ac-428e-9ed3-f99b284e69d6}
       State: [1] Stable
       Last error: No error

    Writer name: 'Registry Writer'
       Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}
       Writer Instance Id: {4eacb542-1909-4f4d-b317-eb769acd2460}
       State: [1] Stable
       Last error: No error

    Writer name: 'Shadow Copy Optimization Writer'
       Writer Id: {4dc3bdd4-ab48-4d07-adb0-3bee2926fd7f}
       Writer Instance Id: {b217f079-d39e-433c-a916-93f3de76a19f}
       State: [1] Stable
       Last error: No error

    Sunday, February 17, 2013 1:14 PM

Answers

All replies

  • Hi,

    From an administrative command prompt, Please run:

    C:\>Diskshadow.exe /l c:\writers.txt <enter>
    DISKSHADOW> List Writers  <enter>
    DISKSHADOW> Exit <enter>

    C:\>Notepad c:\writers.txt

    Search for SqlServerWriter and check if the databases are listed including master and the Paths to the files are correct.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, February 19, 2013 11:38 PM
    Moderator
  • All seems ok, could it be permissions on the folder structure on the E: drive?   What users does DPM try to access the files as?

    ----_DUMP-----

    * WRITER "SqlServerWriter"
    - Writer ID   = {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
    - Writer instance ID = {b168eaaa-9233-49a7-9163-404cd0c5fd8e}
    - Supports restore events = TRUE
    - Writer restore conditions = VSS_WRE_ALWAYS
    - Restore method = VSS_RME_RESTORE_IF_CAN_REPLACE
    - Requires reboot after restore = FALSE
    - Excluded files:
    + Component "SqlServerWriter:\TGPROSQL01\PROZONE\master"
    - Name: master
    - Logical path: TGPROSQL01\PROZONE
    - Full path: \TGPROSQL01\PROZONE\master
    - Caption: 
    - Type: VSS_CT_FILEGROUP [2]
    - Is selectable: TRUE
    - Is top level: TRUE
    - Notify on backup complete: TRUE
    - Paths affected by this component:
    - E:\Program Files\Microsoft SQL Server\MSSQL10_50.PROZONE\MSSQL\DATA
    - Volumes affected by this component:
    - \\?\Volume{4726fa88-dc77-11e1-95e5-00155d680108}\ [E:\]
    - Component Dependencies:
    + Component "SqlServerWriter:\TGPROSQL01\PROZONE\model"
    - Name: model
    - Logical path: TGPROSQL01\PROZONE
    - Full path: \TGPROSQL01\PROZONE\model
    - Caption: 
    - Type: VSS_CT_FILEGROUP [2]
    - Is selectable: TRUE
    - Is top level: TRUE
    - Notify on backup complete: TRUE
    - Paths affected by this component:
    - E:\Program Files\Microsoft SQL Server\MSSQL10_50.PROZONE\MSSQL\DATA
    - Volumes affected by this component:
    - \\?\Volume{4726fa88-dc77-11e1-95e5-00155d680108}\ [E:\]
    - Component Dependencies:
    + Component "SqlServerWriter:\TGPROSQL01\PROZONE\msdb"
    - Name: msdb
    - Logical path: TGPROSQL01\PROZONE
    - Full path: \TGPROSQL01\PROZONE\msdb
    - Caption: 
    - Type: VSS_CT_FILEGROUP [2]
    - Is selectable: TRUE
    - Is top level: TRUE
    - Notify on backup complete: TRUE
    - Paths affected by this component:
    - E:\Program Files\Microsoft SQL Server\MSSQL10_50.PROZONE\MSSQL\DATA
    - Volumes affected by this component:
    - \\?\Volume{4726fa88-dc77-11e1-95e5-00155d680108}\ [E:\]
    - Component Dependencies:
    + Component "SqlServerWriter:\TGPROSQL01\PROZONE\Trend_Soton_1112"
    - Name: Trend_Soton_1112
    - Logical path: TGPROSQL01\PROZONE
    - Full path: \TGPROSQL01\PROZONE\Trend_Soton_1112
    - Caption: 
    - Type: VSS_CT_FILEGROUP [2]
    - Is selectable: TRUE
    - Is top level: TRUE
    - Notify on backup complete: TRUE
    - Paths affected by this component:
    - E:\ProZone Data\Soton
    - Volumes affected by this component:
    - \\?\Volume{4726fa88-dc77-11e1-95e5-00155d680108}\ [E:\]
    - Component Dependencies:
    + Component "SqlServerWriter:\TGPROSQL01\PROZONE\Trend_Soton_1213"
    - Name: Trend_Soton_1213
    - Logical path: TGPROSQL01\PROZONE
    - Full path: \TGPROSQL01\PROZONE\Trend_Soton_1213
    - Caption: 
    - Type: VSS_CT_FILEGROUP [2]
    - Is selectable: TRUE
    - Is top level: TRUE
    - Notify on backup complete: TRUE
    - Paths affected by this component:
    - C:\Program Files (x86)\Prozone\Trend\Data
    - Volumes affected by this component:
    - \\?\Volume{f9af3568-dc1b-11e1-9a4a-806e6f6e6963}\ [C:\]
    - Component Dependencies:

    Thursday, February 21, 2013 9:51 AM
  • Hi,

    DPM agent (DPMRA) runs in System account context.  Please check to be sure SYSTEM account has access to the root of E: and also the folders containing the DB's. 


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, February 21, 2013 3:10 PM
    Moderator
  • Hi Mike

    Still no joy.  The SYSTEM account has FULL CONTROL to all SQL related directories 

    e:

    e:\Program Files (SQL DB Instance)

    e:\ProZone (SQL Database)

    c:\ Program Files (SQL install)

    Any tips would be great.

    Matthew

    Monday, February 25, 2013 3:52 PM
  • Hi,

    Could be Kerberos, or SPN problems.  You will need to look in the msdpmcurr.errlog and DPMRACurr.errlog on the DPM server and DPMRACurr.errlog on the SQL server right after you get the error to see why we're failing.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Monday, February 25, 2013 6:44 PM
    Moderator
  • a bit of a delay in replying - no time !!!

    Seems there are a fair few items from the local SQL server (STPROSQL01), around neapplicationnamespace.cpp and sqlqueryhelper.cpp, dump below

    0648 0C28 03/21 18:10:52.806 03 sqlqueryhelper.cpp(190) 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 0C28 03/21 18:10:52.806 03 sqlqueryhelper.cpp(109) 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : hr
    0648 0C28 03/21 18:10:52.806 61 neapplicationnamespace.cpp(2253) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : m_sqlQueryHelper.Initialize(ssLogicalPath, L"master")
    0648 0C28 03/21 18:10:52.806 61 neapplicationnamespace.cpp(2269) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (const_cast<CNESQLNamespace*>(this))->InitializeSQLQueryHelper(componentBuf.ssLogicalPath)
    0648 0C28 03/21 18:10:52.806 61 neapplicationnamespace.cpp(2504) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : GetApplicationVersion(*componentBuf)
    0648 0C28 03/21 18:10:52.806 61 neapplicationnamespace.cpp(2728) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : IsDenali(componentBuf, bIsDenali)
    0648 0C28 03/21 18:10:52.806 61 neapplicationnamespace.cpp(1438) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : GetClusterStatus(&componentBuf)
    0648 0C28 03/21 18:10:52.806 61 neapplicationnamespace.cpp(896) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : GetDatasourceCapabilities(componentBuf)
    0648 0C28 03/21 18:10:52.806 61 neapplicationnamespace.cpp(620) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : hr
    0648 0924 03/21 18:11:08.775 03 sqlqueryhelper.cpp(189) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:11:08.775 03 sqlqueryhelper.cpp(332) [0000000000325C48] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:11:08.775 03 sqlqueryhelper.cpp(345) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:11:08.775 03 sqlqueryhelper.cpp(353) [0000000000325C48] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:11:26.369 03 sqlqueryhelper.cpp(189) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:11:26.369 03 sqlqueryhelper.cpp(332) [0000000000325C48] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:11:26.369 03 sqlqueryhelper.cpp(345) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:11:26.369 03 sqlqueryhelper.cpp(353) [0000000000325C48] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:11:26.369 03 sqlqueryhelper.cpp(190) WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 0924 03/21 18:11:44.994 03 sqlqueryhelper.cpp(189) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:11:44.994 03 sqlqueryhelper.cpp(332) [0000000000325C48] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:11:44.994 03 sqlqueryhelper.cpp(345) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:11:44.994 03 sqlqueryhelper.cpp(353) [0000000000325C48] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:11:44.994 03 sqlqueryhelper.cpp(190) WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 0924 03/21 18:12:02.540 03 sqlqueryhelper.cpp(189) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:12:02.540 03 sqlqueryhelper.cpp(332) [0000000000325C48] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:12:02.540 03 sqlqueryhelper.cpp(345) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:12:02.540 03 sqlqueryhelper.cpp(353) [0000000000325C48] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:12:02.540 03 sqlqueryhelper.cpp(190) WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 0924 03/21 18:12:21.103 03 sqlqueryhelper.cpp(189) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:12:21.103 03 sqlqueryhelper.cpp(332) [0000000000325C48] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:12:21.103 03 sqlqueryhelper.cpp(345) [0000000000325C48] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:12:21.103 03 sqlqueryhelper.cpp(353) [0000000000325C48] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:12:21.103 03 sqlqueryhelper.cpp(190) WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 0924 03/21 18:12:21.103 03 sqlqueryhelper.cpp(108) [0000000000325C48] WARNING Failed: Hr: = [0x80990f75] Unable to connect to SQL Instance : [TGPROSQL01\PROZONE] and Database : [master] after [5] retry attempts
    0648 0924 03/21 18:12:21.103 61 neapplicationnamespace.cpp(619) [0000000000325B00] WARNING Failed: Hr: = [0x80990f75] GetComponentInfo failed for component [Trend_Soton_1213]
    0648 0924 03/21 18:12:21.103 61 neapplicationnamespace.cpp(558) [0000000000325B00] WARNING Failed: Hr: = [0x80990f75] CNEApplicationNamespace::EnumerateChildren:Process Component failure
    0648 0924 03/21 18:12:21.103 61 neapplicationnamespace.cpp(498) [0000000000325B00] NORMAL <--CNEApplicationNamespace::EnumerateChildren
    0648 0924 03/21 18:12:21.103 61 neapplicationnamespace.cpp(1888) [0000000000325B00] NORMAL ==>CNESQLNamespace::EnumerateMirrorDatabases
    0648 0924 03/21 18:12:21.181 03 wmiqueryhelper.cpp(92) [0000000003B2E8D8] WARNING Failed: Hr: = [0x8004100e] : unable to connect to the wmi namespace: root\Microsoft\SqlServer\ComputerManagement
    0648 09BC 03/21 18:12:21.509 61 inquirysubtask.cpp(467) [000000000031B890] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 NORMAL Sending response with 1 records of 1 total
    0648 09BC 03/21 18:12:21.571 03 sqlqueryhelper.cpp(190) 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 09BC 03/21 18:12:21.571 03 sqlqueryhelper.cpp(109) 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : hr
    0648 09BC 03/21 18:12:21.571 61 neapplicationnamespace.cpp(2253) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : m_sqlQueryHelper.Initialize(ssLogicalPath, L"master")
    0648 09BC 03/21 18:12:21.571 61 neapplicationnamespace.cpp(2269) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (const_cast<CNESQLNamespace*>(this))->InitializeSQLQueryHelper(componentBuf.ssLogicalPath)
    0648 09BC 03/21 18:12:21.571 61 neapplicationnamespace.cpp(2504) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : GetApplicationVersion(*componentBuf)
    0648 09BC 03/21 18:12:21.571 61 neapplicationnamespace.cpp(2728) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : IsDenali(componentBuf, bIsDenali)
    0648 09BC 03/21 18:12:21.571 61 neapplicationnamespace.cpp(1438) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : GetClusterStatus(&componentBuf)
    0648 09BC 03/21 18:12:21.571 61 neapplicationnamespace.cpp(896) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : GetDatasourceCapabilities(componentBuf)
    0648 09BC 03/21 18:12:21.571 61 neapplicationnamespace.cpp(620) [0000000000325B00] 02F6137F-36DD-41B0-A0CC-5F1135C6FC85 WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : hr
    0648 0924 03/21 18:12:38.087 03 sqlqueryhelper.cpp(189) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:12:38.087 03 sqlqueryhelper.cpp(332) [0000000003B2F150] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:12:38.087 03 sqlqueryhelper.cpp(345) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:12:38.087 03 sqlqueryhelper.cpp(353) [0000000003B2F150] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:12:55.650 03 sqlqueryhelper.cpp(189) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:12:55.650 03 sqlqueryhelper.cpp(332) [0000000003B2F150] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:12:55.650 03 sqlqueryhelper.cpp(345) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:12:55.650 03 sqlqueryhelper.cpp(353) [0000000003B2F150] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:12:55.650 03 sqlqueryhelper.cpp(190) WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 0924 03/21 18:13:13.197 03 sqlqueryhelper.cpp(189) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:13:13.197 03 sqlqueryhelper.cpp(332) [0000000003B2F150] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:13:13.197 03 sqlqueryhelper.cpp(345) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:13:13.197 03 sqlqueryhelper.cpp(353) [0000000003B2F150] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:13:13.197 03 sqlqueryhelper.cpp(190) WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 0924 03/21 18:13:31.775 03 sqlqueryhelper.cpp(189) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:13:31.775 03 sqlqueryhelper.cpp(332) [0000000003B2F150] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:13:31.775 03 sqlqueryhelper.cpp(345) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:13:31.775 03 sqlqueryhelper.cpp(353) [0000000003B2F150] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:13:31.775 03 sqlqueryhelper.cpp(190) WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 0924 03/21 18:13:49.369 03 sqlqueryhelper.cpp(189) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL Instance - [TGPROSQL01\PROZONE] refusing connection
    0648 0924 03/21 18:13:49.369 03 sqlqueryhelper.cpp(332) [0000000003B2F150] WARNING SQL - Error Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:13:49.369 03 sqlqueryhelper.cpp(345) [0000000003B2F150] WARNING Failed: Hr: = [0x80004005] SQL - sql code = 18 (Errorlevel - 0)
    0648 0924 03/21 18:13:49.369 03 sqlqueryhelper.cpp(353) [0000000003B2F150] WARNING SQL - Detailed Description "[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."
    0648 0924 03/21 18:13:49.369 03 sqlqueryhelper.cpp(190) WARNING Failed: Hr: = [0x80990f75] : Encountered Failure: : lVal : (HRESULT)0x80990F75
    0648 0924 03/21 18:13:49.369 03 sqlqueryhelper.cpp(108) [0000000003B2F150] WARNING Failed: Hr: = [0x80990f75] Unable to connect to SQL Instance : [TGPROSQL01\PROZONE] and Database : [master] after [5] retry attempts

    Thursday, March 21, 2013 7:52 PM
  • Hi,

    It seems sysadmin permissions were taken away from System account.

    1. On he protected SQL Server verify the DPMRA service is running under Local System (which is the default).
    2.Connect to the SQL 2008 instance with the help of SQL Management Studio >> select and expand Security >> select and expand Logins >> right  click on the NT AUTHORITY\SYSTEM and select Properties >> click on Serverroles >> check the sysadmin checkbox >> click OK

    Now trigger a recovery point or IR and it should succeed.

    NOTE: Instead of adding NT AUTHORITY\SYSTEM as sysadmin, you can add NT SERVICE\DPMRA to sysadmin instead. 


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    • Proposed as answer by neilneo Friday, December 2, 2016 8:57 AM
    Thursday, March 21, 2013 8:24 PM
    Moderator
  • I am going to try this now, thanks for the quick response and advise so far.  will send update soon

    Matthew

    Thursday, March 21, 2013 8:31 PM
  • How frustrating, i agree that is is permissions but can see where.  SYSADMIN is correctly set for NT AUTH/SYSTEM and local system is running the services.

    is there a way to reset permissions from the SQL install, like detect and repair?

    Thursday, March 21, 2013 9:01 PM
  • Hmm, that is very odd, that is the only known cause for that error, but this may be associated with SSL Security - and unfortunately am not well versed in SQL security.

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, March 21, 2013 9:58 PM
    Moderator
  • running a repair got this

    TITLE: SQL Server 2008 R2 Setup
    ------------------------------

    The following error has occurred:

    A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

    Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.2500.0&EvtType=0xBA6E21AA%25400x9A41B222

    ------------------------------
    BUTTONS:

    &Retry
    Cancel
    ------------------------------

    Thursday, March 21, 2013 9:59 PM
  • getting somewhere, deleted the NT AUTH/SYStem from sql then re added it

    03/21/2013 22:20:35,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
    03/21/2013 22:20:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.

    Thursday, March 21, 2013 10:29 PM
  • erm, rebuilt the server with 2012, all sorted !
    • Edited by Catch.22 Thursday, May 9, 2013 8:39 PM
    • Marked as answer by Catch.22 Thursday, May 9, 2013 8:39 PM
    Thursday, May 9, 2013 8:39 PM