Solved

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

Posted on 2013-01-23
8
323 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
Is Your AD Toolbox Looking More Like a Toybox?

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.

 

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
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 …

778 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