Re: SMS 2003 Reporting function connect to another database

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

Finally I can you the SMS reporting tools to connect another database in the
same SQL server.

The procedures as follow:
1, Create the Database
2, Add the guest account to this database without grant any access
right(same as Northwind database)
3, In SMS report module create the report with SQL statement "Select * from
newDB..Table1"

Regards,
Rex


<amarok.spam@xxxxxxxxx> wrote in message
news:1144677808.891298.227490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Rex,



If you have the answer please share:)

I'm struggling with the same thing..



Rex írta:
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: PRIMARY filegroup is full - no its not!
    ... Consider using sp_helpfile to report the sizes. ... Columnist, SQL Server Professional ... "Dan Guzman" wrote in message ... > large file size after I expand the file using "ALTER DATABASE DataLoad ...
    (microsoft.public.sqlserver.server)
  • Re: need access to read to SQL db and Access frontend
    ... Does the documenter product a report and you just can't print it or is the ... tool tip with the path to the source database or DSN for the ODBC ... If the tables are linked to a SQL Server database or even another Access ... separate module/entity from dbA and doesn't need to be related but I ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Nearest Common Ancestor Report (XDb1s $1000 Challenge)
    ... >the report via SQL Server's Query Analyzer? ... Issue asynchronous command to save RAM table to HD. ... There is no such thing as a "RAM table" in MS SQL ... documantation of SQL Server, avaialble on the CD but can be browsed ...
    (comp.object)
  • Re: Moving from MS Access to Visual Basic.Net
    ... Thanks for the valuable professional input. ... Access/VBA as a front end,to VB6 Front end with SQL Server backend etc.. ... database is used in California and in Florida. ... Report as the report writer and Access as the ...
    (microsoft.public.dotnet.general)
  • Re: ldb file and Exclusive Access question
    ... Excel to report it. ... schedulable SQL server package. ... first db fro the 1st report I wanted to schedule. ... >database, the probability of database corruption is significantly increased. ...
    (comp.databases.ms-access)