title: How to rename sql server 2012 instance name standalone server configuration
body: <p>I have been searching for directions and steps to rename a named server instance of SQL Server 2012. I have a rare opportunity to rename both the computer name and instance of the SQL Server. I stepped into a situation where all of the naming conventions need to be revamped. I'm assuming because I have no linked jobs or connections that I should be worried about, this will be okay. I have read that this isn't possible and others who say to use the <code>sp_dropserver</code>, <code>sp_addserver</code> but that doesn't work. Syntax would be helpful. My names are as such:</p>
  
  <pre><code>{machinename}\{instancename}
  {COLO-VSR=SQLDW}\{SQLBISERVER} 
  </code></pre>
  
  <p>I want to change it to {COLO-VSR-SQLDW}{SQLDW}</p>