Finding credientials to connect to RS database -- sql server reporting services

Scott M
4/10/2006 11:50:43 AM

First of all sorry that the message is so skatty. I have a lot on my plate
right now :)

When I installed our instance of Reporting Services on our report box I
cannot remember if I rsactivate-ed and rsconfig-ed the installation with a
windows user or a DB user. I need to know b/c we recently changed an
account that I believe the RS is running under (To impersonate) I think
it's happening because all my jobs have "Login failed" as the status.

Is there a was to decrypt the XML values in the config files using the keys
in the DB so I can tell what credentials everything is running with? Or is
there some way I can easily get the user that is being impersonated to
connect to the RS database?

Thanks
Scott

Scott M
4/10/2006 4:52:10 PM

For 2000

It's all encrypted

[quoted text, click to view]

weilu NO[at]SPAM online.microsoft.com
4/11/2006 5:47:16 AM

Hi Scott,

Welcome to use MSDN managed newsgroup Support and thanks Stas's help.

In Reporting Services 2000, I don't think you can get the credential used
to connect to the RS database directly for the security issue.

I would like to know why you need to know this user. In the ReportServer
database, you may check what users are there in this database.

Also, you may post what the exactly error message you get when you run your
jobs.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Scott M
4/21/2006 11:11:12 AM

We changed a password to a security account on our network and reports were
not being delivered through subscriptions. I started poking around and used
either rsactivate of rsconfiig to re-assign the user that unattended
operations ran under.

Thanks for everyone's help.
[quoted text, click to view]

weilu NO[at]SPAM online.microsoft.com
4/24/2006 5:36:50 AM

Hi Scott,

Thanks for the update.

I think the root cause of the Login Fail is the credential you use to
connect to the datasource in the Report is not available. So you may try to
change this credential.

To change the credential stored in the data source, please do the following:

1. Find the datasource your report use in the Report Manager.

2. In the Properties Tab, General section, please change the Connect Using
Section.

Hope this will be helpful.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

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 about sql server reporting services

sql server reporting services : Finding credientials to connect to RS database