changing security model

how do i reconfigure an installed sql server to use standard security
(sql login/pwd) instead of only accepting trusted connections
(requiring windows login/pwd)
thanks,
jasonnever mind, i found it in the enterprise manager server properties
security tab.

changing sa pwd, how?

hi all,
i want to change the sa password from my C# code.
i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
simple application that changes the sa password from the code and not
the enterprise manager
i'll be logged in as an sa.
thanx for ur help and timeIf you are logging as sa then you can just run sp_password in your
code. Another option is to use SQL DMO, but I think that using
sp_password is much easier. By the way why do you need to create an
application for that? Only DBA should know the password and DBA won't
need an application to modify the SA's password.
Adi
Eng.R...@.gmail.com wrote:
> hi all,
> i want to change the sa password from my C# code.
> i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
> simple application that changes the sa password from the code and not
> the enterprise manager
> i'll be logged in as an sa.
>
> thanx for ur help and time|||Eng.Rana@.gmail.com wrote:
> hi all,
> i want to change the sa password from my C# code.
> i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
> simple application that changes the sa password from the code and not
> the enterprise manager
> i'll be logged in as an sa.
>
> thanx for ur help and time
>
Why would you possibly want to do this? The sa login/password should
NEVER be used by an application, let alone modified by one. That
information should be closely guarded and known by only those
individuals who truly need to know it. In my organization, only a few
of the DBA's know the true SA password, or where to find it. Everybody
else is granted sysadmin privileges through their Windows login.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||actually, i want to build an application to enforce some configurations
to my SQL server to ensure a checklist of configurations to harden my
server infrastructure.
actually, i found many recommanded checklists for securing sql server
like enforcing strong sa password, setting audit level to
failurem.,... and much much more. so i thought of implementing some
code that will enforce the configuration check list automatically by
the DBA once and for all.
thats why i need to change the sa password from my code.
so i was wondering how can i do it using SQL DMO
thanx for help and time :)

changing sa pwd, how?

hi all,
i want to change the sa password from my C# code.
i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
simple application that changes the sa password from the code and not
the enterprise manager
i'll be logged in as an sa.
thanx for ur help and timeIf you will be logged in as a sysadmin, easiest is probably
to just send the SQL statement in your code:
sp_password @.new = 'YourNewPassword', @.loginame = 'sa'
-Sue
On 10 Aug 2006 06:22:00 -0700, Eng.Rana@.gmail.com wrote:

>hi all,
>i want to change the sa password from my C# code.
>i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
>simple application that changes the sa password from the code and not
>the enterprise manager
>i'll be logged in as an sa.
>
>thanx for ur help and time

changing sa pwd, how?

hi all,
i want to change the sa password from my C# code.
i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
simple application that changes the sa password from the code and not
the enterprise manager
i'll be logged in as an sa.
thanx for ur help and timeIf you are logging as sa then you can just run sp_password in your
code. Another option is to use SQL DMO, but I think that using
sp_password is much easier. By the way why do you need to create an
application for that? Only DBA should know the password and DBA won't
need an application to modify the SA's password.
Adi
Eng.R...@.gmail.com wrote:
> hi all,
> i want to change the sa password from my C# code.
> i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
> simple application that changes the sa password from the code and not
> the enterprise manager
> i'll be logged in as an sa.
>
> thanx for ur help and time|||Eng.Rana@.gmail.com wrote:
> hi all,
> i want to change the sa password from my C# code.
> i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
> simple application that changes the sa password from the code and not
> the enterprise manager
> i'll be logged in as an sa.
>
> thanx for ur help and time
>
Why would you possibly want to do this? The sa login/password should
NEVER be used by an application, let alone modified by one. That
information should be closely guarded and known by only those
individuals who truly need to know it. In my organization, only a few
of the DBA's know the true SA password, or where to find it. Everybody
else is granted sysadmin privileges through their Windows login.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||actually, i want to build an application to enforce some configurations
to my SQL server to ensure a checklist of configurations to harden my
server infrastructure.
actually, i found many recommanded checklists for securing sql server
like enforcing strong sa password, setting audit level to
failurem.,... and much much more. so i thought of implementing some
code that will enforce the configuration check list automatically by
the DBA once and for all.
thats why i need to change the sa password from my code.
so i was wondering how can i do it using SQL DMO
thanx for help and time