Solved

urgent! Suddently can't connect o sql server 2008

Posted on 2012-04-12
5
281 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

910 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

17 Experts available now in Live!

Get 1:1 Help Now