Pages

Search

Microsoft CRM - What's the SQLServerAgent Role?

Microsoft CRM - What's the SQLServerAgent Role?

What's the SQLServerAgent Role?

Posted: 02 May 2005 12:31 AM PDT

Nidal,

Besides the things KjellSJ wrote, there are also some SQL jobs: Close Past
Appointment and Update Contract States.

Rob Bakkers,
Avanade Netherlands


"Nidal Salah" wrote:
 

can't access web or crm manager

Posted: 01 May 2005 07:12 PM PDT

Yes you should be able to use the application without exchange and the email
router. Could you check your eventviewer (application) and copy paste the
error that is given by the Microsoft CRM application?

--
Rob Bakkers,
Avanade Netherlands


"Pedro" wrote:
 

Problems with Crystal Reports - Urgent

Posted: 01 May 2005 08:28 AM PDT

what OS are your domain controllers running?

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"i3Q" <microsoft.com> wrote in message
news:com... 
information 
then 
the 
server 
message 
we 
not be 
displaying 
setup 

crystal reports logon error when redployed into new box

Posted: 01 May 2005 05:57 AM PDT

John

Thank you for your Advice, I have tried resetting all the crystal services
using crystal configuration and then tried reset of IIS. But there is no
change , it is still giving me the same error when try to access crystal
reports.

Any new suggestions or solutions are highly appreciated.

Thanks in advance.

Ravi chander


"John O'Donnell" <com-nospam> wrote in
message news:e$R#phx.gbl... 
eporting 
reports, 

Step by step data migration - is it possible?

Posted: 01 May 2005 03:38 AM PDT

John,

i guess the sequence is:

1. create all the fields in crm
2. create cdf tables
3. move all the data to cdf tables
4. cleanse the data of the one particular territory (about 10% of all)
5. move it to crm
6. start working with it
7. goto 4

I mean, can we move only part of the data at a time from cdf to crm,
and immediately start working with it (editing, creating new records,
etc)? I want to have these two processes run in parallel (working with
data already moved to crm and cleansing next portion of data in cdf).

i haven't found anything about this approach in DMF guide.

thanks!

Exporting\Storing Information to Sharepoint

Posted: 29 Apr 2005 04:20 PM PDT

We have written several web parts that uses the MSCRM SDK to retrieve and
modify data in MSCRM. Each SharePoint team-site contains the GUID of the
MSCRM entity that the site refers to, and the web parts uses this GUID in all
MSCRM operations. Keep the GUID in a web part property or as a team-site
property shared between all web parts in a team-site.

Our web parts are actually written as ASP.NET user controls hosted in
SmartPart (www.smartpart.info).

If the team-site members are not MSCRM users, you will need to implement
impersonation in you business logic before calling any MSCRM SDK methods.

KjellSJ
http://kjellsj.blogspot.com


"John O'Donnell" wrote:
 

3rd party databases

Posted: 29 Apr 2005 09:30 AM PDT

Hi,

What I have done in an earlier project is to create a report using Crystal
Reports. Then use the Crystal viewer and license that came with Visual Studio
2003 because we already used that to develop the webpages. I don't know if
this is an option for you, but just giving you an other option.

--
Rob Bakkers,
Avanade Netherlands


"The Crystal Guy" wrote:
 

importing a product list/catalog

Posted: 29 Apr 2005 09:10 AM PDT

I have written ongoing loads of product data from a feed. unless you are wiling
to purchase a product like Scribe, you will need to develop this yourself using
the SDK calls.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 29 Apr 2005 20:27:12 -0700, "FiMA" <microsoft.com>
wrote:

Thanks John.

I've started to work with the Data Migration Framework (DMF). Unfortunately
I'm realizing that even this solution isn't going to be what I want. From
what I'm reading it looks like DMF is used to migrate data on a one-time
basis. I'm interested in updating the SQL tables on a daily or weekly basis
- and it doesn't look like DMF supports this. I'm *very* rusty with my SQL
and relational database skills but I'm thinking I'm going to have to delete
the tables that hold my product information and recreate them to perform
updates. In other words, I'm going to have to perform DMF migrations
everytime I want to perform updates. Does anyone know if this is even
possible?

These products I'm trying to import are from a set of DBF files our
distributor makes available to their customers. The other solution the
distributor offers is an XML API to connect to their product database - then
I'm guessing that I would have to use ODBC? or something similar to connect
to the SQL database and update the products that way. This is essentially
writing directly to the SQL tables, which I think I remember reading is not
recommended?

Has anyone done anything like this? Maybe a better question is - Is anyone
even on the same page with me here? I'm trying to avoid having to re-invent
the wheel if at all possible.

Thanks for all of your help in advance.

Fima Leshinsky
NetXperts, Inc.
www.netxperts.com

"John O'Donnell" wrote:
 

Email router problems

Posted: 29 Apr 2005 09:05 AM PDT

Dear Sigurdur,

Have you set the CRMEmailEnabled customattribute in Active Directory? This
is needed for the CRM Email Router to be able to store the incomming emails
in the CRM system.

Also make sure the Email Router is installed on the Exchange Server which
handles the emails for that users. If you have serveral Exchange servers you
have to install all the CRM Router on all of those servers.

If you do not want to install it on all the servers you could create a Front
End Exchange server which handles a different SMTP subdomain and thus handles
specific CRM users.

More information on these settings like CRMEmailEnabled and the SMTP
subdomains can be found in the Implementation Guide and some articles on
msdn.microsoft.com website.

I hope this helps,
Rob Bakkers,
Avanade


"Sigurdur Hilmarsson" wrote:
 

Form template change, not being reflected

Posted: 29 Apr 2005 08:23 AM PDT

They finally showed up. After another publish and IISRESET, I purged my
browser cache, and there they were.

One other question, however, can the import wizard be changed to reflect
these new values? They're not showing in there...

Thanks for you help.

DG

Adam DeLaney wrote: 

Adventure Works licenses question

Posted: 29 Apr 2005 06:11 AM PDT

Thanks for your answer,

Pb is that my key is linked to the business name I have registered...then I
cannot use it with Adventure Works Cycle...

It seems I'll have to live with my 15 user licenses :-)

Thanks for your help
Eric


"Adam DeLaney" <microsoft.com> wrote in message
news:com... 

Adding licenses for Action Pack users

Posted: 28 Apr 2005 05:48 PM PDT

When you installed it was your companies name used for the organization name
in the install. To my knowledge the action pack media is no different. If
you used Adventrue Works or MSDN Subscriber or some specific Action Pack name
for the org you will have issues. If it is under your org name you shouldn't
have a problem calling MBS and ordering more licenses. I would submit a
question to MBS off their site if you are still unsure.

"Guy Kerr" wrote:
 

ActiveX Security settings and XP Home

Posted: 28 Apr 2005 02:14 PM PDT

XP home cannot participate in a domain


"John O'Donnell" <com-nospam> wrote in
message news:phx.gbl... 

CRM Website

Posted: 28 Apr 2005 11:10 AM PDT

Hey Nathan,

I had already set the permissions for internet explorer. That would work
once, but doesn't seem to work twice.

I now have another problem, I thought that if I restart the server that
might clear up some problems, but now it either can't find the page, I'm not
authorized to view the page, It doesn't do anything be say it's connecting to
the server, or CRM is not running. and that last one is a different issue,
and I'm working on that one trying to get things started again.

Thanks

Everett



"Nathan Warner" wrote:
 

Team as a owner of Account and Contact?

Posted: 28 Apr 2005 09:23 AM PDT

Actually Teams can own a record, The application currently does not
support assigning records to teams but through the API you can assign a
record to a team. We are doing this in our implementation. The
corresponding record in the table is 'owningteamid'

Look at SDK for the appropriate call to make


Adam