CRM outlook will not sync

CRM 4.0 Outlook client on XP SP2 latest updates.  CRM 4.0 client with Rollup 4.

Goto tool bar CRM
    Syncronize with CRM

Then get error:

A SQL Server error occurred. Try this action again. If the problem continues....

Will not sync so any task or calendar items created in outlook do not go into crm.

Please assist.

Microsoft can't figure it out so I figure you guys are smarter anyway.
darovitzAsked:
Who is Participating?
 
Feridun KadirConnect With a Mentor Principal ConsultantCommented:
Wouldn't the mscrmconfig entries only be relevant if crm can't be configured for outlook in the first instance?  
0
 
Feridun KadirPrincipal ConsultantCommented:
Are you using the CRM client with offline access?  If so, please check that the local SQL server service on the XP computer is started.

Alternatively it may be quicker to uninstall the CRM client and then reinstall.

0
 
darovitzAuthor Commented:
Not using offline access.. already uninstalled 2X.

Any other suggestions.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Feridun KadirPrincipal ConsultantCommented:
A few more questions:
- Has CRM for Outlook ever worked for a user on this computer?
- Did you upgrade from 3.0 in the past?
- Do other aspects of CRM work within Outlook. Is it just the synchronization that fails?
- Has the user ever used CRM for Outlook on another computer?
0
 
squizzerCommented:
In the mscrmconfig db in the deployment properties table check the url is correct on the following:

ADSdkRootDomain
ADWebApplicationRootDomain
AsyncSdkRootDomain

This may help as one of them is normally empty.

Cheers
Mark.
0
 
darovitzAuthor Commented:
Ok, I figured it out.  Sorry you guys were not on the right track and I just made an educated guess here.  I backed up all the tables and then deleted all the entries in all the sync tables and then reinstalled the plugin for outlook on all stations.
0
 
darovitzAuthor Commented:
Answered myself.
0
 
pdesjardins1Commented:
I am having the same problem but I need more more information about the steps you took to solve the problem. Which tables? Where do I find them?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.