Cannot connect to site databse

Hello,

Configuration Manager cannot Connect to Site Database in SCCM

Please see attached logs.

Thank you in Advance.
SmsAdminUI.log
LVL 1
Moin AhmedSenior System AdministratorAsked:
Who is Participating?
 
Moin AhmedConnect With a Mentor Senior System AdministratorAuthor Commented:
We restarted SQL servers and our SCCM servers as well.

No, i did not check the services prior to reboot.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The logged error is:
"[08001][10061][Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online."

This can be because of one of the following reasons:
  • SQL Server service or the machine where SQL Server is installed is down.
  • SQL Server Browser service is not running.
  • SQL Server is not configured to allow remote connections.
  • SQL Server machine is behind a firewall and there's no rule to allow traffic to the server.
0
 
Moin AhmedSenior System AdministratorAuthor Commented:
Rebooted SQL server and that solved my problem
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
This might mean that the SQL Server service or the SQL Brower was stopped and the reboot just started the service. You shouldn't need to restart if you did check those services before.
0
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
No, i did not check the services prior to reboot.
Next time please do. Rebooting isn't usually the solution. At least the permanent solution as issues can return again later.
1
 
Moin AhmedSenior System AdministratorAuthor Commented:
Rebooted SQL servers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.