Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NguyenL71
Posting Yak Master
228 Posts |
 Posted - 2014-02-07 : 12:54:07
|
| I just rename the computer and use the command below to rename the SQL Server but the SQL Server Service is not reflecting to the new name.Is there a way to change the SQL Server Service and agent to reflect the new name or do I have to re-install sql server.I am using SQL 2008 R2.Thank you in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-02-07 : 12:57:23
|
| The services are referring to the instance name, not the server name. So whomever installed SQL must've selected the instance name to be the same as the old server name.You can not rename the instance name. You will need to reinstall SQL if you require that.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SQL Server Service is not reflecting to the new na