RE: Changing SQL startup account
From: Simon (Simon_at_discussions.microsoft.com)
Date: 02/28/05
- Next message: Clifford Heath: "Security and access rights using local and global groups"
- Previous message: Simon: "Re: All users can start and stop SQL Server?"
- In reply to: Luke: "Changing SQL startup account"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 27 Feb 2005 20:27:02 -0800
Luke,
We had a very similar situation, and we followed the solution in:
http://groups.google.com/groups?q=logon+as+service&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=1310c01c12f1d%2410d20180%24a5e62ecf%40tkmsftngxa07&rnum=3
However, we weren't using clusters so this might not be appropriate.
Simon.
"Luke" wrote:
> 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.
>
>
>
- Next message: Clifford Heath: "Security and access rights using local and global groups"
- Previous message: Simon: "Re: All users can start and stop SQL Server?"
- In reply to: Luke: "Changing SQL startup account"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
