MAPI profil

Hi,
I try e-mail through SQL Server. I have Outlook 2000 installed, MAPI profile created. If I want test it, SQL Server displays this error:
Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
Can me sombody help, thanks.Hi
You need to login as the SQL Agent on the machine, configure outlook, log
off and re-start SQL Agent.
See the following KB article on exactly how to do it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&Product=sql2k
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Ondrik" <anonymous@.discussions.microsoft.com> wrote in message
news:80987291-A063-4B4A-BBDB-6DC363DD2849@.microsoft.com...
> Hi,
> I try e-mail through SQL Server. I have Outlook 2000 installed, MAPI
profile created. If I want test it, SQL Server displays this error:
> Error 18030: xp_test_mapi_profile : Either there is no default mail client
or the current mail client cannot fulfill the messaging request. Please run
Microsoft Outlook and set it as the default mail client.
> Can me sombody help, thanks.|||Hmmm, it is terrible. I have it so done. Same domain account for log on machine, SQL Server and SQL Agent. What mean in error message: "Please run Microsoft Outlook and set it as the default mail client." How? I don't want reinstall server.

Many-to-Many data

If you have ever ran across the same problem you will now what I am talking about.

The designer gave us a report to develop that displays many to many data. The traditional approach of hierarchal data reporting just will not work. Any ideas on hwo to display this data?

Here is a quick example:

Think of Musician to Albums. A musician can have many albums, and an album can have many musicians.

The report will list grouped by musician thier albums and the total sales, but when you sum up the sales it will be overstated because an album can have multiple artists. Also, if three artists contributed to the same album, it should list the three artists, then the one album, not artist/album X3.

So... what is the best approach to displayign this type of data on a report? We are stumped.

Thanks,
Eric

I was able to solve it. The trick was two have two seperate groups for Albums, then show/hide depending on conditions.