Solved

urgent! Suddently can't connect o sql server 2008

Posted on 2012-04-12
5
283 Views
Last Modified: 2012-04-13
Today, all of a sudden, my website stopped connecting to sql server. I did not make any changes it just stopped. I can't even connect to the server via visual studio and I can't connect to sql server using sql management studo on remote machine.

I can however, connect to sql using the server itself. and I can open the website using visual studio on the server itself.

This is the error I am getting:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

I checked google thrououghly, and I do have remote connections enabled, I do have tcp enabled, I do not have my firewall even turned on. I checked netstat using "netstat -a" and it says its listening on port 1433 and 1434. I did not make any changes to sql server and it has been working fine for the last 4 years! Now all of a sudden I can't connect remotely!

Could I have been hacked? Or just something broke on it? All the data is fine and in tact and I can access it through the server itself, but I need to be able to get it remotely though my websites. Please help I need this up and running fast!

thank you so much
0
Comment
Question by:mlg101
  • 3
5 Comments
 
LVL 17

Accepted Solution

by:
Anuroopsundd earned 500 total points
ID: 37841325
as your port are listening and you are able to connect locally that means server is working fine.

it can be corrupt TCP/IP stack on the server which making the issue..
0
 
LVL 1

Author Comment

by:mlg101
ID: 37841349
How do you diagnose and dix TCP/IP stack? I've never done that
0
 
LVL 1

Author Comment

by:mlg101
ID: 37841379
I went to this link and it had an automatic thing to repair the TCP/IP and I did it, but still can't connect to sql server.
http://support.microsoft.com/kb/299357
0
 
LVL 17

Expert Comment

by:Sikhumbuzo Ntsada
ID: 37841396
Can you connect locally with another computer?
0
 
LVL 1

Author Closing Comment

by:mlg101
ID: 37841402
You were right, and also I had to power cycle my cable modem and router. Your answer got me to thinking that it was a problem with TCP routing, whether it was the stack or just the router bugging out, but I was just worried that it was a hacker or something! so I feel much better now!! thank you so much!!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

810 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