| Groups | Blog | Home |
sql server reporting services : (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. [quoted text, click to view] "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. [quoted text, click to view] "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 [quoted text, click to view] "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'. >> > > >
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!!!! [quoted text, click to view] "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. [quoted text, click to view] "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? [quoted text, click to view] "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? [quoted text, click to view] "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 [quoted text, click to view] "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'. > >> > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |