Question on upgrade to SQL Server 2005

We are planning to upgrade one of the SQL Server 2000 instance on a
windows 2003 box to SQL Server 2005. I was wondering during the upgrade
will it allow me to chang the name of the existing 2000 instance to a
different name so that we can follow our naming convention.
ThanksSQL Server takes the name of the machine. So, you will have to rename the
machine, and then edit the local server name in the sysservers table.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"shub" <shubtech@.gmail.com> wrote in message
news:1153428116.503813.172530@.p79g2000cwp.googlegroups.com...
> We are planning to upgrade one of the SQL Server 2000 instance on a
> windows 2003 box to SQL Server 2005. I was wondering during the upgrade
> will it allow me to chang the name of the existing 2000 instance to a
> different name so that we can follow our naming convention.
> Thanks
>|||Yes you can rename an Instance -before the upgrade. See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
I think that renaming instances is not currently supported in SQL 2005
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"shub" <shubtech@.gmail.com> wrote in message
news:1153428116.503813.172530@.p79g2000cwp.googlegroups.com...
> We are planning to upgrade one of the SQL Server 2000 instance on a
> windows 2003 box to SQL Server 2005. I was wondering during the upgrade
> will it allow me to chang the name of the existing 2000 instance to a
> different name so that we can follow our naming convention.
> Thanks
>

Question on upgrade to SQL Server 2005

We are planning to upgrade one of the SQL Server 2000 instance on a
windows 2003 box to SQL Server 2005. I was wondering during the upgrade
will it allow me to chang the name of the existing 2000 instance to a
different name so that we can follow our naming convention.
ThanksSQL Server takes the name of the machine. So, you will have to rename the
machine, and then edit the local server name in the sysservers table.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"shub" <shubtech@.gmail.com> wrote in message
news:1153428116.503813.172530@.p79g2000cwp.googlegroups.com...
> We are planning to upgrade one of the SQL Server 2000 instance on a
> windows 2003 box to SQL Server 2005. I was wondering during the upgrade
> will it allow me to chang the name of the existing 2000 instance to a
> different name so that we can follow our naming convention.
> Thanks
>|||Yes you can rename an Instance -before the upgrade. See:
http://msdn.microsoft.com/library/d...nstall_5r8f.asp
I think that renaming instances is not currently supported in SQL 2005
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"shub" <shubtech@.gmail.com> wrote in message
news:1153428116.503813.172530@.p79g2000cwp.googlegroups.com...
> We are planning to upgrade one of the SQL Server 2000 instance on a
> windows 2003 box to SQL Server 2005. I was wondering during the upgrade
> will it allow me to chang the name of the existing 2000 instance to a
> different name so that we can follow our naming convention.
> Thanks
>