Posted by Erland Sommarskog on 09/21/06 10:50

sara (sarasara82@gmail.com) writes:
> Thanks a lot for your response. I went to SQL Server configuration
> manager->sql server 2005 services->sql server is stopped and if I try
> to start it fails and says that "the request failed or the service did
> not respond in a timely fashion"

That's bad. But at least we know why you cannot connect from SSMS. :-)

Go to
C:\Prorgam Files\Microsoft SQL Server\MSSQL.1\MSSQL\Log and look in the
file ERRORLOG and see if there is an error message. Check that the date
of the file agrees with your last attempt to start the service.

Note: the exact path can vary if you installed SQL Server to another
path, or if you have more than once instance.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: UNION / INTERSECT / EXCEPT in SQL Server 2000
• Prev in forum: Obtain the query plan of a running process
• Thread view: Re: SQL server connection

[Reply to this message]