(rsProcessingAborted) An error has occurred during report processi

I have the same error as Ricky when I tried to run my report on the browser.
The following is the error. Help would be greatly appreciated.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'ClientReg'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.if you are not using integrated authentication IIS uses the default user
account.
This user needs to be added into
http://localhost/Reports/Pages/Folder.aspx
Properties tab and add in a role assignment.
If you are using integrated authentication then you need to make sure the
domain user gets added. Or a group.
Read up on security and RS. I know it sucks but doing a little research up
front will save you all kinds of frustration down the road. If your working
with reporting services your going to need to get used to frustration, there
is a lot of it built right into the product.
"MissQti" wrote:
> I have the same error as Ricky when I tried to run my report on the browser.
> The following is the error. Help would be greatly appreciated.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'ClientReg'.
> (rsErrorOpeningConnection) Get Online Help
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
>|||whoops that's not going to help you at all you need to fix the data access
portion.
we use an explicate sql server user and password and store it in the
datasource.
if you use integrated authenticaion it should be easier but it's really a
matter of where you want to admin your user profiles/groups.
"letuce dance" wrote:
> if you are not using integrated authentication IIS uses the default user
> account.
> This user needs to be added into
> http://localhost/Reports/Pages/Folder.aspx
> Properties tab and add in a role assignment.
> If you are using integrated authentication then you need to make sure the
> domain user gets added. Or a group.
> Read up on security and RS. I know it sucks but doing a little research up
> front will save you all kinds of frustration down the road. If your working
> with reporting services your going to need to get used to frustration, there
> is a lot of it built right into the product.
> "MissQti" wrote:
> > I have the same error as Ricky when I tried to run my report on the browser.
> > The following is the error. Help would be greatly appreciated.
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'ClientReg'.
> > (rsErrorOpeningConnection) Get Online Help
> > Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> >|||After I added the Credentials stored securely in the RS everything is running.
I got the name of the fileds returned however there are no data returneds.
How come the fields value returned but no data. Please Help!!!!
"letuce dance" wrote:
> if you are not using integrated authentication IIS uses the default user
> account.
> This user needs to be added into
> http://localhost/Reports/Pages/Folder.aspx
> Properties tab and add in a role assignment.
> If you are using integrated authentication then you need to make sure the
> domain user gets added. Or a group.
> Read up on security and RS. I know it sucks but doing a little research up
> front will save you all kinds of frustration down the road. If your working
> with reporting services your going to need to get used to frustration, there
> is a lot of it built right into the product.
> "MissQti" wrote:
> > I have the same error as Ricky when I tried to run my report on the browser.
> > The following is the error. Help would be greatly appreciated.
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'ClientReg'.
> > (rsErrorOpeningConnection) Get Online Help
> > Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> >|||I have run reports that are thousands of pages long. 1200 rows is really not
a lot of data.
Not sure I can help you any further.
I sometimes will just create a junk report for testing stuff. Create a
simple report with just a single table and your dataset. Just spit stuff out
and do a sanity check. Reporting services is not the nicest or easiest tool
sometimes. I have had it loose it mind several times. I have deleted things
and re-added them into a report and magically they just start working again.
Itâ's frustrating but itâ's just the way things are.
"MissQti" wrote:
> YES--The stored procedured itself is working correctly when I ran it in Query
> Analyzer. As well as data returned on the Data Tab in RS. But when I hit on
> the Preview tab, the name of the fields returned but no data.
> The data returned approximately about 1200 records. Is there any special
> that I need to do with the table layout since it returned with big records
> number?
> I don't think it has to do with the table layout right?
>
> "letuce dance" wrote:
> > so if you run the query from another tool like sql query analyzer it returns
> > results?
> >
> > is it just a text query or a stored procedure?
> >
> > "MissQti" wrote:
> >
> > > After I added the Credentials stored securely in the RS everything is running.
> > > I got the name of the fileds returned however there are no data returneds.
> > >
> > > How come the fields value returned but no data. Please Help!!!!
> > >
> > >
> > > "letuce dance" wrote:
> > >
> > > > if you are not using integrated authentication IIS uses the default user
> > > > account.
> > > >
> > > > This user needs to be added into
> > > > http://localhost/Reports/Pages/Folder.aspx
> > > >
> > > > Properties tab and add in a role assignment.
> > > >
> > > > If you are using integrated authentication then you need to make sure the
> > > > domain user gets added. Or a group.
> > > >
> > > > Read up on security and RS. I know it sucks but doing a little research up
> > > > front will save you all kinds of frustration down the road. If your working
> > > > with reporting services your going to need to get used to frustration, there
> > > > is a lot of it built right into the product.
> > > >
> > > > "MissQti" wrote:
> > > >
> > > > > I have the same error as Ricky when I tried to run my report on the browser.
> > > > > The following is the error. Help would be greatly appreciated.
> > > > >
> > > > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > > > Online Help
> > > > > Cannot create a connection to data source 'ClientReg'.
> > > > > (rsErrorOpeningConnection) Get Online Help
> > > > > Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> > > > >|||so if you run the query from another tool like sql query analyzer it returns
results?
is it just a text query or a stored procedure?
"MissQti" wrote:
> After I added the Credentials stored securely in the RS everything is running.
> I got the name of the fileds returned however there are no data returneds.
> How come the fields value returned but no data. Please Help!!!!
>
> "letuce dance" wrote:
> > if you are not using integrated authentication IIS uses the default user
> > account.
> >
> > This user needs to be added into
> > http://localhost/Reports/Pages/Folder.aspx
> >
> > Properties tab and add in a role assignment.
> >
> > If you are using integrated authentication then you need to make sure the
> > domain user gets added. Or a group.
> >
> > Read up on security and RS. I know it sucks but doing a little research up
> > front will save you all kinds of frustration down the road. If your working
> > with reporting services your going to need to get used to frustration, there
> > is a lot of it built right into the product.
> >
> > "MissQti" wrote:
> >
> > > I have the same error as Ricky when I tried to run my report on the browser.
> > > The following is the error. Help would be greatly appreciated.
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > Cannot create a connection to data source 'ClientReg'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> > >|||YES--The stored procedured itself is working correctly when I ran it in Query
Analyzer. As well as data returned on the Data Tab in RS. But when I hit on
the Preview tab, the name of the fields returned but no data.
The data returned approximately about 1200 records. Is there any special
that I need to do with the table layout since it returned with big records
number?
I don't think it has to do with the table layout right?
"letuce dance" wrote:
> so if you run the query from another tool like sql query analyzer it returns
> results?
> is it just a text query or a stored procedure?
> "MissQti" wrote:
> > After I added the Credentials stored securely in the RS everything is running.
> > I got the name of the fileds returned however there are no data returneds.
> >
> > How come the fields value returned but no data. Please Help!!!!
> >
> >
> > "letuce dance" wrote:
> >
> > > if you are not using integrated authentication IIS uses the default user
> > > account.
> > >
> > > This user needs to be added into
> > > http://localhost/Reports/Pages/Folder.aspx
> > >
> > > Properties tab and add in a role assignment.
> > >
> > > If you are using integrated authentication then you need to make sure the
> > > domain user gets added. Or a group.
> > >
> > > Read up on security and RS. I know it sucks but doing a little research up
> > > front will save you all kinds of frustration down the road. If your working
> > > with reporting services your going to need to get used to frustration, there
> > > is a lot of it built right into the product.
> > >
> > > "MissQti" wrote:
> > >
> > > > I have the same error as Ricky when I tried to run my report on the browser.
> > > > The following is the error. Help would be greatly appreciated.
> > > >
> > > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > > Online Help
> > > > Cannot create a connection to data source 'ClientReg'.
> > > > (rsErrorOpeningConnection) Get Online Help
> > > > Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> > > >|||How are you showing the data? Did you put a table onto the report and then
drag and drop fields into the table?
Also, try first hard coding the parameters for the stored procedures and
make sure it all works. Then modify it to use query parameters. Be sure the
query parameters are mapped appropriately to the report parameters (click on
the ... in the data tab and go to the parameters tab).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MissQti" <MissQti@.discussions.microsoft.com> wrote in message
news:76A1B895-AEF2-4300-99A7-86297F5F701B@.microsoft.com...
> YES--The stored procedured itself is working correctly when I ran it in
> Query
> Analyzer. As well as data returned on the Data Tab in RS. But when I hit
> on
> the Preview tab, the name of the fields returned but no data.
> The data returned approximately about 1200 records. Is there any special
> that I need to do with the table layout since it returned with big records
> number?
> I don't think it has to do with the table layout right?
>
> "letuce dance" wrote:
>> so if you run the query from another tool like sql query analyzer it
>> returns
>> results?
>> is it just a text query or a stored procedure?
>> "MissQti" wrote:
>> > After I added the Credentials stored securely in the RS everything is
>> > running.
>> > I got the name of the fileds returned however there are no data
>> > returneds.
>> >
>> > How come the fields value returned but no data. Please Help!!!!
>> >
>> >
>> > "letuce dance" wrote:
>> >
>> > > if you are not using integrated authentication IIS uses the default
>> > > user
>> > > account.
>> > >
>> > > This user needs to be added into
>> > > http://localhost/Reports/Pages/Folder.aspx
>> > >
>> > > Properties tab and add in a role assignment.
>> > >
>> > > If you are using integrated authentication then you need to make sure
>> > > the
>> > > domain user gets added. Or a group.
>> > >
>> > > Read up on security and RS. I know it sucks but doing a little
>> > > research up
>> > > front will save you all kinds of frustration down the road. If your
>> > > working
>> > > with reporting services your going to need to get used to
>> > > frustration, there
>> > > is a lot of it built right into the product.
>> > >
>> > > "MissQti" wrote:
>> > >
>> > > > I have the same error as Ricky when I tried to run my report on the
>> > > > browser.
>> > > > The following is the error. Help would be greatly appreciated.
>> > > >
>> > > > An error has occurred during report processing.
>> > > > (rsProcessingAborted) Get
>> > > > Online Help
>> > > > Cannot create a connection to data source 'ClientReg'.
>> > > > (rsErrorOpeningConnection) Get Online Help
>> > > > Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
>> > > >|||I did put a table onto the report and then drag and drop fields into the table.
I solved the problem myself. RS still has glitch...
This is what I did to fix the problem
1. Deleted the Record Data Source
2. Created a totally new one
3. On my Data Tab, I selected the Stored Procedured name
4. Run the report and it worked great.
5. Did all the table layout on the Layout Tab
6. Hit the Preview Tab, still no data returned
7. This is what I did to fix the error....on the Data Tab
8. I hit the Refresh Fields button...the Parameters Reports showed extra
fields there...not sure why?
9. I have to deleted all the extra fields
10. Run the report again,
11. Then hit the Preview Tab, the data returned...Not sure why it did that.
Here is the article I was reading on to fix this problem, hope it will help
someone out there.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=136877
"Bruce L-C [MVP]" wrote:
> How are you showing the data? Did you put a table onto the report and then
> drag and drop fields into the table?
> Also, try first hard coding the parameters for the stored procedures and
> make sure it all works. Then modify it to use query parameters. Be sure the
> query parameters are mapped appropriately to the report parameters (click on
> the ... in the data tab and go to the parameters tab).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "MissQti" <MissQti@.discussions.microsoft.com> wrote in message
> news:76A1B895-AEF2-4300-99A7-86297F5F701B@.microsoft.com...
> > YES--The stored procedured itself is working correctly when I ran it in
> > Query
> > Analyzer. As well as data returned on the Data Tab in RS. But when I hit
> > on
> > the Preview tab, the name of the fields returned but no data.
> >
> > The data returned approximately about 1200 records. Is there any special
> > that I need to do with the table layout since it returned with big records
> > number?
> >
> > I don't think it has to do with the table layout right?
> >
> >
> > "letuce dance" wrote:
> >
> >> so if you run the query from another tool like sql query analyzer it
> >> returns
> >> results?
> >>
> >> is it just a text query or a stored procedure?
> >>
> >> "MissQti" wrote:
> >>
> >> > After I added the Credentials stored securely in the RS everything is
> >> > running.
> >> > I got the name of the fileds returned however there are no data
> >> > returneds.
> >> >
> >> > How come the fields value returned but no data. Please Help!!!!
> >> >
> >> >
> >> > "letuce dance" wrote:
> >> >
> >> > > if you are not using integrated authentication IIS uses the default
> >> > > user
> >> > > account.
> >> > >
> >> > > This user needs to be added into
> >> > > http://localhost/Reports/Pages/Folder.aspx
> >> > >
> >> > > Properties tab and add in a role assignment.
> >> > >
> >> > > If you are using integrated authentication then you need to make sure
> >> > > the
> >> > > domain user gets added. Or a group.
> >> > >
> >> > > Read up on security and RS. I know it sucks but doing a little
> >> > > research up
> >> > > front will save you all kinds of frustration down the road. If your
> >> > > working
> >> > > with reporting services your going to need to get used to
> >> > > frustration, there
> >> > > is a lot of it built right into the product.
> >> > >
> >> > > "MissQti" wrote:
> >> > >
> >> > > > I have the same error as Ricky when I tried to run my report on the
> >> > > > browser.
> >> > > > The following is the error. Help would be greatly appreciated.
> >> > > >
> >> > > > An error has occurred during report processing.
> >> > > > (rsProcessingAborted) Get
> >> > > > Online Help
> >> > > > Cannot create a connection to data source 'ClientReg'.
> >> > > > (rsErrorOpeningConnection) Get Online Help
> >> > > > Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> >> > > >
>
>