Solved

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

Posted on 2008-06-12
4
191 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
Comment Utility
0
 

Author Comment

by:Lanticrogers
Comment Utility
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
Comment Utility
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
Comment Utility
thanks, we did the name change, working fine now
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

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…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now