Friday, March 23, 2012

Rename existing SQL 2K to new name

Can an existing instance of SQL 2K be renamed from "Local Machine" to
"NewName"? There is only one SQL Server 2K installed on this machine. It can
be reinstalled if necessary since there is no databases added yet. Thank you
for any help you may be able to give me.
RGPHI,
No need of reinstalling, you can use the below stored procedures to rename
SQL server.
sp_dropserver <servername>
go
sp_addserver <newservername>,local
Thanks
Hari
MCDBA
"riley" <riley3@.microtek-sales.com> wrote in message
news:O4DxZbQwDHA.2340@.TK2MSFTNGP12.phx.gbl...
> Can an existing instance of SQL 2K be renamed from "Local Machine" to
> "NewName"? There is only one SQL Server 2K installed on this machine. It
can
> be reinstalled if necessary since there is no databases added yet. Thank
you
> for any help you may be able to give me.
> RGP
>|||Thank you very much for the response. It has been very helpful.
Riley
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OHpMYfRwDHA.1740@.TK2MSFTNGP12.phx.gbl...
> HI,
> No need of reinstalling, you can use the below stored procedures to rename
> SQL server.
> sp_dropserver <servername>
> go
> sp_addserver <newservername>,local
> Thanks
> Hari
> MCDBA
> "riley" <riley3@.microtek-sales.com> wrote in message
> news:O4DxZbQwDHA.2340@.TK2MSFTNGP12.phx.gbl...
> > Can an existing instance of SQL 2K be renamed from "Local Machine" to
> > "NewName"? There is only one SQL Server 2K installed on this machine. It
> can
> > be reinstalled if necessary since there is no databases added yet. Thank
> you
> > for any help you may be able to give me.
> > RGP
> >
> >
>

No comments:

Post a Comment