how to change the login for connect to the report database?

when we install report server database, a login and password is needed to
connect to the RS server database.
but my boss change the password in the server so i cant access to the report
server again as the report server said login in failed.
how can i tell teh reporting service the new password?
thanks in advance> how can i tell teh reporting service the new password?
Use the rsconfig.exe utility. Look for the syntax in RS Books OnLine.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.comsql

How to change the Cluster service(O/S cluster) account password ?

hi everyone !
i have one cluster for win2003 mscs , it's active , passive cluster
How to change the Cluster service(O/S cluster) account password ?
(not sql cluster account..)
Thanks..
Control Panel/Administrative Tools/Services
Select the servers navigate to log on tab and change.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"jsmin" <jsmin@.techdata.co.kr> wrote in message
news:uwFPmzr0FHA.1040@.TK2MSFTNGP14.phx.gbl...
> hi everyone !
> i have one cluster for win2003 mscs , it's active , passive cluster
> How to change the Cluster service(O/S cluster) account password ?
> (not sql cluster account..)
> Thanks..
>
|||Select the service, navigate to log on tab and change.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Nik Marshall-Blank" <Nik@.here.com> wrote in message
news:CIH4f.130349$sp2.89220@.fe03.news.easynews.com ...
> Control Panel/Administrative Tools/Services
> Select the servers navigate to log on tab and change.
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "jsmin" <jsmin@.techdata.co.kr> wrote in message
> news:uwFPmzr0FHA.1040@.TK2MSFTNGP14.phx.gbl...
>
|||You can use services control panel, but with 2003 another way is possible -
http://support.microsoft.com/?id=305813
Use cluster.exe and change both nodes at the same time
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"jsmin" <jsmin@.techdata.co.kr> wrote in message
news:uwFPmzr0FHA.1040@.TK2MSFTNGP14.phx.gbl...
> hi everyone !
> i have one cluster for win2003 mscs , it's active , passive cluster
> How to change the Cluster service(O/S cluster) account password ?
> (not sql cluster account..)
> Thanks..
>
|||perhaps u should try to use the command line cluster.exe with the password
option properties in the command prompt
regards
ali
"jsmin" wrote:

> hi everyone !
> i have one cluster for win2003 mscs , it's active , passive cluster
> How to change the Cluster service(O/S cluster) account password ?
> (not sql cluster account..)
> Thanks..
>
>

How to change SA Password?

Hi, i'm running SQL Server 2000, the SA password hasn't been changed since it was installed. How do i go aobut changing the SA password? thanks in advice to any one who can help.Use EM - you'll find it under Security / Logins.

how to change password?

Dear experts,
i'm getting problem with sql server 2000. actually i changed the service from automatic to manual, right from that day,sql server is not working on my machine.when i checkd in the properties of sql server registration, it is showing some around 8 letter password. actually i will connect with sa and password sa.

where should i change the password? is there any other solution?

or is it better to uninstall and install again? if so what about my databases?

please help me in this regardHello vinod,

Go to the folder security;
Double click on the user;
Change the password (don't forget it!!!)
Pressing on the Ok button;
Repeat the password.

In principle, if you press as password of only one character, for security reasons sqlserver 2000 will show you as password 10 stars.

For testing create a new user and change the password.

Good luck,
Michelle.|||on 'edit sql registration properties' window, use windows authentication first. after u've logon, change the password on Security->Logins section.

how to change password to dts package programmatically?

Hi,

I was wondering if it is possible to change the password on a SQL Server 2000 DTS package programatically instead of just
manually using the the interface?

I have over 150 DTS packages used for building BI data cubes and our password policy requires a password change every 60 days.

I would like to write a windows vb.net application that loops through all the DTS packages and changes the password.

Please advise.

Thanks

Chris

This is just an analysis...not an answer.

If you develop a program that loops through each dts package and changes the pwd then you must have to put the pwd into a file, which kind of defeats security.

My suggestion is to remove the policy for changing pwds on DTS packages and control security at a higher level in SQL Server.

|||

I was going to have the password be entered via a password text box by the user.

Is this even possible?

Thanks

Chris

how to change password

We have change administrator password. How can i change the sql server job password, so that the maintain plan work fine as before. Thanks.Modify the login used by the SQL Server Agent service.|||Thank you very much! So i just right click the sql server agent then change password there.|||Right-click the service, open up properties, and go to the Logon tab. That is the most likely culprit.|||i am a little bit confuse. What i did is go to sql server enterprise manager, the expand the management, then right click the sql server agent to open properties. then change the password there. But i am sure what service you got, where can i find it? Did i did something wrong. Can you give me more detail about changing the password? Thank you very much!

How to change a local DTS package's owner or how to open a password protected package.

Hi,
In our database server (SQL Server 7.0), there are some local DTS packages,
all were password protected, and we don't know the password, the one who
create them has left the company.
And now, we want to modify them, how to do?
Thanks
FrankLocal packages are held in the msdb database table sysdtspackages. By doing a
simple "SELECT * FROM sysdtspackages" you can see the owner for each package.
Whilst you could probably use a simple UPDATE statement to change the owner,
there is an undocumented stored procedure, that appears to be purpose written
for this task, sp_reassign_dtspackageowner :
sp_reassign_dtspackageowner [@.name =] 'name',
[@.id =] 'id',
[@.newloginname =] 'newloginname'
[@.name =] 'name'
The package name.
[@.id =] 'id'
This is the uniqueidentifier for the package. A name may not necessarily be
unique.
[@.newloginname =] 'newloginname'
The new Owner name. SQL Server login example 'sa', NT Integrated example
'Domain\Username'
If you look at sp_reassign_dtspackageowner you'll notice that it not only
updates the owner text field, but it also updates the owner_sid field.
"Frank" wrote:
> Hi,
> In our database server (SQL Server 7.0), there are some local DTS packages,
> all were password protected, and we don't know the password, the one who
> create them has left the company.
> And now, we want to modify them, how to do?
> Thanks
> Frank
>
>

How to change "sa" password after installation?

I just installed MS SQL SERVER2000, but seems the password I was setting didn't look good. So I want to change it, but how? Thanks!run stored procedure using account with sysadmin role priveleges

sp_password @.new = 'newprd' , @.loginame = 'sa'

ask if you have any questions|||run stored procedure using account with sysadmin role priveleges

sp_password @.new = 'newprd' , @.loginame = 'sa'

ask if you have any questions

I've figured it out, thanks!