Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

cannot connect ot local

Posted on 2013-01-10
3
Medium Priority
?
371 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 1500 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Integration Management Part 2
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

580 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