Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 server stopped

Author  Topic 

sandhyarao49
Starting Member

4 Posts

Posted - 2008-10-08 : 01:12:57

Hi to all,

I have a doubt.
If some one has stopped the server, then we are not able to login into the server.
How to login into the server.
Is there any chance that we can find who has stopped the server.
(by loginid ). Is it possible ?

Thanks,
Sandhya

krajdba
Starting Member

43 Posts

Posted - 2008-10-08 : 03:03:56
If the server is shutdown we cannot login to that server. You can look into windows event logs to findout who has stopped the server.



Raj.
Go to Top of Page

lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-10-08 : 04:52:14
Try to restart the SQL Server service on the services from the administration tools.

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-08 : 08:01:35
If it is production server, all information are clearly logged on desktop as who did and at what time.
Go to Top of Page
   

- Advertisement -