I've locked myself out of my orginal install of CRM instead of trying to fix
the problem I made a clean install of my server and CRM. Now when I restore
the MSCRM, Metabase, and MSCRMDistribution I get locked out the server
because users do not exsist. How do I restore the database from the old sql
and get it to work on my clean install of CRM. My main goal is to get back
contacts and accounts. I can recreate the other stuff

Hi Tino,

Assuming you can still access the old sql db, you can make a clean
installation of CRM. Then backup the old database, update these tables in the
[companyname]_MSCRM database:
-CustomerAddressBase
-ContactBase
-AccountBase

to not contain any link with any AD item (owning user and owning business
unit). Something like:
UPDATE ContactBase SET OwningBusinessUnit=null AND OwningUser=null

Then copy that data to the new database. If that worked, look at the
existing business units and system users for the guids and update all the
owning users and business units to contain the new guids.

That should work.

Ronald Lemmen
Avanade Netherlands

Then update the

"Tino" wrote:

Ronald,

While that may work for getting the data into CRM, it won't set the
SecurityDescriptor field properly which means that security on those records
won't be correct and users won't have the proper access to those records.

The only safe way to relibably set this field is to use the SDK or the DMF to
bring the data in.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 5 Nov 2004 00:51:02 -0800, "Ronald Lemmen"
<RonaldL@-REMOVETHIS-avanade.com> wrote:

Hi Tino,

Assuming you can still access the old sql db, you can make a clean
installation of CRM. Then backup the old database, update these tables in the
[companyname]_MSCRM database:
-CustomerAddressBase
-ContactBase
-AccountBase

to not contain any link with any AD item (owning user and owning business
unit). Something like:
UPDATE ContactBase SET OwningBusinessUnit=null AND OwningUser=null

Then copy that data to the new database. If that worked, look at the
existing business units and system users for the guids and update all the
owning users and business units to contain the new guids.

That should work.

Ronald Lemmen
Avanade Netherlands

Then update the

"Tino" wrote:

Ok Matt, you win I forgot about that..

Ronald

"Matt Parks" wrote: