Rendering reports in report server

I am not able to get my rdl to display from the report folder on the report server where I uploaded it.

Since it was created using my local database I changed the properties to reflect that now it is in the sql 2005 database on DiscountASP.

I put in my new connection string: Data Source=tcp:sql2k511.discountasp.net;Initial Catalog=SQL2005_428011_database;
Also, I have tried different combinations of security for my credentials including putting it in the connection string, to no avail.
Using Windows Integrated Security I get the following when I try to render:

* An error has occurred during report processing.
o Cannot create a connection to data source 'master'.
+ Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Using Credentials stored securely in the report server I get:

* An error has occurred during report processing.
o Cannot create a connection to data source 'master'.
+ Login failed for user 'rs_428011'.

Using Credentials supplied by the user running the report and putting in my credentials I get:

* An error has occurred during report processing.
o Cannot create a connection to data source 'master'.
+ Login failed for user 'rs_428011'.

Any help is greatly appreciated.

 

Plight,

I found out tonight that the report is not looking for the Reporting Services U/P, but for the database U/P. It is trying to query the database for the information to feed to the report.

Try using your database U/P (Use SQL Authentication instead of Windows Authentication) and it should work ok.

Jamminjime

 

Hi Jamminjime

Yes - I found out the same thing through trial and error. Out of sheer frustration I tried my sql database credentials and it worked. I almost fell out of my chair. Good luck!

Philip