We help IT Professionals succeed at work.

Renaming a sql server

AikiRyu
AikiRyu asked
on
594 Views
Last Modified: 2012-05-05
I installed SQL Server 2005 on a machine named "hardName" and then tested the install.   We then made a DNS alias so the machine could be referenced as "easyName."  I have corrected @@servername via
    a) select @@servername
    b) sp_dropserver oldName
    c) sp_addserver newName,local
    d) Bounce the server.
    e) select @@servername  

The question is, how can I correct serverproperty('servername') without changing the machine's physical name?  The system administrators want to reference the computer via "hardName" but the users prefer "easyName."

One of the reasons for this process was because an old machine "easyName" was up during the install and during the migration of databases from "easyName" to "hardName."  Now that the migration is complete, I want to finish renaming the database instance.
Comment
Watch Question

except for clusters, serverproperty("servername") is the machines PHYSICAL COMPUTER NAME.


http://msdn.microsoft.com/en-us/library/ms174396.aspx

MachineName:
Windows computer name on which the server instance is running.
For a clustered instance, an instance of SQL Server running on a virtual server on Microsoft Cluster Service, it returns the name of the virtual server.
NULL = Input is not valid, or an error.
Base data type: nvarchar(128)
Serge FournierAnalyst Programmer
CERTIFIED EXPERT

Commented:
dfs name resolution work fine here for us:

sql.corp.stas.local is our sql

before that i was using an environnement variable to point to my sql server

Author

Commented:
Brandon,
Is there any way to change what the SQL server sees as the physical machine name?  Is there a registry change that could be made?
Aiki
No.  That reads the computer name.  But your users don't need to see this so why bother?

Author

Commented:
One of my colleagues had a problem setting up replication on the new server.  Apparently the rep install process reads both @@servername and serverproperty('servername').  As yet, these two don't match and the replication install fails.
Correct'ish.  The servername comes from srvname in sysservers.  It doesn't have to match, but the srvname has to be valid for replication (no . or - etc.).  That's where srvnetname comes in to play.  You can call the server something else (except "local") in sysservers other than the physical computer name.
@@servername pulls from sysservers where srvid=0.

Author

Commented:
select @@servername                       -- Looks ok
select * from sysservers                     -- Looks ok
select serverproperty ('servername')  -- Does not give what I want
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.