Solved

cannot connect ot local

Posted on 2013-01-10
3
362 Views
Last Modified: 2013-01-10
My copy of SQL Server 2008 has stopped working.  I have had it installed since August and use it every day.  All of a sudden when I started up the computer, I am getting a message stating that it can't open a connection to local.  error 40 - Could not open a connection to SQL Server.  Microsoft SQL Server, Error: 2
Am I going to have to reinstall SQL server or could there be another problem?  
I shut down the computer and restarted it and I received the same error.  

I had Windows Authentication and I switched it to SQL Server Authentication and I recieved the same result. Any thoughts?
0
Comment
Question by:LenTompkins
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
Gary Fuqua, CISSP earned 500 total points
ID: 38765316
Are you trying to connect to a Local Copy of SQL Server, or over a LAN connection from a workstation to a server?

If over a LAN, verify that SQL Server is running on the server.   On the workstation, make sure that you don't have a firewall blocking access.   Some antivirus programs will change the firewall settings and cause problems when they are updated.   I suggest turning off any firewall or antivirus program for your testing.
0
 

Author Comment

by:LenTompkins
ID: 38765415
I am connecting to a local copy of SQL server, and I turned the internet off as well as Kaspersky and I still received the same error.
0
 

Author Comment

by:LenTompkins
ID: 38765477
I just solved the problem.  I turned the machine off, made sure it was unplugged, and took the battery out.  Then I held the power button down for 60 seconds and put the battery back in.  I restarted the computer and started SQL Server and it now works.  I believe I have some hardware issues with this machine, so I will have to get it fixed.  Thank you for your suggestion.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

912 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now