We got some SCCM Connection errors like below. It happened when sccm pushes packages out but they fail with Failed bad environment. Any ideas, thanks.

 

=======================================
 MP_PolicyManager 9/15/2010 7:06:54 PM 8812 (0x226C)
CPolicyManagerHandler::HandleMessage(): SetComplete(DISCARD) called. MP_PolicyManager 9/15/2010 7:06:54 PM 8812 (0x226C)
CMPDBConnection::Init(): IDBInitialize::Initialize() failed with 0x80004005 MP_PolicyManager 9/15/2010 7:06:54 PM 8812 (0x226C)
======================================= MP_PolicyManager 9/15/2010 7:06:54 PM 8812 (0x226C)

MPDB ERROR - CONNECTION PARAMETERS
SQL Server Name     : SQLServer1
SQL Database Name   : SCCM_ABC
Integrated Auth     : True

MPDB ERROR - EXTENDED INFORMATION
MPDB Method         : Init()
MPDB Method HRESULT : 0x80004005
Error Description   : Cannot open database "SCCM_ABC" requested by the login. The login failed.
OLEDB IID           : {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}
ProgID              : Microsoft OLE DB Provider for SQL Server

MPDB ERROR - INFORMATION FROM DRIVER
SQL Server Name   : SQLSERVER1
Native Error no.  : 4060
Error State       : 1
Class (Severity)  : 11
Line number in SP : 1
 MP_PolicyManager 9/15/2010 7:06:54 PM 8812 (0x226C)

What do SQL server logs tell you? Any failed logins? Which details? Is SQL on a separate box? Is it always failing or just sometimes?

Hi,

For this MP error, could you please browse through MP URL from Client machines Url to check MP is working or not:

http://smsservername/sms_mp/.sms_aut?mplist - if page display MP list, MP is working fine.

http://smsservername/sms_mp/.sms_aut?mpcert - if a longstring appears, MP is working fine.

Did you use a remote database or a local database for you primary site?

Make sure you added your SCCM  site server computer account to Local sql connection group.

Hi,

URL for MP check is working fine, even mpcontrol log is showing status code 200. Still getting the same error as the subject of this threat. yes there is the computer account in Primary SQL server and able to login with correct account with all permissions.....rebooted server and services   number of times but no success.

Rgds

Rajiv