Dynamics CRM - reinstalling a broken install

-
A week was spent doing battle with virtual machines, setting up servers, sorting out IIS, SQL Server, AD etc etc... and when everything was in place, Dynamics CRM was installed. More time was then spent making sure that the install would make it past the verification page and at long last we had a beautifully set up instance of Dynamics CRM running on a virtual server, attached to our domain and residing on my PC. Life was good. Then someone unintentionally broke it before I'd had a chance to take a copy of the virtual machine, except that because of what was broken it wouldn't have mattered if we'd had a copy as the AD links and machine name were toasted on the domain. Pants! So next came the mission to fix things.

Several options were tried and after much hair pulling eventually the domain was recognizing the server again. Once the server was back in play there was an attempt to connect to the Dynamics CRM site but lady luck was not with us that day and we received the error: “Business Management Error. The user id associated with the current record is not valid”. This was happening when we accessed using localhost:5555 and servername:5555. Bugger! Says I.

My Google mojo was in poor shape at the end of last week and only two websites offered any inkling of help. When all two options had been tried and there was still no joy, the next step was to contact a very nice man at Microsoft who spent quite a bit of time helping me with this issue. Alas still no joy.

So on to the next option. Uninstall and reinstall Dynamics CRM. Probably not an option you can do in a production situation but then again, in a production situation if someone decides to take a copy of your server and rename it whilst being attached to the domain you've probably got bigger problems to worry about.

Uninstalling is nice and easy but before you reinstall you need to drop the SQL databases that were created as part of the initial Dynamics CRM install. Renaming them won't work as Dynamics CRM still manages to maintain links to them and will fail with lots of groovy messages about missing log files. If you drop the tables then all goes swimmingly with the install. If you've got data you want to keep, take a backup or a copy of the databases first and then do a merge after you've got things up and running again.

Once you've dropped your tables, reinstall using most of the same options as you did previously but this time with one difference, don't use the default website, select the option to create a new website.

And that should be it. You'll be up and running again. Phew....

Comments

Post a Comment

Popular posts from this blog

Yay - It works! Rebuild/Reorganize all indexes in one go - woo hoo

-
/*Version 1 of my script to fix all fragged indexes on a database */ /*Must be logged in as [sa] for this to work, if not, you will get permissions errors*/ /*You should be able to copy and paste this script in its entirity to your SQL 2005 or higher query window and run it without altering anything other than the USE .*/ /*Perform a 'USE ' to select the database in which to run the script.*/ USE AdventureWorks GO -- Make sure temp table doesn't exist IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tmp_fraglist]') AND type in (N'U')) DROP TABLE [dbo].[tmp_fraglist] GO -- Declare variables SET NOCOUNT ON DECLARE @tablename NVARCHAR (255) DECLARE @indexname NVARCHAR (255) DECLARE @indextype NVARCHAR (255) DECLARE @execstr NVARCHAR (255) DECLARE @pagecounts INT DECLARE @frag DECIMAL DECLARE @reorgFragSize DECIMAL DECLARE @rebldFragSize DECIMAL DECLARE @numrecords INT DECLARE @rowcount INT DECLARE @errorMessage
Read more

The Grace Jones

-
Well, we finished recording the CD and now all the hard work is starting, the editing, mixing, production etc... We've also got some guys working on a video for us which sounds as though it's going to be interesting. Time to sell the house in order to pay for the tour of Ireland next year I guess. :)
Read more

What is a geek?

-
Someone raised an interesting point on Monday night at a GGD dinner and I feel they have missed the entire point of Girl Geek Dinners and have also, with their comments, seriously undermined other women who are looking to come out of their shell and interact with other 'geeks'. If you don't agree with what we're doing then don't come to a Girl GEEK dinner, and certainly don't turn up and throw cold water on people, make belittling comments and then moan that it was too technical and you didn't enjoy it. So what is a geek? There seemed to be some confusion. These women throwing around the derogatory comments seem especially confused. So let's refresh everyones' minds. You don't need to be in IT to be a geek folks! It's not an exclusive club limited to women who don't baulk at the thought of writing code. We're a diverse crowd and we celebrate each others geekiness, even if it isn't something we're into. We certainly
Read more