|
SYMPTOMS
When Microsoft SQL Server and Microsoft CRM Server are installed on separate
servers and you enter a license key during the 1.0 to 1.2 upgrade of Microsoft
CRM, you may receive the following error:
Setup was unable to install Microsoft CRM Server. Setup was unable to grant
access to the Microsoft CRM databases. Unknown error. (80040E14).
CAUSE
The upgrade script is attempting to grant a Microsoft SQL Server login called
MYDOMAIN\MYCRMSERVER$ access to the MSCRM database. The upgrade fails because
the MYDOMAIN\MYCRMSERVER$ login already existed and already was granted access
and a role in the database.
RESOLUTION
Remove the MYDOMAIN\MYCRMSERVER$ SQL Server login from the Microsoft SQL Server
using Microsoft SQL Enterprise Manager. To do so complete the following steps:
1. Click Start, point to Programs, point to Microsoft SQL
Server, and then click Enterprise Manager.
2. Expand Microsoft SQL Servers, expand SQL Server Group, and
then expand your SQL Server.
3. Expand Security and then click Logins.
4. Right-click MYDOMAIN\MYCRMSERVER$ and then click Delete
from the context menu.
5. Once this role is deleted, you can re-start the upgrade.
|