How To Rename A SQL Server

● Ian Grieve ●  ● 2 Comments   ● 

Like some other posts recently, this one is the result of a conversation with a colleague at my new company, where I found they were unaware of something I took for granted; the ability to easily rename a comuter which has a stand alone instance of SQL Server installed.

I do this fairly often as I use quite a lot of Virtual Machines for testing different configurations, but I don’t want to have to build a new one every time, so I make copies of a base VM and rename it each time I want a new one (there is often more than one running at any one time and I want to avoid conflicts).

As well as renaming the machine inside the VM, I also rename the SQL Server to make sure it matches the name of the machine; I’ve had problems before with Microsoft Dynamics GP when I’ve not done so.

Doing this is actually very simple. Continue reading → How To Rename A SQL Server

● Categories: Dynamics, GP, Microsoft, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 ● Tags: , , , , ,  ● Permalink ● Shortlink ●