Hi ,

As part of resolving the corrupt SCCM 2012 R2 environment, we have uninstalled the site from the Standalone primary site and restored it from the last backup. The database is on remote server on SQL 2012 SP1. Only Site recovery is run.

Post the restoration on unable to launch the SCCM console, Error Could not connect to the site.

When I checked the logs in the log file SmsProv.log in the program filles\Microsoft Configuration manager\logs, the error is as below

*~*~e:\nts_sccm_release\sms\siteserver\sdk_provider\smsprov\sspobjectquery.cpp(6260) : SQL Connection attempt timed out~ SQL Error: [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'XXXX\ABBC$'.~*~*

*~*~SQL Connection attempt timed out [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'XXXX\ABBC$'.~*~*

<*><*> CANT CONNECT TO SQL, RETURNING ERROR <*><*>

Regards

Leela

Did you run a site Reset?

Have you confirm that permissions on the SQL server?

Hi Grath,

We ran a Site recovery, I checked the permissions on SQL server. Could not find the SCCM machine account in the SQL logins. Adding the SCCM machine account to the SQL logins solved the issue. As part of the recovery we only recovered the Site using the Site backup. Have not touched the SQL server which is on a remote machine??

Anyways the login issue is resolved now.

Regards

Leela

• Marked as answer by RaniGun 5 hours 35 minutes ago