Solved

cannot connect ot local

Posted on 2013-01-10
3
367 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Union 2 queries to a cte (temp table perhaps) 9 49
This query failed in sql 2014 5 39
sql query help 15 54
MS SQL Server select from Sub Table 14 42
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 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