Groups | Blog | Home
all groups > sql server reporting services > september 2004 >

sql server reporting services : Preview error


vmp_pdx
9/29/2004 3:03:02 PM
If you are using a shared data source, in solution explorer, double click on
the datasource file. Select the credentials tab. The problem is likely here.
If you are using SQL authentication, either enter a password or select the
option to prompt for a password. Let me know if this helps.

[quoted text, click to view]
Live_Love_Laugh
9/29/2004 5:17:53 PM
This is my first report. I used VS.NET 2003 wizard to create the report,
which consisted of a very simple select query report.
When I switch to preview tab in IDE, I am getting the following error.

Processing Errors:

An error has occurred during report processing.
Cannot create a connecttion to data source 'xxx'.
Login failed for user 'yy'

Any ideas of why this is happening? I looked at rdl file in notepad. The
credentials supplied during report creation is not stored in that file.

Please help ASAP.

Thanks,
Live_Love_Laugh

Live_Love_Laugh
9/30/2004 9:40:31 AM
I am not using a shared data source. On the data tab, I can see the tables
and my query. But when I switch to preview tab to fetch the data, it is
giving the error. Also on the data tab, I can run the query and see the
results.

Thanks,
Live_Love_Laugh

[quoted text, click to view]

Live_Love_Laugh
10/1/2004 5:21:19 PM
Can anybody help with this?

Thanks,
Live_Love_Laugh

[quoted text, click to view]

Lev Semenets [MSFT]
10/7/2004 9:32:05 AM
Could you email to me your RDL?

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


[quoted text, click to view]

AddThis Social Bookmark Button