Hi,

I am working on SCCM 2007 SP1 with remote SQL 2005 server. It was functional properly since yesterday till I have installed reporting role. After that I lost connectivity between site server and SQL server. Later on I lost all snap-in from SCCM MMC and right now all the SQL services are On and I can access Site server from SQL server visa versa but there is no snap-in in MMC.

To resolve the issue I tried..

1/ done disk clean up from File-> option -> delete files.

2/ rename the adminconsole in C:\Documents and Settings\user\Application Data\Microsoft\MMC

3/ Remove the site from MMC and try to reconnect. Now it wont allow me to reconnect the Site

Does anyone has any remedy to connect the site with database and get the snap in back.

I am getting below errors in event viewer

Site Server:

Event Type: Error

Event Source: SMS Server

Event Category: SMS_WSUS_SYNC_MANAGER

Event ID: 6700

Date: 9/11/2009

Time: 10:24:09 AM

User: N/A

Computer: <Site Server host>

Description:

On 9/11/2009 10:24:09 AM, component SMS_WSUS_SYNC_MANAGER on computer <Siter Server> reported: SMS WSUS Sync Manager error.

Message: Failed to connect to site source. CSiteSource error: 2.

Source: CWSyncMgr::ProcessSiteNotifications.

The operating system reported error 2147500037: Unspecified error

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

SQL Server:

Event Type: Failure Audit

Event Source: MSSQLSERVER

Event Category: (4)

Event ID: 18456

Date: 9/11/2009

Time: 12:10:43 PM

User: NT AUTHORITY\ANONYMOUS LOGON

Computer: <SQL serverHost>

Description:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 10.x.x.x]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 18 48 00 00 0e 00 00 00 .H......

0008: 0b 00 00 00 42 00 41 00 ....B.A.

0010: 54 00 4f 00 52 00 53 00 T.O.R.S.

0018: 51 00 4c 00 30 00 31 00 Q.L.0.1.

0020: 00 00 07 00 00 00 6d 00 ......m.

0028: 61 00 73 00 74 00 65 00 a.s.t.e.

0030: 72 00 00 00 r...

Any help will be appriciated.

Check out the SQL server status....

If the backend SQL server is not started Configuration Manager console will through you an error, resolve any problems related to SQL.

Use SQL Server Management STudio Express to connect SQL server.

User: NT AUTHORITY\ANONYMOUS LOGON

Computer: <SQL serverHost>

Description:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 10.x.x.x]

That's most likely because of an incorrect / missing SPN. Just search the forums - it has been discussed numerous times.

Any update? It has been almost two months now.