MP and PXE not connecting to DB
Hey , I seem to have really strange issue. For q quite while now one of my secondary sites is experiencing problems connecting to primary site DB. The secondary site is configured with Proxy MP and PXE. All those have been working without problems ... up till now :( Strange thing is it is only one of many secondary sites experiencing issues.... Database has service account with full permission granted. Both MP and PXE are configured to use that account while connecting to DB Secondary site server is in primary local administrators and in appropiate SiteSystems local group (confirmed many times ;) ) on primary SQL SPNs are configured Service account is not locked out etc TCP and named pipes are enabled on SQL There is no firewall issues between secondary and primary sites I have run SQL profiler to see are there any login failures - what a suprise :O none And this is what I'm getting in smspxe.log CMPDBConnection::ExecuteSQL(): ICommandText::Execute() failed with 0x80004005 SmsPXE 9/27/2011 9:15:08 PM 9080 (0x2378) ======================================= SmsPXE 9/27/2011 9:15:08 PM 9080 (0x2378) MPDB ERROR - CONNECTION PARAMETERS SQL Server Name : PrimarySCCMServer SQL Database Name : SMS_ABC Integrated Auth : True MPDB ERROR - EXTENDED INFORMATION MPDB Method : ExecuteSP() MPDB Method HRESULT : 0x80004005 Error Description : [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. OLEDB IID : {0C733A63-2A1C-11CE-ADE5-00AA0044773D} ProgID : Microsoft OLE DB Provider for SQL Server MPDB ERROR - INFORMATION FROM DRIVER Native Error no. : 11 Error State : 1 Class (Severity) : 16 SmsPXE 9/27/2011 9:15:08 PM 9080 (0x2378) ======================================= SmsPXE 9/27/2011 9:15:08 PM 9080 (0x2378) MP: RaiseDBFailureStatusMessage failed to open registry 2 SmsPXE 9/27/2011 9:15:08 PM 9080 (0x2378) Failed to read PXE DB settings. Unspecified error (Error: 80004005; Source: Windows) smspxe 9/27/2011 9:15:08 PM 9080 (0x2378) PXE Provider failed to process message. Unspecified error (Error: 80004005; Source: Windows) smspxe 9/27/2011 9:15:08 PM 9080 (0x2378) This is what Im getting in MP_location.log and MP_GetAUth SMS MP Location Manager started. MP_LocationManager 9/27/2011 8:47:31 PM 7908 (0x1EE4) CMPDBConnection::ExecuteSQL(): ICommandText::Execute() failed with 0x80004005 MP_LocationManager 9/27/2011 8:58:20 PM 7908 (0x1EE4) ======================================= MP_LocationManager 9/27/2011 8:58:20 PM 7908 (0x1EE4) MPDB ERROR - CONNECTION PARAMETERS SQL Server Name : PrimarySCCMServer SQL Database Name : SMS_ABC Integrated Auth : True MPDB ERROR - EXTENDED INFORMATION MPDB Method : ExecuteSP() MPDB Method HRESULT : 0x80004005 Error Description : [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. OLEDB IID : {0C733A63-2A1C-11CE-ADE5-00AA0044773D} ProgID : Microsoft OLE DB Provider for SQL Server MPDB ERROR - INFORMATION FROM DRIVER Native Error no. : 11 Error State : 1 Class (Severity) : 16 MP_LocationManager 9/27/2011 8:58:20 PM 7908 (0x1EE4) ======================================= MP_LocationManager 9/27/2011 8:58:20 PM 7908 (0x1EE4) CHandleLocationRequest::CreateReply failed with error (80004005). MP_LocationManager 9/27/2011 8:58:20 PM 7908 (0x1EE4) MP LM: Message discarded MP_LocationManager 9/27/2011 8:58:20 PM 7908 (0x1EE4) However the MPControl.log says Successfully performed Management Point availability check against local computer. SMS_MP_CONTROL_MANAGER 9/27/2011 9:19:25 PM 8732 (0x221C) Call to HttpSendRequestSync succeeded for port 80 with status code 200, text: OK SMS_MP_CONTROL_MANAGER 9/27/2011 9:24:25 PM 8732 (0x221C) Http test request succeeded. SMS_MP_CONTROL_MANAGER 9/27/2011 9:24:25 PM 8732 (0x221C) Your Ideas what can be wrong here are much welcome Blog at http://www.rpieniaz.wordpress.com
September 27th, 2011 11:33pm

Why MP and PXE use service account to connect to DB? Why dont't you use system account? Also, you can try to check the remote connectvity ? http://blogs.msdn.com/b/steverac/archive/2010/12/14/test-remote-sql-connectivity-easily.aspxAnoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2011 4:29am

MPDB Method HRESULT : 0x80004005 Error Description : [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. 1# Check that there is no network connection problem, use the Anoop's link 2# Check that the SynAttackProtect flag is not activated http://technet.microsoft.com/en-us/library/cc938202.aspx 3# Look at this link, it might help you http://www.myitforum.com/absolutenm/templates/Articles.aspx?articleid=19045&zoneid=89Bechir Gharbi | http://myitforum.com/cs2/blogs/bgharbi/ | Time zone : GMT+1
September 28th, 2011 9:25am

Hey This is what I did : I removed the PXE point and MP from site roles I made sure the role is removed (PXESetup.log) and re added them using default security settings Installation went OK and then I got the following in SMSPXE.log CMPDBConnection::ExecuteSQL(): ICommandText::Execute() failed with 0x80040E09 SmsPXE 9/28/2011 8:38:27 AM 6784 (0x1A80) ======================================= SmsPXE 9/28/2011 8:38:27 AM 6784 (0x1A80) MPDB ERROR - CONNECTION PARAMETERS SQL Server Name : PrimarySCCMServer SQL Database Name : SMS_ABC Integrated Auth : True MPDB ERROR - EXTENDED INFORMATION MPDB Method : ExecuteSP() MPDB Method HRESULT : 0x80040E09 Error Description : The EXECUTE permission was denied on the object 'PXE_GetPXECert', database 'SMS_ABC', schema 'dbo'. OLEDB IID : {0C733A63-2A1C-11CE-ADE5-00AA0044773D} ProgID : Microsoft OLE DB Provider for SQL Server MPDB ERROR - INFORMATION FROM DRIVER SQL Server Name : PrimarySCCMServer Stored Procedure : PXE_GetPXECert Native Error no. : 229 Error State : 5 Class (Severity) : 14 Line number in SP : 1 SmsPXE 9/28/2011 8:38:27 AM 6784 (0x1A80) ======================================= SmsPXE 9/28/2011 8:38:27 AM 6784 (0x1A80) MP: RaiseDBFailureStatusMessage failed to open registry 2 SmsPXE 9/28/2011 8:38:27 AM 6784 (0x1A80) Failed to read PXE DB settings. Unknown error (Error: 80040E09; Source: Unknown) smspxe 9/28/2011 8:38:27 AM 6784 (0x1A80) Failed to initialize PXE Provider. Unknown error (Error: 80040E09; Source: Unknown) smspxe 9/28/2011 8:38:27 AM 6784 (0x1A80) Failed to initialize PXE provider. Unknown error (Error: 80040E09; Source: Unknown) smspxe 9/28/2011 8:38:27 AM 6784 (0x1A80) I went to DB security settings and computer account for site server had SMSDBROLE_PSP I added DBowner role and then it started to work. If I'm correct this is something which I should not be doing and Im wondering what is not OK :( Any ideas ? Blog at http://www.rpieniaz.wordpress.com
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2011 11:18am

The error "80040E09" translates to DB_SEC_E_PERMISSIONDENIED = Permission denied.Anoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.
September 28th, 2011 11:24am

An00p Exactly , However what wonders me is why does it happen if the server account did get the SMSDBROLE_PSP :O ? IT should not be a situation (at least I think) that I need to manually modify permissions for site server in DB :/ Blog at http://www.rpieniaz.wordpress.com
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2011 11:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics