Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Deployment manager server names have not changed after moving database to Cluster RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Issue 1:

    We Redeployed our CRM database to a cluster. It all worked fine and we can even access CRM. however in deployment manager, when i click Servers, the SQL server name is still the name of our old server and i cannot see anywhere to change it. I have checked the registry and it is correct. The old database is disabled so i know for sure i am pointing to the new database in the cluster. Does any one have a solution for this?

     

    Issue 2.

    When another deployment administrator tries to access the deployment manager, They get an error saying "Unable to access the MSCRM_CONFIG database, SQL Server Does not exists or access denied"

    is there a step i have missed?

     

    I get the feeling i need to change the database name somewhere not sure where. I have done updates to the registry as suggested by 

    http://rc.crm.dynamics.com/rc/regcont/en_us/op/articles/sql_cluster.aspx#o35685

     

    regards

    Keliud

    Monday, December 12, 2011 9:54 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    For issue 2 check whether firewall blocking the SQL port, and check the remote connection time in the SQL.

     

    Thanks & Regards, MS CRM Consultant, V.Surya.
    Tuesday, December 13, 2011 6:43 AM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    From you description, it sounds like one deployment administrator account can run deployment administrator, but another one can't. If that's the case, then the problem is likely to be SQL permissions. If SQL Server is configured to audit failed logins, then you should see some information in the application event log. The most likely issue and resolution is that a deployment administrator's account should be a member of the AD group SQLAccessGroup, and this will give them permission to the MSCRM_CONFIG database

    Re issue 1: If you temporarily disable the organisation in the Deployment Administrator tool, you should then be able to change the SQL Server, then reenable the organisation

     

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Tuesday, December 13, 2011 10:50 AM
    Moderator