How to resolve SQL Connection problem?

SQL Login Error
Dear Experts,

Kindly see the attached image for the screenshot of our SQL Server. We're trying to login to our SQL Server 2008 R2, but we always receive that error... And that is the reason maybe why does our SharePoint can't communicate or connect to our configuration database. Because our MOSS 2007 is connected to our SQL Server (different server machine)...

Please advise on how we could resolve this matter...

Thank you in advance.
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.

Koen Van WielinkBusiness Intelligence SpecialistCommented:
Have you done your basic network troubleshooting? Can you ping the server? Can you access it through remote desktop? Did you set all the relevant firewall rules on the SQL server, open the necessary ports, etc?
0
Stiebel EltronAuthor Commented:
Hi there Koen!

Ping, yes, we can ping the server.
RD, yes, we're remoting it at this moment.
We open everything. It's just yesterday had electric failure, so the servers are down. And when we try to start it up, everything's fine except for the SQL db. We can't login to the SSMS, and even to the SQL Server Configuration Manager: SQL SCM Errorwe can't START its service.
0
Koen Van WielinkBusiness Intelligence SpecialistCommented:
Well, the fact that the service won't start is probably the reason of your connection issues. Now we need to figure out why the service won't start.
Did you check the event log as described in the window? What errors are logged when the service is being started?
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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

sameer2010Commented:
Please post the findings from event viewer.
Also, see if the master db is corrupt. If you have a backup, try restoring it by replacing C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA or corresponding version on your system.
Then try restarting the server.
0
Stiebel EltronAuthor Commented:
Though we got the resolution with this issue not directly from any experts of EE, but from ourselves, we would want to award points to expert Koen, if not because from his message in regards to event log, would not found this: "The SQL Server failed to initialize VIA support library [QLVipl.dll]. This normally indicates the VIA support library does not exist or is corrupted. Please repair or disable the VIA network protocol. Error: 0x7e.", and from there we disabled the VIA from the SQL Server Config Manager...
Then after that, we can access now the SQL Server Management Studio, Start SQL Service, SharePoint is running smoothly again...

Thank you!
0
Koen Van WielinkBusiness Intelligence SpecialistCommented:
Glad you got it solved.
0
Stiebel EltronAuthor Commented:
Thank you!
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.