locked
Separating the CRM Application from the SQL Application RRS feed

  • Question

  • Hi all,

        At the moment,our CRM application and SQL application are installed on the same physical server. I have been asked to virtualize the CRM application, but leave SQL intact (We've looked at other scenarios, but this is what's best for us). According to Microsoft (http://support.microsoft.com/kb/952934), “Move the Microsoft Dynamics CRM Server or one of the Microsoft Dynamics CRM server roles. However, leave the SQL Server and the SQL Server Reporting Services server intact” it seems no more complicated than installing a new instance of CRM Server, point it to the existing SQL database, and uninstalling the old CRM application.

        My question is, does the fact that both the CRM application and the SQL application are installed on the same physical machine make any difference?

    Monday, October 31, 2011 2:22 PM

Answers

  • Hi Alex,

     

    If you want to virtualise the CRM application and separate the SQL, follow these steps:

    -Install CRM application on a new server

    -Point the database to the existing SQL Database server

    Thats it.

     

    Separating SQL and your CRM application is a best practice.  In case your sql server got corrupt, you just have to restore only the database from backups.  

     

    Regards

    Vinay

    • Marked as answer by Alex Bernal Wednesday, November 9, 2011 4:45 PM
    Thursday, November 3, 2011 6:42 AM

All replies

  • Sorry, I forgot to mention (in case it's important) we're using SQL 2005 SP3 and CRM 4 R17, on Windows Server 2003 SP2

     

    Al

    Monday, October 31, 2011 2:25 PM
  • Anyone hazard a guess?
    Wednesday, November 2, 2011 4:11 PM
  • Hi Alex,

     

    If you want to virtualise the CRM application and separate the SQL, follow these steps:

    -Install CRM application on a new server

    -Point the database to the existing SQL Database server

    Thats it.

     

    Separating SQL and your CRM application is a best practice.  In case your sql server got corrupt, you just have to restore only the database from backups.  

     

    Regards

    Vinay

    • Marked as answer by Alex Bernal Wednesday, November 9, 2011 4:45 PM
    Thursday, November 3, 2011 6:42 AM
  • hi Alex ,

    I have encountered few problems in  split  Envoirnment ie  the App and DB server on different server

    There are times you might get Authentication issue which is normally called as Double hop issue.

    Especially if you trying to access records using SQL filtered view

    You need to be wary about setting up proper delegation between the two server.

    and also to use Kerberos in case if you using NTLM network authenciation protocol

    Hope this helps

    Dkay

    --------------------------------------------------------------------------------
    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".

     

    Saturday, November 5, 2011 9:05 AM
  • Thanks for the responses everyone...

    We installed the Application on a new server, and uninstalled the application from the original. Once we re-pointed everyone's Outlook client to the new application server, everything seems to work perfectly.

     

    Al

    Wednesday, November 9, 2011 4:46 PM