CRM Questions

I am looking for answers to two questions. Any answers or directions
to potential answers would be appreciated!

1.) Where does Microsoft CRM store custom html docs/files I create. I
am guessing in the SQL server but am not certain where.

2.) One admin changed the permissions on some IIS subdirectories and
now the Small Business Server Monitor and Reporting doesn't send out
email messages any more. Any thoughts on how to reset back to the
basic permissions?

Thanks in advance!

(Sorry I had accidentally posted it as a reply earlier...)

RonaldL
Wed Oct 20 02:47:07 CDT 2004

1)
Crm does not create custom html docs/files. The page is created by the crm
server based on the information which is in dll files, aspx files, xls files
and databases. The fields you add or modify in the settings page, they are
stored first in the database CLIENTNAME_CRM_MSCRM table OrganisationUIBase
(FieldXml), after publishing in the xls file in the
c:\wwwroot\inetpub\_xlsfiles folder and the CLIENTNAME_CRM_METABASE database.

the second question I cannot answer. you might want to ask that in another
group.1

Ronald Lemmen
Avanade Netherlands
"TheWakingMind" wrote:

> I am looking for answers to two questions. Any answers or directions
> to potential answers would be appreciated!
>
> 1.) Where does Microsoft CRM store custom html docs/files I create. I
> am guessing in the SQL server but am not certain where.
>
> 2.) One admin changed the permissions on some IIS subdirectories and
> now the Small Business Server Monitor and Reporting doesn't send out
> email messages any more. Any thoughts on how to reset back to the
> basic permissions?
>
> Thanks in advance!
>
> (Sorry I had accidentally posted it as a reply earlier...)
>

thewakingmind
Thu Oct 28 14:16:35 CDT 2004

thewakingmind@hotmail.com (TheWakingMind) wrote in message news:<92d69e3b.0410192110.db14355@posting.google.com>...
> I am looking for answers to two questions. Any answers or directions
> to potential answers would be appreciated!
>
> 1.) Where does Microsoft CRM store custom html docs/files I create. I
> am guessing in the SQL server but am not certain where.
>
> 2.) One admin changed the permissions on some IIS subdirectories and
> now the Small Business Server Monitor and Reporting doesn't send out
> email messages any more. Any thoughts on how to reset back to the
> basic permissions?
>
> Thanks in advance!
>
> (Sorry I had accidentally posted it as a reply earlier...)

----------------------
Dear All:
Thanks for getting back to me. I asked my client if that answered his
question and his response was:
"Unfortunately the answer provided by the specialist doesn't answer my
question. It appears she believes I am trying to change the CRM Pages
themselves (the table she referenced holds data/xml references to
pages, not the email templates). This is incorrect.

First, let me clarify what it is I am doing:
I am utilizing the Email Templates differently then intended.
Instead of simply using text, I design pages in HTML in another
program, publish them to IE, and then copy and paste them into the
Email Template system. This has worked, but I'd like to modify the
HTML directly once in the template.

What I've done to find this HTML: I searched all dlls, aspx, xls files
(which can all be searched by text) found on my c:\ drive for text in
the emails. I found nothing. This lead me to conclusion the HTML was
being stored in a database field somewhere.

A few diagnostic questions:
1) Where are Email Templates or their references stored in the
database?
2) How are they stored?"

Any follow-up thoughts?

Thanks in advance!