Is it possible to rename an SQL Server 2005 instance

Question

I would like to change the name of my SQL Server instance. Is there a simple way of doing this or is a significant effort required? Note, this is a named instance - not the default instance.

score 1 · Answer 1 · edited May 23 '17 at 12:13

1

The only way is a reinstall. See this similar thread for more info: SQL Server, convert a named instance to default instance?

edited May 23 '17 at 12:13

Community

1
1

answered Oct 01 '08 at 02:39

Booji Boy

4,522
4
40
45

score 1 · Answer 2 · answered Oct 01 '08 at 05:45

1

Or you could try this method: http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/544c4eaf43ddfaf3/f1bdcd1ec9cab158#f1bdcd1ec9cab158

answered Oct 01 '08 at 05:45

alexandrul

12,856
13
72
99

score 0 · Accepted Answer · answered Oct 01 '08 at 06:06

0

I have seen a few makeshift ways of doing this, but I don't have confidence in any of them. I think I will simply install a new instance and transfer my information over.

answered Oct 01 '08 at 06:06

Mario

2,229
2
21
21

score 0 · Answer 4 · answered Oct 01 '08 at 06:22

0

Renaming does't work well on the registry. Install a new isntance.

answered Oct 01 '08 at 06:22

Saif Khan

18,402
29
102
147

score 0 · Answer 5 · edited Feb 18 '23 at 15:01

0

Although there is no simple way of renaming a SQL Server instance, one can create SQL aliases.

edited Feb 18 '23 at 15:01

Glorfindel

21,988
13
81
109

answered Dec 09 '09 at 22:15

Mario

2,229
2
21
21

Is it possible to rename an SQL Server 2005 instance

5 Answers5