Solved

Users can not connect to SQl server 2005

Posted on 2011-03-25
2
209 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 40

Accepted Solution

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

Expert Comment

by:Jshaw
ID: 35216626
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

828 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