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