Post reply

MOM 2005

  • January 6, 2006 at 11:00 am

    #112132

    I am trying to install a new MOM 2005 database on a production SQL 2000 SP4 box. The box previously changed names. After which the following was used to update SQL:

    sp_dropserver 'old server name'

    sp_addserver 'new server name', 'local'

    Everything looks fine when running Select @@servername

    On trying to install the database using the MOM install disk, the message is that the server failed the prerequisite check, stating that "The computer name has changd after SQL server was installed. SQL server must be reinstalled."

    Has anyone encountered this before? Is there any solution other than reinstalling SQL?

     

    Thanks...Nali

  • January 6, 2006 at 3:46 pm

    #613407

    Try looking at this http://blog.opsan.com/archive/2005/05/10/465.aspx

    I have done this before and believe this was the answer.

    Cheers,

    david russell

  • January 7, 2006 at 5:24 pm

    #613427

    Thanks for the info David. I see the entries in the table that I need to change. The question I have is, if I make the change, and it causes problems in the other databaseses or apps, is it reversable if I change the values back?

    I'll try it on a dev machine first.

     

    Thanks...Nali

  • January 9, 2006 at 7:33 pm

    #613707

    by all means, try it on dev first if at all possible... and if it doesn't work, do a few more googles on similar phrases.  You will be able to do this.  Good luck.

    Cheers,

    david russell

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply