Reporting Services Error - Administrator Ok

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'.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.
"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
"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
"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
"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
"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
>>
>>
>