Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Invalid User Authorization On Imported Database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

     

    I'm having some problems getting a CRM 4.0 database operational in a new domain. Initially the DB started off as CRM 3.0 and was upgraded to CRM 4.0.

    I have restored a copy of the CRM 4.0 ????_MSCRM database into SQL in the new domain. Initially when I tried to import the database using deployment manager I would get an error message saying ""At least the setup user needs to be mapped before this organization can be imported" 

    I had created user account for all the users from the previous domain in the new domain and mapped the users. In the end I edited SystemUserBase for the administrator account to match our domain. After completing this I was able to successfully complete importing the organisation.

    I have then set the newly imported db to default and disabled the other databases. However when I attempt to bring up the imported db in IE I get a message saying:

    I have tested both administrative login and user with the same result.

    Invalid User Authorization

    The user authentication passed to the platform is not valid.

    Any suggestions welcomed.

     

    Regards,

    Adam

     

    Tuesday, March 23, 2010 9:00 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    I had the same problem because you surely just specified the url to your server...

    As there was surely a previous organization, the server tries to connect you to this organization...

    Go to the deployment manager, then ensure that your imported organization is the default one. Then restart IIS and async service.

    If it doesn't work and you don't need the old organization anymore (then one that comes with the product installation), deactivate it then delete it. Again IISreset and it should work.

    I had the same problem two weeks ago...

    My blog : http://mscrmtools.blogspot.com
    You will find:
    Bulk Delete LauncherView Layout replicator
    ISV.Config Manager Form Javascript Manager
    Assembly RecoveryAnd others (use tool tag on my blog)
    • Marked as answer by Agilbert2003 Wednesday, March 24, 2010 8:10 PM
    Wednesday, March 24, 2010 7:11 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Check your IIS setting for authentication on the crm site and ensure its windows authentication with anonymous disabled. Also make sure you have your  new site added to your trusted sites.

     

    Also check your crm AD groups and ensure you have your updated users present, also ensure Network Service, or what ever your app pool is running as is in the privusergroup.

    MSCRM Bing'd - http://bingsoft.wordpress.com
    Tuesday, March 23, 2010 10:18 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Rhett,

     

    Thanks for your reply. 

     

    IIS is using windows authentication.

    I believe AD groups are also correct. 

    This installation is a test machine, with anotehr machine running a production CRM DB.  I have loaded our production CRM db onto the test machine and successfuly imported.  Which I was able to access it post import. Also was able to access default DB created during install.

    Problem only exists for DB which is from a different domain.

    thanks Adam

    Wednesday, March 24, 2010 4:20 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    I had the same problem because you surely just specified the url to your server...

    As there was surely a previous organization, the server tries to connect you to this organization...

    Go to the deployment manager, then ensure that your imported organization is the default one. Then restart IIS and async service.

    If it doesn't work and you don't need the old organization anymore (then one that comes with the product installation), deactivate it then delete it. Again IISreset and it should work.

    I had the same problem two weeks ago...

    My blog : http://mscrmtools.blogspot.com
    You will find:
    Bulk Delete LauncherView Layout replicator
    ISV.Config Manager Form Javascript Manager
    Assembly RecoveryAnd others (use tool tag on my blog)
    • Marked as answer by Agilbert2003 Wednesday, March 24, 2010 8:10 PM
    Wednesday, March 24, 2010 7:11 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Fantastic, thank you so much.

    Oddly it wasn't until I deleted all other organisation before I could load the imported domains database.

     

    Thanks Again,

    Adam

    Wednesday, March 24, 2010 8:12 PM