Credentials

Hi,
if I open the report manager and click on a report to open it, under which credentials is the report genererated?
I have a developement computer on which I create my reports. Reporting service is installed on a developmentserver. I use an AS2k cube as a source and runs on another server. All servers are in the same domain. The reporting server service runs under a domain account with sufficient rights.
If I click on a report I get an error message saying that I don't have access rights to the analysis server cube. But if I run the report in preview mode it works fine.
I want to know which credentials are used when opening a report from the report manager.
Thanks.
QThat will depend on the data source for the report. If you have windows
integration set then it will be the current user accessing the site. You
will want to check on the properties tab of the report and the Data Sources
sub tab to see how the data source is set up.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Qbee" <Qbee@.discussions.microsoft.com> wrote in message
news:5E22D5C3-1240-4F9F-A5FF-5DAFB6FED081@.microsoft.com...
> Hi,
> if I open the report manager and click on a report to open it, under which
credentials is the report genererated?
> I have a developement computer on which I create my reports. Reporting
service is installed on a developmentserver. I use an AS2k cube as a source
and runs on another server. All servers are in the same domain. The
reporting server service runs under a domain account with sufficient rights.
> If I click on a report I get an error message saying that I don't have
access rights to the analysis server cube. But if I run the report in
preview mode it works fine.
> I want to know which credentials are used when opening a report from the
report manager.
> Thanks.
> Q|||I believe I read an online article about this. If your dev. computer is named devcpu, there should be a user defined as IUSR_devcpu with some password. This user's rights are assumed when a client access the report server anonymously. The delegation continues on to the AS machine.
Try creating a similar user/password on the AS machine.
--
R. Festino
Florida
"Qbee" wrote:
> Hi,
> if I open the report manager and click on a report to open it, under which credentials is the report genererated?
> I have a developement computer on which I create my reports. Reporting service is installed on a developmentserver. I use an AS2k cube as a source and runs on another server. All servers are in the same domain. The reporting server service runs under a domain account with sufficient rights.
> If I click on a report I get an error message saying that I don't have access rights to the analysis server cube. But if I run the report in preview mode it works fine.
> I want to know which credentials are used when opening a report from the report manager.
> Thanks.
> Q

Creating Linked Server issues

I have a Merge Replication Setup. With 3 computers. One computer acts has a central publisher. The 2nd one is a subscriber, and republishes its data to the 3rd computer. Every thing is being done using Windows Authentication method. the 1st PC has SQL SERVER 2000 (Enterprise Manager, the works). The other two are SQL Server MSDE (Rel. A). My process is up and running and works, but heres my issue.

I need to script the replication installation process out., For future installations on machines that will be located in remote parts of the world. The will reside on a secure DSL network.

Anyone familiar with Scripting Merge Replication knows that once you've run certain scripts/procedures on your subscriber, you have to run a final procedure on the publisher to activate or initiate the subscriber as a valid one, and the you can start the Merge Agent on the subscriber, and voila! you're good. The procdure you run is called sp_addmergesubscription . It goes something like this :

BEGIN
exec sp_addmergesubscription @.publication = @.publicationname, @.subscriber = @.servername, @.subscriber_db = @.Attachedbname, @.subscription_type = N'pull', @.subscriber_type = N'global', @.subscription_priority = 56.250000, @.sync_type = N'automatic'
END

My intention was to embed this system in a stored proc on the publisher and then call it remotely from the subscriber, before starting the Agent. IT FAILS!!! This is my proc:

Create Procedure RunSp_AM_subscription(@.servername Varchar(30), @.IAdbname Varchar(20), @.Attachedbname Varchar(20))
AS

DECLARE @.publicationname Varchar(30)
SET @.publicationname = 'REPUBLISH-'+@.IAdbname+''

BEGIN
exec sp_addmergesubscription @.publication = @.publicationname, @.subscriber = @.servername, @.subscriber_db = @.Attachedbname, @.subscription_type = N'pull', @.subscriber_type = N'global', @.subscription_priority = 56.250000, @.sync_type = N'automatic'
END

When I call it locally ot works fine, but not otherwise......... :eek:

When I try to create a linked server SQL Server seems to think that one already exists (because Replication has already created the said server as a remote server). I think the fact that I am not using SQL Authentication might be a problem too.

Does anyone have any ideas? I mean seriously, any suggestions on what to do. This is qute Urgent...........

Thanks.

'Walealso how would I even call the proc assuming I'm able to create the linked server.