Change SQL Server Authentication Programmatically

[Jono Price]

Hi,

Does anyone here know whether it is possible to change the
authentication method of a SQL server instance programmaticall y, rather
than going through enterprise manager.

I am using SQL-DMO (under C#) for some other things, but the
documentation is so bad that I can't find out whether what I want to do
can be done. I have also tried googling but came up empty handed.

I hope that someone can help me.

Cheers
Jono

[John Bell]

Re: Change SQL Server Authentication Programmaticall y

Hi

At a guess try SetSecurityMode under the SQLServer/IntegratedSecur ity Object

John
"Jono Price" <jonathan_daivd _price@hotmail. com> wrote in message
news:4298443f$0 $542$ed2619ec@p tn-nntp-reader03.plus.n et...[color=blue]
> Hi,
>
> Does anyone here know whether it is possible to change the authentication
> method of a SQL server instance programmaticall y, rather than going
> through enterprise manager.
>
> I am using SQL-DMO (under C#) for some other things, but the documentation
> is so bad that I can't find out whether what I want to do can be done. I
> have also tried googling but came up empty handed.
>
> I hope that someone can help me.
>
> Cheers
> Jono[/color]

[Jono Price]

Re: Change SQL Server Authentication Programmaticall y

John Bell wrote:[color=blue]
> Hi
>
> At a guess try SetSecurityMode under the SQLServer/IntegratedSecur ity Object
>
> John[/color]

Thank you so much. I couldn't believe that it wasn't possible, but I
also couldn't find that.


Thanks again.

Jono