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 Graphs in access on a click of a button

I need to create graphs in access in a lick of a button all the data will be in the sql transfered from the access.

If anybody did this before ar having Idea please let me know

It's not too difficult to do this because there is lots of Wizard help. First create a linked table to the SQL Server table from your Access database. Then use the Form Wizard or Report Wizard to create a chart using the linked table as the source of data.|||

hey taht was a really neat answer I havent tried it but as I am a begginer I may need help I will post further if I need any help

Thanks,

|||

may I know where can I find the report wizard in sql

|||I was talking about the Report Wizard in Microsoft Access. SQL Server does not have a report wizard. For SQL Server, you want to investigate installing SQL Server Reporting Services, it will let you create very nice reports inside Visual Studio against SQL Server.

creating DDL from a temporary table

I need to write a DDL Create script for a table in TempDb.
In Query Analyzer, I can see the table, but when I right click on the table
and attempt to script the Create I get a message telling that it could not
find the object in the collection (and it suggests I may want to use
qualifiers).
In Enterprise Manager, I can not see any user talbes in TempDb.
How do I get the scripts, ie, the DDL Create syntax...besides writing it
myself.
I have about 30 views which need to be changed to tables
Thaniks
Materialize the table, then script it:
Select * INTO SomeMaterializedTable
From #YourTempTable
Where 1= 2 --To have no rows, only the structure
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Abroit" wrote:

> I need to write a DDL Create script for a table in TempDb.
> In Query Analyzer, I can see the table, but when I right click on the table
> and attempt to script the Create I get a message telling that it could not
> find the object in the collection (and it suggests I may want to use
> qualifiers).
> In Enterprise Manager, I can not see any user talbes in TempDb.
> How do I get the scripts, ie, the DDL Create syntax...besides writing it
> myself.
> I have about 30 views which need to be changed to tables
> Thaniks

creating DDL from a temporary table

I need to write a DDL Create script for a table in TempDb.
In Query Analyzer, I can see the table, but when I right click on the table
and attempt to script the Create I get a message telling that it could not
find the object in the collection (and it suggests I may want to use
qualifiers).
In Enterprise Manager, I can not see any user talbes in TempDb.
How do I get the scripts, ie, the DDL Create syntax...besides writing it
myself.
I have about 30 views which need to be changed to tables
ThaniksMaterialize the table, then script it:
Select * INTO SomeMaterializedTable
From #YourTempTable
Where 1= 2 --To have no rows, only the structure
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Abroit" wrote:
> I need to write a DDL Create script for a table in TempDb.
> In Query Analyzer, I can see the table, but when I right click on the table
> and attempt to script the Create I get a message telling that it could not
> find the object in the collection (and it suggests I may want to use
> qualifiers).
> In Enterprise Manager, I can not see any user talbes in TempDb.
> How do I get the scripts, ie, the DDL Create syntax...besides writing it
> myself.
> I have about 30 views which need to be changed to tables
> Thaniks

creating DDL from a temporary table

I need to write a DDL Create script for a table in TempDb.
In Query Analyzer, I can see the table, but when I right click on the table
and attempt to script the Create I get a message telling that it could not
find the object in the collection (and it suggests I may want to use
qualifiers).
In Enterprise Manager, I can not see any user talbes in TempDb.
How do I get the scripts, ie, the DDL Create syntax...besides writing it
myself.
I have about 30 views which need to be changed to tables
ThaniksMaterialize the table, then script it:
Select * INTO SomeMaterializedTable
From #YourTempTable
Where 1= 2 --To have no rows, only the structure
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Abroit" wrote:

> I need to write a DDL Create script for a table in TempDb.
> In Query Analyzer, I can see the table, but when I right click on the tabl
e
> and attempt to script the Create I get a message telling that it could not
> find the object in the collection (and it suggests I may want to use
> qualifiers).
> In Enterprise Manager, I can not see any user talbes in TempDb.
> How do I get the scripts, ie, the DDL Create syntax...besides writing it
> myself.
> I have about 30 views which need to be changed to tables
> Thaniks