?
Solved

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

Posted on 2013-01-23
8
Medium Priority
?
331 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 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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

569 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