CRM 2011 - 无法安装Active Directory后连接到数据库 [英] CRM 2011 - unable to connect to database after installing Active Directory

问题描述

我已经给虚拟机为发展宗​​旨，在其中安装Windows 2008 R2，CRM 2011，SQL Server等在此之前我报错项目，虚拟机正在室内使用，验证公司的AD服务器

因为我需要使用虚拟机异地，我已经为了安装Active Directory等在虚拟机上运行DCPROMO。正如你可能已经猜到了，在这样做，现在什么都连接到使用Windows身份验证的SQL Server，因为用户现在AD用户，用不同的ID（至少我认为这就是问题所在 - 我不是系统管理员）

所以，当我运行CRM部署管理器，它说，它无法连接到CRM_CONFIG数据库，assumedly因为Windows验证无法正常工作。 SQL Server正在运行的罚款。其实Windows验证甚至不会工作于SQL管理Studio中，我使用SQL Server身份验证连接。

我该如何解决这个烂摊子？ :)有没有告诉CRM部署管理器（和其他一切）使用SQL Server身份验证而不是Windows身份验证的一种方式？还是有办法解决Windows验证机器上？后者将是preferable，因为它可能会解决一切现在不能使用Windows身份验证连接到SQL Server。

解决方案

我不知道如何解决这个问题，但我可能有一个去：

1. 卸载CRM
2. 在重新安装CRM - 。这些步骤应该给你一个工作CRM，没有任何的定制或数据
3. 导入现有的组织 - 这应该给你的CRM作为最初的开发有它（的进口过程中，你可以重新映射所有用户在AD的一部分）

看看这个链接查看详细的过程：

导入的Microsoft Dynamics CRM 2011组织

此外，这可能帮助：

移动在Microsoft Dynamics CRM 2011的部署

I've been given a VM for development purposes, in which is installed Windows 2008R2, CRM 2011, SQL Server, etc. Prior to me being given the project, the VM was being used inhouse, validating to the company's AD server.

Since I need to use the VM off-site, I have run "dcpromo" in order to install Active Directory etc. in the VM. As you may have guessed, upon doing this, nothing can now connect to SQL Server using Windows Authentication, because users are now AD users, with different IDs (at least I assume that's the problem - I'm no sys admin).

So when I run CRM Deployment Manager, it says it can't connect to the CRM_CONFIG database, assumedly because Windows Auth isn't working. SQL Server is running fine. In fact Windows Auth won't even work in SQL Mgmt Studio, I have to connect using SQL Server Auth.

How do I fix this mess? :) Is there a way of telling CRM Deployment Manager (and everything else) to use SQL Server Auth instead of Windows Auth? Or is there a way to fix Windows Auth on the machine? The latter would be preferable, as it would probably fix everything which now can't connect to SQL Server with Windows Auth.

解决方案

I'm not sure how to fix this, but I would probably have a go at:

1. Uninstall CRM
2. Reinstall CRM - these steps should give you a working CRM, without any customisations or data.
3. Import the existing organisation - this should give you CRM as the original developers had it (as part of the import process you can remap all the users in AD).

Check out this link for detail on the process:

Import a Microsoft Dynamics CRM 2011 Organization

Also this may help:

Move the Microsoft Dynamics CRM 2011 deployment

这篇关于CRM 2011 - 无法安装Active Directory后连接到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！