Unable to connect to new Configuration Manager lab

jacobccjude 365 Reputation points
2024-07-17T14:35:46.3166667+00:00

I have set up a new configuration manager lab, everything seems ok, but I can't connect to my configuration manager site. After some troubleshooting steps, I find the SQL server services are stopped and I can't start these services, see the error screenshot. What's the next step should I do?

sql error

Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. Simon Ren-MSFT 32,986 Reputation points Microsoft Vendor
    2024-07-18T07:15:41.28+00:00

    Hi,

    Thank you for posting in Microsoft Q&A forum.

    1,We can add the log on account in the SQL logins to have a try. Open SSMS and connect to the site database, then navigate to <Server>/Security/Logins, check if the computer account is there. If not, add it. If yes, remove it and add it back with the same setting. Then check the results.

    2,We can also try to use a domian admin accout in the log on accout to have a try.

    3,Please check the event log under Windows logs\Applicaiton to see if there is any further information about the login failure.

    Similar threads for your reference:

    SCCM Configuration Manager console cannot connect to Site

    SQL Server startup errors on a standalone server

    Thanks for your time. Have a nice day!

    Best regards,

    Simon


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Sherry Kissinger 4,311 Reputation points
    2024-07-17T21:09:52.1466667+00:00

    It says to look at the event logs, likely for the service. What does the log say for why it failed to start the service?

    Did you try a time-honored reboot yet?

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.