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

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
Stiebel EltronAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TempDBACommented:

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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Stiebel EltronAuthor 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?
0
TempDBACommented:
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.
0
Stiebel EltronAuthor Commented:
Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

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.