change user password

hi all,
how to change the password for sql server authenication.. the user
password.. if the password changed, what effect to database sideHi Julie
You can use sp_password to change the password for a login. The user would
need to use that password the next time they logged in. For more information
see Books Online.
John
"jullie" wrote:
> hi all,
> how to change the password for sql server authenication.. the user
> password.. if the password changed, what effect to database side
>|||Hi
Take a look at sp_password stored procedure in the BOL
"jullie" <jullie@.discussions.microsoft.com> wrote in message
news:FDC1C8B0-7FA6-44B7-ABA7-D26B52E48CF3@.microsoft.com...
> hi all,
> how to change the password for sql server authenication.. the user
> password.. if the password changed, what effect to database side
>|||In article <FDC1C8B0-7FA6-44B7-ABA7-D26B52E48CF3@.microsoft.com>,
jullie@.discussions.microsoft.com says...
> hi all,
> how to change the password for sql server authenication.. the user
> password.. if the password changed, what effect to database side
>
>
In 2K the recommendation was to make the changes through the server
manager. This will change the ACL's to the new account and delete the
old ones. Doing it after the fact will set them, but not delete the old
permissions which will gave to be handled manuallyfor best security.
Anybody know if this is still true w/ SSMS in 2005?
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu|||Hi Pete
I believe you are thinking of the service account rather than the SQL logins
that the OP was asking about.
For SQL 2005, Configuration manager is the recommended method of changing
the accounts see http://msdn2.microsoft.com/en-us/library/ms143746.aspx
John
"Pete Berry" wrote:
> In article <FDC1C8B0-7FA6-44B7-ABA7-D26B52E48CF3@.microsoft.com>,
> jullie@.discussions.microsoft.com says...
> > hi all,
> >
> > how to change the password for sql server authenication.. the user
> > password.. if the password changed, what effect to database side
> >
> >
> >
> In 2K the recommendation was to make the changes through the server
> manager. This will change the ACL's to the new account and delete the
> old ones. Doing it after the fact will set them, but not delete the old
> permissions which will gave to be handled manuallyfor best security.
> Anybody know if this is still true w/ SSMS in 2005?
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
>|||In article <CF98DC23-1896-4019-B98C-D2490E7B5E85@.microsoft.com>,
jbellnewsposts@.hotmail.com says...
> Hi Pete
> I believe you are thinking of the service account rather than the SQL logins
> that the OP was asking about.
> For SQL 2005, Configuration manager is the recommended method of changing
> the accounts see http://msdn2.microsoft.com/en-us/library/ms143746.aspx
> John
> "Pete Berry" wrote:
> > In article <FDC1C8B0-7FA6-44B7-ABA7-D26B52E48CF3@.microsoft.com>,
> > jullie@.discussions.microsoft.com says...
> > > hi all,
> > >
> > > how to change the password for sql server authenication.. the user
> > > password.. if the password changed, what effect to database side
> > >
> > >
> > >
> > In 2K the recommendation was to make the changes through the server
> > manager. This will change the ACL's to the new account and delete the
> > old ones. Doing it after the fact will set them, but not delete the old
> > permissions which will gave to be handled manuallyfor best security.
> >
> > Anybody know if this is still true w/ SSMS in 2005?
> > --
> > Graham (Pete) Berry
> > PeteBerry@.Caltech.edu
> >
>
yup -- my bad!
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu

Change SA password. Any effect to replication?

Dear all,

I have some questions regard subject above. I want to know the impact of replication process after SA pasword been changed.

Example: server1 (hq), server2 (district) & server3 (district).

If server1, SA password been changed, is it server2 & server3 need to change too?

may i know where is it the replication SA password stored? is it replication script refer ID (SA) from Security -> Logins?

I hope someone can help me.. thanks.

changing the Sa password would not harm the replication process

ideally...

replication is using the account used by the sqlserver agent services.

to know what account is your agent services running.

click start>run>type "services.msc">look for sqlserver agent

Click on Log On> this is the account used by replication.

usually this is a domain account..

if your system is configure in this manner, then changing the "Sa" password

will not matter at all.

If it configured some other way around then you have to watch out for the account

being used in the replication

Change port 1433

Hi
I am trying to change default port on sql server 2005 via sql config
manager, but the change is not taking effect even after restarting the
services. Any ideas would be appreciated?Found out I didnt have permission to the registry. Fixed now.
"guest5" wrote:
> Hi
> I am trying to change default port on sql server 2005 via sql config
> manager, but the change is not taking effect even after restarting the
> services. Any ideas would be appreciated?

Change port 1433

Hi
I am trying to change default port on sql server 2005 via sql config
manager, but the change is not taking effect even after restarting the
services. Any ideas would be appreciated?
Found out I didnt have permission to the registry. Fixed now.
"guest5" wrote:

> Hi
> I am trying to change default port on sql server 2005 via sql config
> manager, but the change is not taking effect even after restarting the
> services. Any ideas would be appreciated?

Change port 1433

Hi
I am trying to change default port on sql server 2005 via sql config
manager, but the change is not taking effect even after restarting the
services. Any ideas would be appreciated?Found out I didnt have permission to the registry. Fixed now.
"guest5" wrote:

> Hi
> I am trying to change default port on sql server 2005 via sql config
> manager, but the change is not taking effect even after restarting the
> services. Any ideas would be appreciated?