Solved

The computer name has changed after SQL server was installed. SQL server must be reinstalled.

Posted on 2008-06-12
4
197 Views
Last Modified: 2010-04-21
Hi,
i have a issue with SQL 2005 Clustered when trying to install Microsoft Operations Manager Database on it.

I get this error : The computer name has changed after SQL server was installed. SQL server must be reinstalled.

The name of the sql server has never been change.

If i run :
SELECT @@Servername
SELECT ServerProperty('machinename')
i get:
1  ndsql1
and
1 NDSQL1

Does case matter ?

I stuck at this point, i need to move my MOM database to this server as soon as possible.
0
Comment
Question by:Lanticrogers
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:sbagireddi
ID: 21771940
0
 

Author Comment

by:Lanticrogers
ID: 21772079
Thanks , but i  already followed this KB before asking the question here.
The only thing in this KB that im not sure is this part:

Select @@servername Select ServerProperty('machinename')
The names returned should match in spelling and case.

But does it really matter? the first result is in LowerCase and the ServerProperty result are in Uppercase.

do to the rename i need to restart the server, i need to schedule this and i want to know all my options before scheduling a downtime. So if it doesn't work i can try something else.
0
 
LVL 8

Accepted Solution

by:
sbagireddi earned 500 total points
ID: 21772171
If you read the KB is says:

"The MOM Prerequisite checker looks at two entries for the computer name, and the entries must match in case and in name".

0
 

Author Closing Comment

by:Lanticrogers
ID: 31466660
thanks, we did the name change, working fine now
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question