Friday, March 23, 2012

Rename Default Instance

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
Technically, you can. However, Microsoft won't support it. Consider using
a DNS alias.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
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
|||Please Read the following article
http://support.microsoft.com/default...b;en-us;307336
Regards
"Tom Moreau" wrote:

> Technically, you can. However, Microsoft won't support it. Consider using
> a DNS alias.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
> news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
> 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
>
>
|||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: "
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:02537079-F255-49E1-9F19-B8CEA3C8C726@.microsoft.com...
Please Read the following article
http://support.microsoft.com/default...b;en-us;307336
Regards
"Tom Moreau" wrote:

> Technically, you can. However, Microsoft won't support it. Consider
> using
> a DNS alias.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
> news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
> 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
>
>
|||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
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

No comments:

Post a Comment