Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Service Autostart not working (2000)
- Thread starter cmwright
- Start date
ptheriault
IS-IT--Management
Have you checked the event view application or system log. It should give you a reason or error why a service fails to start.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Thread starter
- #3
Yes. That's what I referenced in the original post. There are no errors in any of the event logs. First place I checked. 
And I don't think that it's because the service is failing to start. It just isn't trying to start, though it's set to Automatic. I think. Otherwise, I'd see errors in the event logs. It starts right up when started manually. Any other ideas?
-Chris
And I don't think that it's because the service is failing to start. It just isn't trying to start, though it's set to Automatic. I think. Otherwise, I'd see errors in the event logs. It starts right up when started manually. Any other ideas?-Chris
Have you verified that it's using the correct password to start up or that it doesn't have dependencies set that haven't themselves started up?
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
ptheriault
IS-IT--Management
to add to Cat...If you are trying to start it with an domain account, check pemissions on the server for that account.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
mrdenny
Programmer
- May 27, 2002
- 11,595
Is there anything in the ERRORLOG?
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
Okay, this idea came at me out of the blue. It may have nothing to do with your situation, but... you know, just in case, I thought I'd mention it.
Yesterday, I was messing with some Alter Database statements on my personal PC, trying to move the files for the system dbs. Turns out that I can't start my services either now because I did the Alter wrong and it now can't find the Model DB.
Of course, this is my personal development instance, so it's no big deal to me to just re-install it since I obviously can't get in to properly change the paths to the system DBs. But, it's a thought for you about your problem. Did you use Alter Database to change the system DB paths? Did you subsequently remember to actually move the data & log files for the system DBs after you did that?
You can see in the Application log of the Event Viewer problems with starting SQL Server (if you haven't already checked there, that is).
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
Yesterday, I was messing with some Alter Database statements on my personal PC, trying to move the files for the system dbs. Turns out that I can't start my services either now because I did the Alter wrong and it now can't find the Model DB.
Of course, this is my personal development instance, so it's no big deal to me to just re-install it since I obviously can't get in to properly change the paths to the system DBs. But, it's a thought for you about your problem. Did you use Alter Database to change the system DB paths? Did you subsequently remember to actually move the data & log files for the system DBs after you did that?
You can see in the Application log of the Event Viewer problems with starting SQL Server (if you haven't already checked there, that is).
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
ptheriault
IS-IT--Management
That a good though Cat. Funny too because I did the same thing 2 weeks ago! : )
But I don't think thats his problem because he says it will start right up when he starts it manually. So that means it can't be permissions, password or configuration. I think it might have more to do with the OS.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
But I don't think thats his problem because he says it will start right up when he starts it manually. So that means it can't be permissions, password or configuration. I think it might have more to do with the OS.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Thread starter
- #10
Hey everyone!
Good thoughts, all! Paul is right. Everything works beautifully. I didn't alter the system database paths in this case. I think it might be an OS thing as well, but there are no errors anywhere, even in the ERRORLOG where mrdenny suggested. Total puzzle. I use the same domain account for all of my servers, and this is the only one with the problem. Well, there are 2, but I have many more that are fine.
I will keep digging and keep you all updated. Keep the ideas coming if you think of any more.
Thanks!
-Chris
Good thoughts, all! Paul is right. Everything works beautifully. I didn't alter the system database paths in this case. I think it might be an OS thing as well, but there are no errors anywhere, even in the ERRORLOG where mrdenny suggested. Total puzzle. I use the same domain account for all of my servers, and this is the only one with the problem. Well, there are 2, but I have many more that are fine.
I will keep digging and keep you all updated. Keep the ideas coming if you think of any more.
Thanks!
-Chris
ptheriault
IS-IT--Management
Chris,
Are there any services that start before SQL that are failing? Does the server come up normal?
- Paul
- If at first you don't succeed, find out if the loser gets anything.
Are there any services that start before SQL that are failing? Does the server come up normal?
- Paul
- If at first you don't succeed, find out if the loser gets anything.
mutley1
MIS
- Jul 24, 2003
- 909
Silly question, but insetad of using SQL EM or the taskbar icon, have you looked in services through Admin tools to check they are set to automatic etc?
also, do you have any instances on the 2 problem boxed or are they just default instances on their own?
Cheers,
M.
also, do you have any instances on the 2 problem boxed or are they just default instances on their own?
Cheers,
M.
And this leads me to be curious as to if you're using domain or local admin accounts for the services. And are you using the same accounts on these two boxes as you're using on the other boxes?
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
- Thread starter
- #14
Good questions. Information Assurance is a bear, here, so all installations are identical, using domain accounts for both the sql service and the agent service. As indicated above, both services are set to Autostart. They are not manual or disabled. I do not use EM or the taskbar to start the services. Just a habit for me to use the services listing to start and adjust settings for the services there.
There is only 1 instance per box...the default.
Domain accounts have the appropriate permissions, as evidenced by the fact that the other servers work without a hitch.
For those with a morbid curiousity, I have to follow the rules found here:
That has nothing to do with my situation, but it might make you feel a little better about your job.
Still working on it!
-Chris
There is only 1 instance per box...the default.
Domain accounts have the appropriate permissions, as evidenced by the fact that the other servers work without a hitch.
For those with a morbid curiousity, I have to follow the rules found here:
That has nothing to do with my situation, but it might make you feel a little better about your job.
Still working on it!-Chris
ptheriault
IS-IT--Management
Chris,
I used to work at NUWC (Naval Undersea Warefare Center) so you have my complete sympathy!
- Paul
- If at first you don't succeed, find out if the loser gets anything.
I used to work at NUWC (Naval Undersea Warefare Center) so you have my complete sympathy!
- Paul
- If at first you don't succeed, find out if the loser gets anything.
Are the domain accounts mapped to any permissions on the OS? Specifically any DENY permissions?
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
- Thread starter
- #18
OK. I checked for dependencies. Nothing there. And I didn't see any local security policies that denied anything relevant. Would that make sense, though, since it works once started manually? It's odd that it works, just doesn't start with the OS.
-Chris
-Chris
You know, I believe none of us bothered to check what OS you're running. What is it and what service pack (if any) is it patched up to?
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
- Thread starter
- #20
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
