January 21, 2008
Redeployment of Production Database to VPC
Today I have succesfully redeployed a production database of a client to a single server vpc.
Almost everything went by the book except:
With some help from a knowledge base everything went well:
Error message when you try to log on to Microsoft Dynamics CRM 4.0: “Cannot open database “<Organization>_MSCRM” requested by the login” (http://support.microsoft.com/kb/946286/en-us)
Set up the NT AUTHORITY\NETWORK SERVICE account as a SQL user who has access to the Microsoft Dynamics CRM 4.0 databases. To do this, follow these steps:
1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Management Studio.
2. Click OK to log on to SQL Management Studio.
3. In the Object Explorer pane, expand Databases, expand the Organization_MSCRM database, and then expand Security.
4. Right-click Users, and then click New User.
5. In the Database User – New dialog box, type NT AUTHORITY\NETWORK SERVICE in the following fields:
> The User name field
> The Login name field
6. In the Database role membership area, click to select the db_owner check box, and then click OK.
By the way, it is possible install MS CRM 4.0 Enterprise Edition with multiple organisations on a single vpc server !!! This is great for development.
Loading ...
