asked
My server is stopped how can i troubleshoot it......
this is question i faced in interview i said to him,I will start sqlserver service but he was not accepting........ what is the anwser tell me
This was a question to test your knowledge and understanding of the system. There isn't a right or a wrong answer. It's one where we explore what you've seen, how you've been able to troubleshoot issues, failures and successes you've had in the past when dealing with the server being offline. If I were the one interviewing you, I'd say that the server is down, now what? Your answer, just starting the service doesn't take into account determining any issues, testing connectivity, all sorts of things. For example, it's pretty normal to get a report that a SQL Server instance is offline when, in fact, it's fine and the person reporting it doesn't have the right connection string. So just going straight to the service and trying to start it would be a problematic approach if the server was already started.
It can be many reasons, but the most basic one is when you change your account's password that starts that SQL Server Service! If needed try to check also the events at OS level!
16 People are following this question.
