Re: Starting SQL Server under SQL authentication instead of NT authentication
From: Hari (hari_prasad_k_at_hotmail.com)
Date: Tue, 9 Mar 2004 10:27:51 +0530
You can use only OS level users as the startup service account.
"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
> Furthermore, some people said that I could start SQL Server /SQL Server
> agent under SQL authentication. But how, I need the steps please. Because
> things are more easier said then done.
> I am aware that you cannot start SQL Server services under SQL
> authentication but only NT authentication.
> So how could some people claimed to be able to use SQL authentication to
> start SQL Server/ Agents????
> Please list the steps. I had enough of theories and claims...
> "Joe Mine" <huytuanattpgdotcomdotau> wrote in message
> > I have a SQL Server installed upon a Windows 2k Server Domain Controller
> > with Active Directory. SQL Server is setup in Mixed mode authentication,
> > at present SQL Server/ Agent starts under the NT account. How do I get
> > start under SQL logins account. What are the steps, please list the
> > Thank you.