Reporting Services: Report Manager

I deployed my reports to<domain>/Reports/Pages/Folder.aspxand used a shared data source with connection string:

data source=mssqlXX.discountasp.net;initial catalog=db_XXXXXX_foobar

I then set "Credentials stored securely in the report server" with the RS username and password given to me when I added on the RS option.

If I run a report I get a connection error: Login failed for user 'rs_XXXXXX' probably because my database instance where the report data is located doesn't have that user. And I can't add the user because I don't have rights.

Is there some other way I'm supposed to configure RS here? Thanks in advance for any help.

James

 

Ok, got it. So here's the answer to my own question: set up a user in your SQL Server instance with db_datareader rights to use as a report account. Then go into your shared data source and set this user as credentials stored in report server. In your web.config file (or whereever you set the user/pwd credentials to the proxy) use the assigned rs_XXXXXX user that was assigned during setup.

Here's the end results: http://mynetstudio.web123.discountasp.net/(mynetstudio.com after DNS propagates). Logon as "demo" with pwd "demo" and choose "Reports" from the menu. Works like a champ.

James