Re: Change SQL Server Authentication method programmatically

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 05/28/05

  • Next message: Blake Mengotto: "Re: SQL 2000 Security Question" 
    Date: Sat, 28 May 2005 14:24:14 +0200

    The only thing I know about, though I am not quite familar with SQL-DMO is
    to change the regkey:, using the XP xp_regwrite

    For registry changing try this regkey:

    Default instance:
    "HKEY_LOCAL_MACHINE\Software\M­icrosoft\MSSqlserver\MSSqlServ­er\LoginMode"

    to 2 for mixed-mode or 1 for integrated. 

    -- 
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"Jono Price" <jonathan_daivd_price@hotmail.com> schrieb im Newsbeitrag 
news:42984478$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
  • Next message: Blake Mengotto: "Re: SQL 2000 Security Question"