Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-06-12
4
Medium Priority
?
200 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

688 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