Solved

How to resolve SQL Connection problem?

Posted on 2014-11-16
7
182 Views
Last Modified: 2014-11-16
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.
0
Comment
Question by:Stiebel Eltron
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 40446577
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
 

Author Comment

by:Stiebel Eltron
ID: 40446581
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
 
LVL 13

Accepted Solution

by:
Koen Van Wielink earned 500 total points
ID: 40446583
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 13

Expert Comment

by:sameer2010
ID: 40446605
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
 

Author Closing Comment

by:Stiebel Eltron
ID: 40446609
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
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 40446612
Glad you got it solved.
0
 

Author Comment

by:Stiebel Eltron
ID: 40446622
Thank you!
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question