Re: SMS 2003 report from different databases

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ralf,

Look at the rights assigned to the machine account in the SMS database and
give the same rights on other databases. Alternatively used linked
databases/tables.

You may however want to start using SQL Reporting Services instead. SQL RS
provides you with the ability to create much nicer looking reports and
offers a slew of interesting features.

Thanks
Lars Norman Søndergaard

"Ralf" <Ralf@xxxxxxxxxxxxxxxxxxxxxxxxx> skrev i en meddelelse
news:08242531-7DAF-4C86-B5E9-522DFC9D849F@xxxxxxxxxxxxxxxx
> Hello,
> is there a way to create a report which will query different databases on
> the SMS 2003 site server? I get the error message that the reporting point
> computer account is not a valid user in the other database. The reporting
> point server is not the same as the SMS site server.
>
> I have created these account in the database (not in the SMS db) but it is
> the same. I get the error.
>
> Can anyone help me.
>
> Thanks.
>
> Ralf
>


.

Relevant Pages

  • RE: Reporing service failure
    ... I understand that when you tried to configure your database for your SQL ... Server Reporting Services, you encountered the logon failure error. ... it was strange that the audit failure was for another user account NT ... And then configure your SSRS databases via Reporting Services Configuration ...
    (microsoft.public.sqlserver.security)
  • Re: Access SMS Issue
    ... I seem to recall that I needed to allow the 'SMS Reporting Users' ... Administrator Console with my admin account on the XP workstation until I ... Membership of the SMS Admins group is one that I know of, ...
    (microsoft.public.sms.admin)
  • SMS 2003 report from different databases
    ... I get the error message that the reporting point ... point server is not the same as the SMS site server. ... I have created these account in the database but it is ...
    (microsoft.public.sms.misc)
  • Re: Using my domain user name to view report?
    ... It sounds like your user account may not be in the SMS Reporting Users ... >> is the IE 6 security changes that may be an issue. ...
    (microsoft.public.sms.admin)
  • Re: Error on accessing web reporting
    ... The local Administrators group needs to have sa privileges to the SMS ... or reporting point functions will fail. ... Systems Management Server Group ... The details are as follows:> Cannot open database requested in login 'sms_012'. ...
    (microsoft.public.sms.setup)