Solved

urgent! Suddently can't connect o sql server 2008

Posted on 2012-04-12
5
289 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

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

Suggested Solutions

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…
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…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

730 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