CODEWITHSUNDEEP
sql-serversql-server-2005
Mario
Mario

Reputation: 2249

Is it possible to rename an SQL Server 2005 instance

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.

Upvotes: 6

Views: 6489

Answers (5)

Mario
Mario

Reputation: 2249

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

Upvotes: 0

Saif Khan
Saif Khan

Reputation: 18812

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

Upvotes: 0

Mario
Mario

Reputation: 2249

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.

Upvotes: 0

alexandrul
alexandrul

Reputation: 13336

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

Upvotes: 1

Booji Boy
Booji Boy

Reputation: 4582

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

Upvotes: 1

Related Questions