Changing SQL startup account

From: Luke (lmihalko_at_hotmail.com)
Date: 02/25/05 

Date: Thu, 24 Feb 2005 18:38:51 -0500

I just can't seem to get this working right. I want to make it just a
regular domain user in a W2k domain on a 2003 server running sql 2000 sp3.
Everything is in place from what I see. It actually works too...until you
reboot. I don't konw what is wrong. Perhaps someone knows about this
error.

SQL Server could not find the default instance (MSSQLSERVER) - please
specify the name of an existing instance on the invocation of sqlservr.exe.

I think I reinstalled this about 10 times now, I'll do it again if it makes
it work too.

Yes, I get the same error loging in as the accound and trying to run the
sqlservr manually.

I'm guessing it is something from one of the policies when it reboots?
Or maybe the service start after the initial install/change in the
Enterprise Manager and the service starts out of context?

Any help from someone who did this before would be great. Because at this
point I don't even think it will work.

Relevant Pages

  • GPOs only applying once a day
    ... If a system is rebooted during the day, policies usually ... Or if a system is reboot at ... If I make a change to a policy, save it, and then reboot the system, then ... the log picks up and continues just the same as in the second log. ...
    (microsoft.public.windows.group_policy)
  • Re: win2003 fax service
    ... actually i didn't need to reboot, restarting the fax service worked fine. ... > now this worries me as i don't know how many policies are missing their ... >> Fax Service runs under the account NETWORK SERVICE. ... choose Local Policies then User Rights Assignment. ...
    (microsoft.public.win2000.fax)
  • Re: Annoying Policy Problem
    ... Interesting that the setting persists in a non domain computer. ... all policies in effect you can try this. ... and then back on or reboot to see it finally work. ... >>> again and the enabled radio button is ticked. ...
    (microsoft.public.windows.group_policy)
  • RE: Changing SQL startup account
    ... we weren't using clusters so this might not be appropriate. ... Simon. ... > reboot. ... I get the same error loging in as the accound and trying to run the ...
    (microsoft.public.sqlserver.security)
  • Re: Turned off SMB signing on server...
    ... Here is the exact event info: ... Security policies were propagated with warning. ... >> Still can't reach server from Client. ... >> really well and reboot ...
    (microsoft.public.windows.server.sbs)