• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

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

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

Does case matter ?

I stuck at this point, i need to move my MOM database to this server as soon as possible.
  • 2
  • 2
1 Solution
LanticrogersAuthor Commented:
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.
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".

LanticrogersAuthor Commented:
thanks, we did the name change, working fine now
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now