dynamics crm - CRM deployment Manager , SQL Server is unavailable -


i facing issue deployment manager when trying create new organisation entry. giving error " sql server unavailable. below brief of problem:

earlier application & crm database on same server & working fine.

but when migrated database on server, application able connect database. not able add new entry in organiser. when trying saying "sql server unavailable." ( sql server running fine.)

note: firewall turned off there no network issue sql services running fine

any on appreciable.

thanks in advance

regards, yashwant vishwakarma | www.sqlocean.com

it worth checking this technet article on rehoming / reconfiguring dynamics crm deployment.

i highlight steps 4 through 7 takes through updating registry key of crm server holds crm database connection , updating crm organization's database deployment manager.

including pertinent parts of technet article below few minor edits reflect can work not sql server cluster instances, if databases moved new sql server and/or sql server instance:

on computer running microsoft dynamics crm web application, click start, click run, type regedit in open box, , click ok.

locate following registry subkey:

hkey_local_machine\software\microsoft\mscrm

right-click configdb, , click modify.

in value data box, change data source name of new virtual sql server (or current sql server databases moved to), , click ok. example, string value in value data box should resemble following: data source=newsqlserver;initial catalog=mscrm_config;integrated security=sspi

on computer running microsoft dynamics crm server web application, start deployment manager. this, click start, point programs, point microsoft dynamics crm, , click deployment manager.

expand deployment manager node, , click organizations.

if organization not disabled, right-click organization, , click disable.

warningwarning when disable organization, users no longer able access microsoft dynamics crm organization. click yes disable organization.

in list of organizations, right-click organization, , click edit organization.

in edit organization wizard, in sql server box, type virtual sql server name sql server cluster created earlier, , click next. (note: if not using sql server cluster, type sql server name or sql server name , instance name here).

on system requirements page, after successful diagnostics check, click next, , click apply.

click finish.

enable organization. this, right-click organization, , click enable.

reset iis services on computer running iis microsoft dynamics crm server web application installed. this, click start, click run, type iisreset in open box, , click ok.


Comments

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

php - .htaccess mod_rewrite for dynamic url which has domain names -

Website Login Issue developed in magento -