Authentication Error RRS feed

  • Question

  • I am in a bit of pickle. In fact, that's an understatement, I am in a whole world of trouble if I can't get this resolved...

    We run MSCRM 3.0 on a SQL Server 2005 database.

    Several months ago we had a power surge that blew one of the disks on the server. Ever since then, we haven't been able to take a backup of the database, which often goes into Emergency Mode. A DBCC check and repair did nothing.

    Anyway, over this weekend I ran the Stellar Pheonix recovery software, which apparently repaired the database. I was pleased to see that I could take a backup of the newly created recovered database and thought my worries were coming to an end. However, when I tried to restore this backup to the live database, it got stuck in Restore mode. To cut a long story short, I ended up deleting the original database, thinking I could just rename the recovered version, and CRM would run again. However, now I have done this, I get an error when trying to run CRM over a web browser -

    AUTHENTICATION ERROR - Microsoft CRM could not log you onto the system. Make sure your user record is enabled and you have been assigned at least one security role. For more information, contact your system administrator.

    I'm guessing it's a User / Security Role issue, but I can't seem to figure it out. My user account has the required role....I think.

    Does it matter that my "new" database is using differently named .mdf and .ldf files than the original?

    One other thing, when I run the Deployment Manager, and try and Configure SQL Server, it tells me no CRM Databases are found on the server.

    Please, please, please help.

    Sunday, October 28, 2012 6:54 PM

All replies

  • Hi,

    If you've effectively got new _MSCRM and _METADATA databases, you'll need to run the CRM3.0 redeployment tool (it's included on the CRM3.0 install disk). Before you can run this, you'll need to uninstall CRM3.0, run the redeployment tool, then install crmv3.0 again.

    Here's a link to the CRM3.0 implementation guide http://www.microsoft.com/en-us/download/details.aspx?id=10450


    Microsoft Certified Technology Specialist (CRM) GAP Consulting Ltd Microsoft Community Contributor Award 2011

    Sunday, October 28, 2012 10:15 PM
  • Thanks Rob. I'll give this a go this morning.........assuming I can find our CRM3.0 install disk.
    Monday, October 29, 2012 6:08 AM
  • Right, CRM Server uninstalled.

    However, when I run the Redeployment tool, the first thing it asks is for my SQL Server name. No matter what I enter, it says it can't retrieve a list of databases from the specified server.

    What can I possibly be doing wrong?

    All services are running.

    Monday, October 29, 2012 8:06 AM