SMS 2003 Reporting function connect to another database

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dear all,

Is it possable to using the SMS 2003 reporting tools to generate a report
which the data from another database ?

I creat the report with the SQL statment :

"Select * from CustomerDB..Table1"

An error message appear:
"An error occurred when the report was run. The details are as follows:
Server user 'NT AUTHORITY\SYSTEM' is not a valid user in database 'ACS'.
Error Number: -2147467259
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 916 "

When I creat the report with the SQL statment connect to master DB , it can
be success:

"Select * from master..sysfiles"

Any Advices?

Many Thanks.

BR,
Rex


.

Relevant Pages

  • RE: updated numbers in report
    ... for making an input to the database. ... textbox will be located alongside with the combobox where the belonging ... belonging query for the report. ... ElapsedTime([Date First Time Onboard], ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Creating a report entirely through code
    ... In my case this is a very simple database, ... >> thus greatly increase the probability of corruption. ... >> button doesn't gray out after a compile, a control starts to ... >>>report and not a form where they have to enter data in. ...
    (microsoft.public.access.formscoding)
  • Re: Creating Access DB
    ... database and in the SQL database that your report needs. ... click the query tab. ...
    (microsoft.public.excel.programming)
  • Re: MSSQL$SBSMonitoring Database size (SBS2003)
    ... You can use the SQL Client Utilities to try and shrink the database. ... to delete over 90 day old information from the monitoring ... The server will start to collect new counter value ... Check 'View the usage report in Server Management' option. ...
    (microsoft.public.windows.server.sbs)
  • Re: Suggestion
    ... Datamarts allow you to create summarized data and improve the query response ... You have to choose the better source regarding the report you have to ... Detailed information can query your OLTP data sources. ... >> Keeping the historical vs. current data partitioned by database is ...
    (microsoft.public.sqlserver.datawarehouse)