Can anyone suggest a way to bring-up the MS SQL Server if it is down apart from manually doing it. I would appreciate if someone can guide that through a script. I'm fighting and struggling to get a solution to it. Thanks in advance!

I mean that for whatever reason- If I need to start the SQL Server services including the agent, how do I do it through a script? I want to avoid a person sitting and just monitoring the server and bringing it up when it goes down because of any reason (may be power off/shutdown).

SQL Server runs as a service on Windows. You set the service to start automatically and every time Windows is restarted, SQL Server will be automatically started.

Just set all SQL Server services that you want started when the server start to automatic. To do this, open Configuration Manager, select the services you want and modify the startup from Manual to Automatic.

u can create a batch to do so just write this in:net start MSSQLSERVER. if u have a default instance.if u have a named instance just replace the MSSQLSERVER with ur instance name.and for the agent write ur agent service name.u can get the service name from the control panel---> administrative tools---> services

Thank you so much for your suggestions. This is the answer I wanted to confirm. Although I knew what you all have extended over to me but still would like if you could try to get over some script to bring SQL Server online or running. If any of you can try to manage it, it would be of a great help to me. Thanks again!

Check to see if SQL Server is running, and if not - start it? If so, I wouldn't want to just restart SQL Server automatically, because - if it crashed it crashed for a reason and just automatically restarting the service could cause additional corruption.

But, if you are really looking for something like that - then there are several options. Use a batch file that issues a NET START command and schedule it every few minutes, or install Powershell and look into Get-Service and Start-Service cmdlets, or use VBScript and use WMI to access the service and restart as needed, or other option.

I just installed SQL Server 2005 Evaluation edition on my desktop and laptop. Everything has been working fine; I've configured all of my services to run automatically and everything. However, today when I attempted to run SSMS I get an error that says that the Sql Server Agent could not start on the local computer. I've made sure that the account that I configured everything on is the account that I'm logged into but I'm still getting errors. Could anyone possibly help me out?

Also on my laptop I am attempting to connect to DAC with SQLCmd but it keeps telling me that the SQL Native Client has timed out; login expired. I unistalled all services and installed again and I am still getting the same errors.

for the service if its not a problem change the account to local administrator and make sure that u r writing the right password.and for the DAC please dont be offended but i have to ask, have u enabled the DAC connections from the Surface Configuration Aria?