How to resolve the SQL db can't connect to SharePoint site?

Stiebel Eltron
Stiebel Eltron used Ask the Experts™
on
Dear EE experts,

Please see the attached screenshot for the error result that we got when we tried to login to our SQL SMS.
We even couldn't open our SharePoint site anymore, it says here: "Cannot connect to the configuration database."
2 weeks ago, everything's fine, we can connect to our SP site, access SQL SMS, then just yesterday, we don't know what went wrong why we couldn't access our SQL SMS anymore that affects our SP site...

Kindly advise what would be the problem & how to resolve it...

Thank you!
SQL-connection-error.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:

1. Check if the protocols are enabled or not.
2. Check whether the servername you are providing is correct or not. It may be a named instance. You can find it from the below location:-
     Click on Start> Programs > MS SQL ..2008 > Configuration Tools > SQL Server C.. Manager > SQL Services and the instance is SQL Server (MSSQLSERVER)
3. Check if the service is running or not.

Author

Commented:
Perfect!
Out of the query question:
Is it possible if we're using SQL Server 2008 R2 & we'll put license of SQL Server 2010? Will it work?

Commented:
No idea on that part. But ideally it should not because every product has its own key and you can upgrade one but using a new key for the old product seems illogical I guess.

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial