sql server reporting services: Unable to Connect After Admim PW Change -- sql server reporting services

Unable to Connect After Admim PW Change

Mike Harbinger
11/8/2004 10:47:27 PM

sql server reporting services:

The domain\Administrator PW was changed a few days ago and ever since the
ReportServer can no longer connect to its DB. When you first tried to reach
the site in the browser you got the following error:
-----------------------------------------------------------------------
The report server cannot open a connection to the report server database.
The logon failed. (rsReportServerDatabaseLogonFailed) GetOnline Help
<http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Reporting
Services.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsRe
portServerDatabaseLogonFailed&ProdName=Microsoft%20SQL%20Server%20Report
ing%20Services&ProdVer=8.00>
Logon failure: unknown user name or bad password.
-------------------------------------------------------------------------

I tried the following to force the replication of the new PW:
rsconfig -c -s ourmachinename -d ReportServer -a SQL -u
ourdomain\administrator -p ourpassword

and now I get the following error:

The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user 'ourdomain\administrator'.

*
-The ReportServer service starts up fine and logs in as the domain admin
-In the SQL Server setup screen I see the following
Authentication= SQL server and Windows
Startup Service Account= Sytem Account

Any help greatly appreciated!

RE: Unable to Connect After Admim PW Change

mresanchez
11/9/2004 7:55:03 AM

One last resource would be to run rskeymgmt & delete all of the encrypted
data & restart the services & see what happens. Again, not a pretty solution
but worth the effort if nothing else has worked.

Of couse, backup everything you have & then run it
rskeymgmt /?

to get more help.

[quoted text, click to view]

Re: Unable to Connect After Admim PW Change

Peter Blackburn (www.sqlreportingservices.net)
11/9/2004 11:15:51 PM

What you can do is change the Domain Administrator's password back to what
it was - do this directly on the same machine that it was changed on.

That should get your system working again.

Then use the RSKeyMangmnt utility to extract the symmetric key from a
working system.

At this point you can change the Administrator's password and reapply the
symmetric key using the RSKeyMangmnt.exe.

All of this said the concept of using the Domain Administrator account to
access the Report Server Database is not ideal - you'd really benefit from
reading our Chapter 2 and watching the 2.5GB of DVD video content that will
show you how to install and secure your system.

Peter Blackburn
Hitchhiker's Guide to SQL Server 2000 Reporting Services
http://www.sqlreportingservices.net

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.