Related Posts
  • Forum Post: Re: Re: Dynamics CRM 4.0 contacts import

    Hi Aly, thank you for your reply. I will download that tool and try it. I am using SQL Server 2008 Import and Export wizard to map and import data at the moment. In contacts table I have fields CustomerAddressID (which is series for numbers from 1 to 2.2 million), BusinessCategary, CompanyName, Address1...
  • Forum Post: Dynamics CRM 4.0 contacts import

    Dear All, I am new to Dynamics CRM 4 system and I am hoping you would be able to help me to resolve this issue I am having. The CRM system is using MS SQL server 2008 for database. I have imported 2.2 million contact leads into the same database in effect creating a table called contacts. Now the field...
  • Forum Post: Re: Re: Re: Re: Re: Re: Re: View accounts like hierarchy / treeview

    Awesome post guys! Really good stuff. Here is a query you can give a try. Hope this helps: with RecursionCTE (parentaccountid, accountid, [name]) as ( select R2.parentaccountid, R2.accountid, R2.name from filteredaccount as R2 where r2.accountid = 'D0E4DC4D-1C09-DE11-A512-0003FF800564'...
  • Forum Post: CRM 4.0 integration with GP 10.0

    MSDynamicsWorld.com recently posted an article referring to "A new Dynamics CRM integration to Dynamics GP" which "is available now and will pave the way for other CRM-to-ERP integrations developed by Microsoft in the future..." Microsoft Distinguished Engineer Mike Ehrenberg indicated...
  • Forum Post: Replicating CRM database for reporting services

    Hi folks, I'm trying to set up a replicated copy of the x_MSCRM database to use for our Reporting Services. The issue is that some of the views reference tables that don't exist. Don't know how that works though. Also, many of the User Defined Functions have similar dependencies. Whilst creating...
  • Forum Post: Re: CRM 4.0 installation failed - tcp connection refused

    Hi, Check your SQL Server configuration to see if both Named Pipes and TCP/IP network libraries are enabled.
  • Forum Post: CRM 4, Server 2008R2, SQL 2008+SP1

    I'm trying to get my head around CRM and install it in to a domain. In doing so, I've done the following: - Created a new Windows 2008 R2 machine - Installed all of the latest Windows Updates - Joined the domain - Log in as a domain admin - Install .NET 3.51 - Install SQL 2008 with all the required...
  • Forum Post: CRM Reports

    Okay so i've installed Dynamics CRM, SQL 2008 & MS Exchange all on a single server running SBS 2008 and essentially everything works perfectly except for that when i try and run a report in the CRM i get the following error: Server Error in '/' Application. --------------------------...
  • Forum Post: Reporting Error

    Dear Experts ; I installed Microsoft Dynamics CRM 4.0 in Windows 2008 Server and SQL 2008 installed in another Server. Then Configure Reporting Services . [ ( http://sqlserver:80/Reports ) is Working Correctly in SQL Server & CRM Reports are Working Correctly in CRM Server {Domain Server}....