Re: Starting SQL Server under SQL authentication instead of NT authentication

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 10:27:51 +0530

Hi,

You can use only OS level users as the startup service account.

Thanks
Hari
MCDBA

"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
news:eF5pM#WBEHA.2628@TK2MSFTNGP11.phx.gbl...
> 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
> news:OgXE$XWBEHA.892@tk2msftngp13.phx.gbl...
> > I have a SQL Server installed upon a Windows 2k Server Domain Controller
> > with Active Directory. SQL Server is setup in Mixed mode authentication,
> and
> > at present SQL Server/ Agent starts under the NT account. How do I get
it
> to
> > start under SQL logins account. What are the steps, please list the
steps.
> > Thank you.
> >
> >
>
>

Relevant Pages