Rename Default Instance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rubens Luque Sanches Jr. - 22 Mar 2005 01:31 GMT

Hi,

I finished the installation of the SQL 2000 Server with one default instance
on a new cluster. After that my boss asked for a new name to Default
Instance ! Ohh my God !

Can I change the name of Defaul Instance ?

thanks,
Rubens

I

Reply to this Message

Tom Moreau - 22 Mar 2005 01:37 GMT

Technically, you can. However, Microsoft won't support it. Consider using
a DNS alias.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.

Reply to this Message

Andreas Mavrogenis - 24 Mar 2005 10:13 GMT

Please Read the following article
http://support.microsoft.com/default.aspx?scid=kb;en-us;307336
Regards

> Technically, you can. However, Microsoft won't support it. Consider using
> a DNS alias.
[quoted text clipped - 11 lines]
>
> I

Reply to this Message

Tom Moreau - 24 Mar 2005 13:04 GMT

Just like I said. From the KB article:

"However, renaming the SQL Server virtual, or clustered, servers is not
supported in the current version of Microsoft SQL Server. If you rename the
SQL Server Network Name resource, a variety of problems may occur. One of
the problems that may occur is that the SQL Server virtual server instance
may no longer come online. When this problem occurs, the following
information may be logged in the application event log: "

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.

Please Read the following article
http://support.microsoft.com/default.aspx?scid=kb;en-us;307336
Regards

"Tom Moreau" wrote:

> Technically, you can. However, Microsoft won't support it. Consider
> using
[quoted text clipped - 13 lines]
>
> I

Reply to this Message

Uttam Parui[MS] - 25 Mar 2005 07:35 GMT

As pointed out by Tom, renaming a SQL Server clustered virtual servername is not supported. Since this is a new installation, I would uninstall and reinstall with a new virtual servername.

Additional Information:
======================
INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?kbid=254321

Best Regards,

Uttam Parui
Microsoft Corporation

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Reply to this Message