Re: Resetting SA password for SQL Server 2000 Reporting Services

Re: Resetting SA password for SQL Server 2000 Reporting Services

 

  

I figured it out.

What I didn't want to do is perform some form of cascading change to SA
passwords along the DOMAIN.

FYI
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <password>

:)

Jon Brewer
SunGard Availability Services
MidRange DBA Group
(215) 446-1781



"Jon" <mssqldba-ezmlmshield-x74446000.[Email address protected]
03/31/2006 03:05 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Resetting SA password for SQL Server 2000 Reporting Services






Has anyone used the 'rsconfig' utility to reset the SA password on a
REPORTSERVER?

All I need is to reset an incorrect SA Password used during the
installation.

Would you happen to know the syntax to reset this?

rsconfig -c -m <REMOTECOMPUTERNAME> -s <SQLSERVERNAME> -d reportserver -a
SQL -u SA -p <SAPASSWORD>

Question: Do you need the REMOTECOMPUTERNAME and the SQLSERVERNAME to
reset the reportserver SA password?

Jon Brewer
SunGard Availability Services
MidRange DBA Group
(215) 446-1781


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page