Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2013-01-23
8
Medium Priority
?
329 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
[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
  • 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 2000 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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 

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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

604 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