Solved

Can you rename a SQL Server which is part of the domain ?

Posted on 2013-01-23
8
324 Views
Last Modified: 2013-02-04
Hello,

I have a Win 2k8 Server with SQL Server 2012, it is part of the domain.

Can I rename the Server ?
Will SQL Server enter in panic ?

Thanks for your help,
0
Comment
Question by:namerg
  • 4
  • 2
  • 2
8 Comments
 
LVL 4

Expert Comment

by:anotherjallen
ID: 38812314
Is this a stand alone instance or a SQL cluster?
0
 

Author Comment

by:namerg
ID: 38812327
Stand alone.
0
 
LVL 4

Accepted Solution

by:
anotherjallen earned 500 total points
ID: 38812412
I would give this a read.  I don't know specifically about SQL 2012 but I know in SQL 2005 you had to rename the instance before renaming the server or it would cause issues.

http://msdn.microsoft.com/en-us/library/ms143799.aspx
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:namerg
ID: 38812423
Thanks But, where should i run the procedures ? I see SQL commands..
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38812714
Thanks But, where should i run the procedures ? I see SQL commands..
From SSMS connected to that instance of SQL Server.
0
 

Author Comment

by:namerg
ID: 38812716
So, i need to have the sql services running ?
I am not a SQL DBA or Expert.
Is that procedure a Query ?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38812821
So, i need to have the sql services running ?
Yes.
Is that procedure a Query ?
Strictly speaking it is a SQL Script.  But you run it just like you would any query from the SSMS Query window.
0
 

Author Comment

by:namerg
ID: 38812957
Ok, i will give it a shot.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

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

A safe way to clean winsxs folder from your windows server 2008 R2 editions
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

820 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