|
|
You're in the
sql server reporting services
group:Reporting Services Error - Administrator Ok
sql server reporting services:
not process any reports, only the Administrator can. Using SQL Server 2000 Standard, IIS 6, and Windows Server 2003. Any assistance is appreciated. Fabian Here is the error message: Reporting Services Error -------------------------------------------------------------------------------- a.. An error has occurred during report processing. (rsProcessingAborted) Get Online Help a.. Cannot create a connection to data source 'Data Mining'. (rsErrorOpeningConnection) Get Online Help a.. Login failed for user 'TESTSERVER\test'.
I re-installed reporting services using the domain user account instead of
the built-in account, but the problem is still there. Only the Administrator can generate the reports. Any ideas how to fix this? Thanks. [quoted text, click to view] "Fabian Cevallos" <fcevallos@bellsouth.net> wrote in message news:%23GJGffh9FHA.632@TK2MSFTNGP10.phx.gbl... >I am having problems setting up RS 2000. The problem is that the users can >not process any reports, only the Administrator can. Using SQL Server 2000 >Standard, IIS 6, and Windows Server 2003. Any assistance is appreciated. > > > > Fabian > > Here is the error message: > Reporting Services Error > -------------------------------------------------------------------------------- > > a.. An error has occurred during report processing. (rsProcessingAborted) > Get Online Help > a.. Cannot create a connection to data source 'Data Mining'. > (rsErrorOpeningConnection) Get Online Help > a.. Login failed for user 'TESTSERVER\test'. > >
Check the credentials of the data source you're using ('Data Mining').
If you're passing the logged on user's credentials against your datasource, it might not have the correct permissions. The Administrator account probably has the right permission rights on your source 'Data mining', but the Test account doesn't. Either set your data source credentials to a static user accout, and verify that this account has read access to the data, or give the users read access to the data. (Depends on what you want to show.) Kaisa M. Lindahl
Thanks Kaisa,
Almost there! I gave the users read access to the database and now they can generate reports. However, they have to login twice. This works fine on the local machine. Is this a configuration issue? By the way, I am using a fully qualified domain name in the RSWebApplication.config file. How can you prevent the login prompt from appearing the second time? Fabian [quoted text, click to view] "Kaisa M. Lindahl" <kaisaml@hotmail.com> wrote in message news:1133470857.227925.212540@g44g2000cwa.googlegroups.com... > Check the credentials of the data source you're using ('Data Mining'). > If you're passing the logged on user's credentials against your > datasource, it might not have the correct permissions. The > Administrator account probably has the right permission rights on your > source 'Data mining', but the Test account doesn't. > > Either set your data source credentials to a static user accout, and > verify that this account has read access to the data, or give the users > read access to the data. (Depends on what you want to show.) > > Kaisa M. Lindahl >
I tried all sort of things with no luck. Any idea on how to "synchronize"
the login so there is no second prompt for username and password. Thanks Fabian [quoted text, click to view] "Fabian Cevallos" <fcevallos@bellsouth.net> wrote in message news:eDBfxXs9FHA.952@TK2MSFTNGP12.phx.gbl... > Thanks Kaisa, > > Almost there! > > I gave the users read access to the database and now they can generate > reports. However, they have to login twice. This works fine on the local > machine. Is this a configuration issue? By the way, I am using a fully > qualified domain name in the RSWebApplication.config file. How can you > prevent the login prompt from appearing the second time? > > Fabian > > "Kaisa M. Lindahl" <kaisaml@hotmail.com> wrote in message > news:1133470857.227925.212540@g44g2000cwa.googlegroups.com... >> Check the credentials of the data source you're using ('Data Mining'). >> If you're passing the logged on user's credentials against your >> datasource, it might not have the correct permissions. The >> Administrator account probably has the right permission rights on your >> source 'Data mining', but the Test account doesn't. >> >> Either set your data source credentials to a static user accout, and >> verify that this account has read access to the data, or give the users >> read access to the data. (Depends on what you want to show.) >> >> Kaisa M. Lindahl >> > >
This what I found out so far:
1) using the following URL works properly: http://www.mywebsite.com/Reports/Pages/Folder.aspx 2) http://www.mywebsite.com/Reports doesn't work properly. It prompts for a second login window 3) using http://www.mywebsite.com/Reports in the local machine works properly 4) http://localhost/Reports in the local machine works. However, it lets me in the Reporting Services area without username/password, but it asks for username/password to generate a report Any suggestions on what might be happening? Thanks. Fabian [quoted text, click to view] "Fabian Cevallos" <fcevallos@bellsouth.net> wrote in message news:uUxKAi49FHA.912@TK2MSFTNGP11.phx.gbl... >I tried all sort of things with no luck. Any idea on how to "synchronize" >the login so there is no second prompt for username and password. Thanks > > Fabian > > "Fabian Cevallos" <fcevallos@bellsouth.net> wrote in message > news:eDBfxXs9FHA.952@TK2MSFTNGP12.phx.gbl... >> Thanks Kaisa, >> >> Almost there! >> >> I gave the users read access to the database and now they can generate >> reports. However, they have to login twice. This works fine on the >> local machine. Is this a configuration issue? By the way, I am using a >> fully qualified domain name in the RSWebApplication.config file. How can >> you prevent the login prompt from appearing the second time? >> >> Fabian >> >> "Kaisa M. Lindahl" <kaisaml@hotmail.com> wrote in message >> news:1133470857.227925.212540@g44g2000cwa.googlegroups.com... >>> Check the credentials of the data source you're using ('Data Mining'). >>> If you're passing the logged on user's credentials against your >>> datasource, it might not have the correct permissions. The >>> Administrator account probably has the right permission rights on your >>> source 'Data mining', but the Test account doesn't. >>> >>> Either set your data source credentials to a static user accout, and >>> verify that this account has read access to the data, or give the users >>> read access to the data. (Depends on what you want to show.) >>> >>> Kaisa M. Lindahl >>> >> >> > >
Not sure what happened here, but everything seems to be working. Self
healing system :-) Fabian [quoted text, click to view] "Fabian Cevallos" <fcevallos@bellsouth.net> wrote in message news:eYBQGi79FHA.3884@TK2MSFTNGP10.phx.gbl... > This what I found out so far: > > 1) using the following URL works properly: > http://www.mywebsite.com/Reports/Pages/Folder.aspx > 2) http://www.mywebsite.com/Reports doesn't work properly. It prompts for > a second login window > 3) using http://www.mywebsite.com/Reports in the local machine works > properly > 4) http://localhost/Reports in the local machine works. However, it lets > me in the Reporting Services area without username/password, but it asks > for username/password to generate a report > > Any suggestions on what might be happening? Thanks. > > Fabian > > "Fabian Cevallos" <fcevallos@bellsouth.net> wrote in message > news:uUxKAi49FHA.912@TK2MSFTNGP11.phx.gbl... >>I tried all sort of things with no luck. Any idea on how to "synchronize" >>the login so there is no second prompt for username and password. Thanks >> >> Fabian >> >> "Fabian Cevallos" <fcevallos@bellsouth.net> wrote in message >> news:eDBfxXs9FHA.952@TK2MSFTNGP12.phx.gbl... >>> Thanks Kaisa, >>> >>> Almost there! >>> >>> I gave the users read access to the database and now they can generate >>> reports. However, they have to login twice. This works fine on the >>> local machine. Is this a configuration issue? By the way, I am using a >>> fully qualified domain name in the RSWebApplication.config file. How >>> can you prevent the login prompt from appearing the second time? >>> >>> Fabian >>> >>> "Kaisa M. Lindahl" <kaisaml@hotmail.com> wrote in message >>> news:1133470857.227925.212540@g44g2000cwa.googlegroups.com... >>>> Check the credentials of the data source you're using ('Data Mining'). >>>> If you're passing the logged on user's credentials against your >>>> datasource, it might not have the correct permissions. The >>>> Administrator account probably has the right permission rights on your >>>> source 'Data mining', but the Test account doesn't. >>>> >>>> Either set your data source credentials to a static user accout, and >>>> verify that this account has read access to the data, or give the users >>>> read access to the data. (Depends on what you want to show.) >>>> >>>> Kaisa M. Lindahl >>>> >>> >>> >> >> > >
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 |