Solved

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

Posted on 2008-06-12
4
193 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Getting the 3 middle digits 4 37
SQL Express connecting form remote error 26 7 45
SQL Agent Timeout 5 59
How to query LOCK_ESCALATION 4 41
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

803 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