Is there a way to change sql server's instance name with reinstalling everything?
A:
Quick Google search yielded:
http://www.coderjournal.com/2008/02/how-to-change-instance-name-of-sql-server/
http://sqldbpool.wordpress.com/2008/09/03/how-to-change-sql-server-instance-name/
Gromer
2009-05-25 19:53:20
i tried those. but they didn't work
2009-05-25 20:06:09
Doh, that is no bueno. Good luck man!
Gromer
2009-05-25 20:07:34
None of these methods change the instance name. They change the name of the special 'local' linked server which happens to be the name returned by @@SERVERNAME. Changing the true instance name would involve changing service startup parameters, registry key, master settngs and a whole whole lot more.
Remus Rusanu
2009-05-25 23:43:05
+4
A:
You'll be much much better reinstalling everything. Specially with versions SQL 2005 and later, there are just way too many things tied to your instance name: performance counters, local groups for service start and file ACLs, service names for sql and related (agent, full text) services, sql browser visibility, service master key encryption, various full-text settings, registry keys, 'local' linked server and the list can go on for pages and pages.
Remus Rusanu
2009-05-25 22:03:50
A:
Remus Rusanu is right, those articles are misleading, they refer to changing the SQL Server config to change the name of the server upon which the SQL instance is running e.g. if the server has a name change etc. This has been pointed out to the author but for some reason he decided instead of putting his hands up, he'd argue the toss and mislead even more people!!!
Marbella Consulting
2010-09-14 13:42:14