Solved

urgent! Suddently can't connect o sql server 2008

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
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…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

691 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