Renaming A SQL Server 2005 Server

  • Article

For all of you who remember the agony (well, not really agony, but extra steps) involved when renaming a machine with SQL Server 2000 on it, fear not. I just installed SQL Server 2005 on a virtual machine (August CTP). I realized that the virtual machine was a template and that I had not renamed the machine so a network collision with anyone else running the VM would not happen. Once I got the duplicate name on the network error, I renamed the machine. Just out of curiosity, I then attempted to connect to SQL using the Management Studio and Viola! It worked.