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

Changing Remote Schemas

Running Win 2K & SQL 2K
I have 15 remote locations that all have transactional
publications that are pushed to my corp. office. I need
to add a field to one of the tables that are replicated
to the corp. office at all 15 locations. So my question
is this...
What is the easiest way of accomplishing this? I know I
can add a field to a published table and the change in
schema will be replicated to the subscriber, but what
about when there are 15 publishers and only one
subscriber? How will SQL handle this?
Any help is appreciated.
Larry...
for one publisher to many susbcribers you use sp_repladdcolumn or sp_repldropcolumn.
however you have 15 publishers replicating to a single subscriber. You have probably done a no-sync subscription as well.
I suggest the best approach would be to drop the 14 or the 15 subscriptions. Make the changes on one Publisher, when the Susbcriber has received the change and the smoke settles, dust clears, make the change on the remaining 14 subscribers, and then resyn
c again using the nosync option.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Changing ORDER BY

Hi All
win 2k pro sql 2k IIS 5 ASP-vbscript
I got a stored proc which basically returns a set of records depending
on a category ID (or all if passed ID =0) - see below
The FAQ Category below is retuned mostly order by Title but in some
other areas of my site I need to return it orded by CatID.
I was wondering whats the best way to do this as I cant seem to pass a
column name to the procedure and put "ORDER BY @.SortOrder"
These are the other ways I thought of.
1) create a new procedure the same with order by catID.
2) pass a number and use CASE - but I get error 1008
eg ORDER BY CASE WHEN @.Order=0 THEN Title ELSE CatID END
I can see this becoming a common problem so wouldn't like to do #1
above as that would require alot of maintence to keep them the same if
I changed any of the table design.
Thanks for any help.
Al
CREATE PROCEDURE dbo.usp_Help_FindFAQCategoryByCatID
@.SelCatID TINYINT = 0
AS
SET NOCOUNT ON
-- Return all the FAQ Categories with Cat ID of the selected Category
SELECT CatID, ParentID, Title, FaqCount
FROM Help_FAQ_Categories
WHERE CatID= CASE WHEN @.SelCatID=0 THEN CatID ELSE @.SelCatID END
ORDER BY Title
GOTry
ORDER BY CASE WHEN @.sort = 'col1' THEN col1 END ASC,
"Harag" <harag@.softhome.net> wrote in message
news:3v4mlvo18e9vbjisl08jqrs9m75pc240gd@.4ax.com...
> Hi All
> win 2k pro sql 2k IIS 5 ASP-vbscript
> I got a stored proc which basically returns a set of records depending
> on a category ID (or all if passed ID =0) - see below
> The FAQ Category below is retuned mostly order by Title but in some
> other areas of my site I need to return it orded by CatID.
> I was wondering whats the best way to do this as I cant seem to pass a
> column name to the procedure and put "ORDER BY @.SortOrder"
> These are the other ways I thought of.
> 1) create a new procedure the same with order by catID.
> 2) pass a number and use CASE - but I get error 1008
> eg ORDER BY CASE WHEN @.Order=0 THEN Title ELSE CatID END
>
> I can see this becoming a common problem so wouldn't like to do #1
> above as that would require alot of maintence to keep them the same if
> I changed any of the table design.
> Thanks for any help.
> Al
>
> CREATE PROCEDURE dbo.usp_Help_FindFAQCategoryByCatID
> @.SelCatID TINYINT = 0
> AS
> SET NOCOUNT ON
> -- Return all the FAQ Categories with Cat ID of the selected Category
> SELECT CatID, ParentID, Title, FaqCount
> FROM Help_FAQ_Categories
> WHERE CatID=> CASE WHEN @.SelCatID=0 THEN CatID ELSE @.SelCatID END
> ORDER BY Title
> GO
>|||Harag,
it is almost correct. However, you cannot mix data types without
explicit conversions. The typical solution to this type of problem is to
use an ORDER BY column for each sort order:
ORDER BY CASE WHEN @.Order=0 THEN Title END,
CASE WHEN @.Order=1 THEN CatID END
Gert-Jan
Harag wrote:
> Hi All
> win 2k pro sql 2k IIS 5 ASP-vbscript
> I got a stored proc which basically returns a set of records depending
> on a category ID (or all if passed ID =0) - see below
> The FAQ Category below is retuned mostly order by Title but in some
> other areas of my site I need to return it orded by CatID.
> I was wondering whats the best way to do this as I cant seem to pass a
> column name to the procedure and put "ORDER BY @.SortOrder"
> These are the other ways I thought of.
> 1) create a new procedure the same with order by catID.
> 2) pass a number and use CASE - but I get error 1008
> eg ORDER BY CASE WHEN @.Order=0 THEN Title ELSE CatID END
> I can see this becoming a common problem so wouldn't like to do #1
> above as that would require alot of maintence to keep them the same if
> I changed any of the table design.
> Thanks for any help.
> Al
> CREATE PROCEDURE dbo.usp_Help_FindFAQCategoryByCatID
> @.SelCatID TINYINT = 0
> AS
> SET NOCOUNT ON
> -- Return all the FAQ Categories with Cat ID of the selected Category
> SELECT CatID, ParentID, Title, FaqCount
> FROM Help_FAQ_Categories
> WHERE CatID=> CASE WHEN @.SelCatID=0 THEN CatID ELSE @.SelCatID END
> ORDER BY Title
> GO|||Cool thanks guys this is what I wanted and will save alot of
maintence. :)
Thanks again
Al
On Sun, 07 Sep 2003 14:01:35 +0200, Gert-Jan Strik
<sorry@.toomuchspamalready.nl> wrote:
>Harag,
>it is almost correct. However, you cannot mix data types without
>explicit conversions. The typical solution to this type of problem is to
>use an ORDER BY column for each sort order:
>ORDER BY CASE WHEN @.Order=0 THEN Title END,
> CASE WHEN @.Order=1 THEN CatID END
>Gert-Jan
>
>Harag wrote:
>> Hi All
>> win 2k pro sql 2k IIS 5 ASP-vbscript
>> I got a stored proc which basically returns a set of records depending
>> on a category ID (or all if passed ID =0) - see below
>> The FAQ Category below is retuned mostly order by Title but in some
>> other areas of my site I need to return it orded by CatID.
>> I was wondering whats the best way to do this as I cant seem to pass a
>> column name to the procedure and put "ORDER BY @.SortOrder"
>> These are the other ways I thought of.
>> 1) create a new procedure the same with order by catID.
>> 2) pass a number and use CASE - but I get error 1008
>> eg ORDER BY CASE WHEN @.Order=0 THEN Title ELSE CatID END
>> I can see this becoming a common problem so wouldn't like to do #1
>> above as that would require alot of maintence to keep them the same if
>> I changed any of the table design.
>> Thanks for any help.
>> Al
>> CREATE PROCEDURE dbo.usp_Help_FindFAQCategoryByCatID
>> @.SelCatID TINYINT = 0
>> AS
>> SET NOCOUNT ON
>> -- Return all the FAQ Categories with Cat ID of the selected Category
>> SELECT CatID, ParentID, Title, FaqCount
>> FROM Help_FAQ_Categories
>> WHERE CatID=>> CASE WHEN @.SelCatID=0 THEN CatID ELSE @.SelCatID END
>> ORDER BY Title
>> GO

Changing MSDE from Win NT authentication to Mixed

Hi,
is there a way to change MSDE from Win NT authentication only to Mixed mode
authentication without reinstalling and without Enterprice Manager?
Hi,
Modify the below registry key value to 2 and restart the MSSQL Server
service.
HKLM\SoftWare\Microsoft\MSSQLSXERVER\MSSQLSERVER\
LoginMode=1 (NT Autentication)
LoginMode=2 (Mixed Mode)
Thanks
Hari
SQL Server MVP
"Olav" <Olav@.discussions.microsoft.com> wrote in message
news:E2D80B73-B1BC-4FA0-94AC-D5156168DCAC@.microsoft.com...
> Hi,
> is there a way to change MSDE from Win NT authentication only to Mixed
> mode
> authentication without reinstalling and without Enterprice Manager?

Changing IP Number on SQL 2000 Std

I am changing the IP Number on a Win 2003 Enterprise Server running SQL 2000
Std. This SQL servert is accessed by a second machine running a SharePoint
web site.
After changing the numbers to the new network on both machines and rebooting
both machines, I get "SQL Server does not exist or access denied".
I can ping each machine from the other getting the new ip numbers, I can see
the machines from each other via NetBios.
Is there something else that needs to be done?
Paul@.CommerceStreet.comDoes sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
for this info.
You also want to run cliconfg.exe to see if you have your Sharepoint
pointing to the correct server/IP.
"Paul@.CommerceStreet.com"
<Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> I am changing the IP Number on a Win 2003 Enterprise Server running SQL
2000
> Std. This SQL servert is accessed by a second machine running a SharePoint
> web site.
> After changing the numbers to the new network on both machines and
rebooting
> both machines, I get "SQL Server does not exist or access denied".
> I can ping each machine from the other getting the new ip numbers, I can
see
> the machines from each other via NetBios.
> Is there something else that needs to be done?
> Paul@.CommerceStreet.com|||running cliconfg.exe and changing the IP Number seems to have fixed the
problem. Thanks!
PF
"oj" wrote:
> Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
> for this info.
> You also want to run cliconfg.exe to see if you have your Sharepoint
> pointing to the correct server/IP.
>
> "Paul@.CommerceStreet.com"
> <Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
> news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> > I am changing the IP Number on a Win 2003 Enterprise Server running SQL
> 2000
> > Std. This SQL servert is accessed by a second machine running a SharePoint
> > web site.
> >
> > After changing the numbers to the new network on both machines and
> rebooting
> > both machines, I get "SQL Server does not exist or access denied".
> >
> > I can ping each machine from the other getting the new ip numbers, I can
> see
> > the machines from each other via NetBios.
> >
> > Is there something else that needs to be done?
> >
> > Paul@.CommerceStreet.com
>
>

Changing IP Number on SQL 2000 Std

I am changing the IP Number on a Win 2003 Enterprise Server running SQL 2000
Std. This SQL servert is accessed by a second machine running a SharePoint
web site.
After changing the numbers to the new network on both machines and rebooting
both machines, I get "SQL Server does not exist or access denied".
I can ping each machine from the other getting the new ip numbers, I can see
the machines from each other via NetBios.
Is there something else that needs to be done?
Paul@.CommerceStreet.com
Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
for this info.
You also want to run cliconfg.exe to see if you have your Sharepoint
pointing to the correct server/IP.
"Paul@.CommerceStreet.com"
<Paul@.CommerceStreet.com@.discussions.microsoft.com > wrote in message
news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> I am changing the IP Number on a Win 2003 Enterprise Server running SQL
2000
> Std. This SQL servert is accessed by a second machine running a SharePoint
> web site.
> After changing the numbers to the new network on both machines and
rebooting
> both machines, I get "SQL Server does not exist or access denied".
> I can ping each machine from the other getting the new ip numbers, I can
see
> the machines from each other via NetBios.
> Is there something else that needs to be done?
> Paul@.CommerceStreet.com
|||running cliconfg.exe and changing the IP Number seems to have fixed the
problem. Thanks!
PF
"oj" wrote:

> Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
> for this info.
> You also want to run cliconfg.exe to see if you have your Sharepoint
> pointing to the correct server/IP.
>
> "Paul@.CommerceStreet.com"
> <Paul@.CommerceStreet.com@.discussions.microsoft.com > wrote in message
> news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> 2000
> rebooting
> see
>
>

Changing IP Number on SQL 2000 Std

I am changing the IP Number on a Win 2003 Enterprise Server running SQL 2000
Std. This SQL servert is accessed by a second machine running a SharePoint
web site.
After changing the numbers to the new network on both machines and rebooting
both machines, I get "SQL Server does not exist or access denied".
I can ping each machine from the other getting the new ip numbers, I can see
the machines from each other via NetBios.
Is there something else that needs to be done?
Paul@.CommerceStreet.comDoes sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
for this info.
You also want to run cliconfg.exe to see if you have your Sharepoint
pointing to the correct server/IP.
"Paul@.CommerceStreet.com"
<Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> I am changing the IP Number on a Win 2003 Enterprise Server running SQL
2000
> Std. This SQL servert is accessed by a second machine running a SharePoint
> web site.
> After changing the numbers to the new network on both machines and
rebooting
> both machines, I get "SQL Server does not exist or access denied".
> I can ping each machine from the other getting the new ip numbers, I can
see
> the machines from each other via NetBios.
> Is there something else that needs to be done?
> Paul@.CommerceStreet.com|||running cliconfg.exe and changing the IP Number seems to have fixed the
problem. Thanks!
PF
"oj" wrote:

> Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORL
OG
> for this info.
> You also want to run cliconfg.exe to see if you have your Sharepoint
> pointing to the correct server/IP.
>
> "Paul@.CommerceStreet.com"
> <Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
> news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> 2000
> rebooting
> see
>
>