ralf

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

lars norman sndergaard

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@discussions.microsoft.com> skrev i en meddelelse
news:08242531-7DAF-4C86-B5E9-522DFC9D849F@microsoft.com...