Pages

Search

Microsoft CRM - Risk estimation for CRM load-balancing needed

Microsoft CRM - Risk estimation for CRM load-balancing needed

Risk estimation for CRM load-balancing needed

Posted: 11 Mar 2005 07:24 AM PST

Alfred,

I have received mixed answers on the "supported" issue with load balancing.
However, from what I understand, the "official" answer is it's supported from
the CRM side, but they aren't going to help you configure the farm. The key is
getting high enough up the support chain.

I know that there can be some issues with getting Crystal to work properly in a
farm, though it can be done.

If performance is the concern (vs. reliability), than I think they are better
off in just making sure both the SQL Server & the IIS/CRM server are good
machines. 320 users isn't that big, unless they have a huge amount of data per
user. I think there's a good chance they will be OK with the 2 server install
if the boxes are sized well.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 11 Mar 2005 16:24:16 +0100, "Alfred Göbel \(MS\)"
<com> wrote:

Hi all,

I have a very critical customer, who is aware of the fact that CRM 1.2 is
over its limit in is environment.

Shortly described as:
- 320 users
- a lot of changes with security roles
- CRM Server and SQL Server on one machine.

In the short term, the customer has been convinced that he has two split up
CRM and SQL Server on two separate boxes. In the long term he thinks about
the possibility in having CRM / IIS splitted up by Windows / Network
Loadbalancing.

It's not supported and the customer knows it as well.

But has anyone done this so far and can provide me a technical risk
estimation, what might not run, etc.?
Thank your for your help,


Alfred Göbel (MS)

(Microsoft kann für die Richtigkeit und Vollständigkeit der Inhalte in
dieser Newsgroup keine Haftung übernehmen.)

Question about query

Posted: 11 Mar 2005 01:52 AM PST

Thanks for reading the whole message Matt. Some days...

--
Mj Miller
Technical Lead
Microsoft CRM

This posting is provided "AS IS" with no warranties, and confers no rights.

"Matt Parks" <com> wrote in message
news:com... 

Web client

Posted: 10 Mar 2005 08:05 PM PST

I would try two things first: flush dns and register dns from the command
prompt.
(Start>Run, type cmd, type ipconfig /flsuhdns, press Enter, then type
ipconfig /registerdns, Enter). If this doesn't fix it, try running MS
Anti-Spyware and scanning the machines. I've seen this with a number of
clients who get spyware on their machines and their browsers won't resolve
intranet addresses.

Good luck
Matt Wittemann
http://icu-mscrm.blogspot.com


"Nathan Warner" wrote:
 

adding a schema into CRM

Posted: 10 Mar 2005 05:12 PM PST

Actually, it depends on the fields being added. If you have already added about
10 fields and each was a string of length 50, then you are extremely close to
the limit on the Contact table. Each 50 character string field will take up 100
bytes of the 8k limit as the product ships with close to 7k already used on that
table.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 11 Mar 2005 10:24:35 +0000, JB <else> wrote:

On Thu, 10 Mar 2005 17:12:02 -0800, "Sansanee" <com>
wrote:
 

There are limits on the schema fields added. These are, if memory
serves correctly which it probably doesn't, that the total length of
the attributes for fields in a table can not exceed 8192 bytes,
ie SQL only allows 8k to describe the fields for a table.

In practice you are unlikely to reach this limit after adding only 10
fields.

The error reporting in CRM seems to be hidden. The real error messages
are put into the event viewer, the error messages you see when running
deployment manager are generally useless. We have also found the
deployment manager to be unreliable it is prone to fail when creating
schema and to not only fail but to not indicate what items have
failed. If at all possible it is be better to keep any customised
data in tables and databases separate from CRM, then you can access
this directly through SQL, have control of the data and correct it if
necessary.

JB

CRM Professional Edition 1.2

Posted: 10 Mar 2005 02:15 PM PST

Sorry for the confusion. My bad. My original question was about CRM,
because BCM wouldn't work if Outlook was connected to an Exchange mailbox.
Midway, I found an update to BCM that solved the problem.

CRM is a whole different animal, obviously, and seems to require a very
careful installation plan.

jc

"Matt Parks" wrote:
 

Orders Question - Urgent!

Posted: 10 Mar 2005 12:41 PM PST

Hi Sylvie,

I will see if I can customize this report to also include the products.
Seems like a big oversite on Microsofts part that you can't print both
together.

Thanks so much for your reply.
Shauna

"Sylvie" wrote:
 

Programmatically Send Email in CRM

Posted: 10 Mar 2005 06:53 AM PST

This article in the SDK should provide you with all the information you need

Create an E-Mail Activity Using Workflow:
http://msdn.microsoft.com/library/en-us/dnmbscrm1_2/html/mbs_crmemailactivity.asp

Regards, Simon

Email Router and Exchange 2003

Posted: 10 Mar 2005 06:41 AM PST

This is correct, one of my customer's had this requirement, and tested both
the dedicated sub-domain model and the dedicated Exchange server model.
Neither work.

Although they didn't take this any further, I suspect you need to send all
messages to an SMTP relay (Windows Server has an SMTP relay service as part
of IIS), which can then bounce back any mail for @mymaildomain.com.

Regards, Simon

"Matt Parks" <com> wrote in message
news:com... 

Office Solution Accelerator for Proposals

Posted: 10 Mar 2005 04:23 AM PST

The Office Solution Acclerators have now been turned into community projects
on http://www.gotdotnet.com

The Office Solution Accelerator for Proposals workspace can be found at
http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=173e82b7-e777-4522-a4c5-f4548a20f9ec

Plans for a CRM version were shelved several months ago

Regards, Simon

week numbers

Posted: 10 Mar 2005 02:05 AM PST

Thanks!



"Support www.MSCRM-ADDONS.COM" <com_NOSPAM> schreef in
bericht news:phx.gbl... 

Change Quote template

Posted: 10 Mar 2005 12:25 AM PST

Hi,
We came across the same issue when attempting to customize the Quote form
for a customer and we recieved help from microsoft.
It shows how to use and modify the quote template.
If you would like to see this please feel free to e-mail me and i will send
you a copy.
com.au

Regards,
Nathan Warner
JayThom Pty Ltd

"Jytte" wrote:
 

CRM 1.2 and XP Service Pack 2 - Hotfix 870365

Posted: 09 Mar 2005 09:00 PM PST

Arrrggghhh,

'ya know...

you're right, it wasn't implemented on the server...

Thanks,

Boolean1

===========

"Serge Ayotte" <groupesci.com> wrote in message
news:com... 

Adding Status Reason field values not saving

Posted: 09 Mar 2005 06:57 PM PST

That was it. Had to publish "incident" customizations.

"BarryL" wrote:
 

Quote.dot missing - URGENT!

Posted: 09 Mar 2005 01:21 PM PST

Hi Nathan,

Yes I would be interested. I will e-mail you separately from this thread.

Thanks for getting back to me on this.
Shauna

"Nathan Warner" wrote:
 

CRM 1.2 SDK / Retrieving contacts

Posted: 09 Mar 2005 11:20 AM PST

Hello Frank

Wonder if you might want to bypass fetchxml entirely and query the
contactbase table directly. While accessing the crm databases directly is
not supported you are able to read the databases directly.

Might help if we could understand what you want to do with the contacts once
you have them

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


"Frank" <microsoft.com> wrote in message
news:60f201c524dd$07d6b0d0$gbl... 

Error in Knowlegebase Search

Posted: 09 Mar 2005 06:54 AM PST

Hi,
thanks for your reply.

I think that this is a bug in SQL-Server. Because the error is returned from
the SQL-Server fulltext search.
For example if i type vi* it works.

I don't know if ther is a way to get this fixed...
But in CRM there is no way I think.

regards,
Marc

"John O'Donnell" <com-nospam> schrieb im
Newsbeitrag news:phx.gbl... 

MS CRM and my Company requirements

Posted: 09 Mar 2005 06:47 AM PST

Out of the Box Microsoft CRM will provide

Contact/Client database
Contact correspondance logging
Product Database
Basic Contract management
Secure online access to my CRM from any internet connected PC anywhere
(using HTTPS & Certificates or a VPN solution)
Email communication with customer via CRM
Mobile Contacts data access from PDA

For the Customer Portal and Advanced Proposal & Contract Management as well
as Central Document Library, then you need to add some modules from Axonom
http://www.axonom.com

Regards, Simon

Server unwilling to process your request

Posted: 09 Mar 2005 06:05 AM PST

Hi~

This may be an issue where the user you are trying to move is the manager
for other users within the current business unit. To resolve this error
remove the Microsoft CRM user's alias as Manager from other Microsoft CRM
user(s). I have included the below steps to do this.

1. Open the Microsoft CRM web client, click Home, click Settings.

2. Within Settings click Business Unit Settings, click Users.

3. Within the User's window click the View drop down menu and select All
Users.

4. Holding down the Ctrl key select each user that is listed as having the
user to be moved as their Manager.

5. Click Actions and then select Change Manager.

6. The Change Manager window will appear. Click the magnifying glass icon
and then click the Go button.

7. Select the new Manager that is in the same or parent Business Unit for
these users.

8. Click OK. Click OK again to confirm the changes.

9. Attempt to move the Microsoft CRM user to a new Business Unit.

10. If the user is still not able to be moved, restart the Microsoft CRM
Security Service, located on the Microsoft CRM server. You should be able
to move the user to the new Business Unit.

If you continue to receive the error, please refer to the items listed
below:

A. Try removing this user's role and license, then move them to a new
business unit.

B. Please verify this user is not currently logged into Microsoft CRM when
trying to move them.

C. Another possible cause is that the MSSQLSERVER and SQLSERVERAGENT
services were running under a Domain account. Or CRM Server was not added
to the Pre-Windows 2000 Compatible Access group.

Kind Regards,
Shawn Nulph | Microsoft CRM | Microsoft Business Solutions

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2003 Microsoft Corporation. All rights
reserved.

Can't customize contact form

Posted: 09 Mar 2005 04:18 AM PST

Thanks

Now it works!!!

"Mike R" <freeserve.co.uk> schrieb im Newsbeitrag
news:d0msqq$mb7$1$demon.co.uk... 

Data Migration for CustomerAddress table

Posted: 09 Mar 2005 02:21 AM PST

Thanks...I will rtry that and c if it works...

"Mike R" wrote:
 

Data Migration Failed

Posted: 09 Mar 2005 01:05 AM PST

Hi Datapac...

thanks for your reply.

I found out y i cant import over...it's cos I didnt define the owner :)

Thanks

"Datapac" wrote:
 

go offline and problems with contacts

Posted: 08 Mar 2005 11:51 PM PST

If you have CRM admin rights all contacts from CRM will be synced down to
your Outlook folder. The only way to get around this is either select the
option for contacts not to sync to Outlook or put your user account into a
different role where all contacts will not sync. Do not make the security
role change to the default CRM admin role though. Always copy that role and
make the change to the newly copied role.

Kind Regards,
Shawn Nulph | Microsoft CRM | Microsoft Business Solutions

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2003 Microsoft Corporation. All rights
reserved.

Customisation CRM 1.2

Posted: 08 Mar 2005 11:25 PM PST

You have 2 options

1. Create a windows service. Use a timer and monitor the database fo
new emails that come into the QueueItemBase table in the cr
database. (check the CreatedOn or ModifiedOn fields for the info).
Cross reference the ObjectId in the QueueItemBase with the ActivityI
in the ActivityBase table.
Generate an email response and send it off.... (I know sounds ver
simple). :wink:

2. Alternatively you can purchase a c360 component that does it fo
you (including converting the email to a case and attaching the emai
to the case) http://c360.com. We are a company with over 100 cr
users, so the small costs for each license unfortunately adds up t
too much for us (cheaper to develop in house....) :(

I hope this helps

Ala

Disabled Leads at all levels (including System Admin) cannot put b

Posted: 08 Mar 2005 05:03 PM PST

Here is the KB article for the CRM admin tool. You will need to contact
Microsoft CRM support to get access to this tool.

http://support.microsoft.com/default.aspx?scid=kb;en-us;893102

Here are direct links to our support site:

Microsoft Business Solutions support home page:
<http://www.greatplains.com/support>
To contact Support by phone: (888) 477-7877

Microsoft Support home page:
<http://www.support.microsoft.com>

Kind Regards,
Shawn Nulph | Microsoft CRM | Microsoft Business Solutions

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2003 Microsoft Corporation. All rights
reserved.