Home > Archive > Microsoft SQL Server forum > May 2005 > Change SQL Server Authentication Programmatically









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Change SQL Server Authentication Programmatically
Jono Price

2005-05-28, 7:23 am

Hi,

Does anyone here know whether it is possible to change the
authentication method of a SQL server instance programmatically, 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

2005-05-28, 7:23 am

Hi

At a guess try SetSecurityMode under the SQLServer/IntegratedSecurity Object

John
"Jono Price" < jonathan_daivd_price
@hotmail.com> wrote in message
news:4298443f$0$542$
ed2619ec@ptn-nntp-reader03.plus.net...
> Hi,
>
> Does anyone here know whether it is possible to change the authentication
> method of a SQL server instance programmatically, 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



Jono Price

2005-05-28, 7:23 am

John Bell wrote:
> Hi
>
> At a guess try SetSecurityMode under the SQLServer/IntegratedSecurity Object
>
> John


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


Thanks again.

Jono
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com