Solved

Users can not connect to SQl server 2005

Posted on 2011-03-25
2
205 Views
Last Modified: 2012-05-11
Expert,

SQL server suddenly stops working and all users complain that they can’t connect to the server, I check the database server and SQL services, they are online and started. What would be the next thing I check?
0
Comment
Question by:yrcdba7
2 Comments
 
LVL 39

Accepted Solution

by:
Kyle Abrahams earned 500 total points
Comment Utility
Ensure you have named pipes in your configure enabled.
http://support.microsoft.com/kb/265808
0
 
LVL 2

Expert Comment

by:Jshaw
Comment Utility
What error are they getting? cannot generate SSPI context? then a AD kerberos issue Check the DNS entries. Post your error please
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.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
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…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

763 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

6 Experts available now in Live!

Get 1:1 Help Now