View Full Version : SQL Database/ADX not auto-starting
OutOfControlMan
04-05-2010, 07:21 PM
I have an ADX with a fully licenced SQL. When the machine powers back on after a power outage the SQL hangs and will not start automatically. All settings in the services are set to auto start. I can manually start the SQL and all operates OK. I dont even know where to start to look. Event file shows some errors talking about named pipes.
ADX 4.1, Server2003,
crab master
04-05-2010, 09:44 PM
Just a thought - can you change the order of startup on your services running? I once had to do this to make programs work correctly, only I wasn't using services direct, I just put what I wanted to run in the startup folder and had to put them in the correct order.
CascadeControl
04-07-2010, 07:47 PM
I think Crab Master is on to something. If you have multiple services running try stopping all of them except one that the ADX is using. (MSSQLSERVER)
scrooloose
04-07-2010, 08:08 PM
You can do a dependonservice command if you know you need something started first. You could possibly link the sql start to something else you have going to make sure it is delayed long enough.
This article covers it, long read http://support.microsoft.com/kb/193888
control panel
administrative tools
services
select ms sql in the list
select properties
select recovery tab
make sure to select restart service on first failure, second failure and subsequent failures, put one minute before restart.
sorry got a meeting
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.