How to alter server name?

Hi,
How to alter the server name after I install a SQL Server 2000. The SQL
Server name would be the computer name in default, however, I want to alter
the Server name different from computer name which the SQL Server reside in.Look up sp_dropserver and sp_addserver in BOL
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hi,
> How to alter the server name after I install a SQL Server 2000. The SQL
> Server name would be the computer name in default, however, I want to

---

alter

quote:

---

> the Server name different from computer name which the SQL Server reside

---

in.

quote:

---

>

---

|||I have try this way, it does not work.
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> д?
news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Look up sp_dropserver and sp_addserver in BOL
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> alter
> in.
>

---

|||What did you try? Can you provide the code?
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...

quote:

---

> I have try this way, it does not work.
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> д?
> news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
SQL[QUOTE]
reside[QUOTE]
>

---

|||Hi:
Please read this KB article and it may be useful:
http://support.microsoft.com/defaul...kb;en-us;303774
Best Wishes
Wei Ci Zhou|||I did as the below:
--
sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
go
--
now I restart the SQL Services, the @.@.servername change as the "new_name",
but acctually the SQL Server Name in work still is "old_name", if you try
use the "new_name" as the Server name, you can't establish a connection with
it, you can only establish a connection with the "old_name".
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...

quote:

---

> What did you try? Can you provide the code?
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> SQL
to[QUOTE]
> reside
>

---

|||I didn't catch that was what you were trying to do, See if this link helps -
http://support.microsoft.com/defaul...kb;en-us;289573
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...

quote:

---

> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection

---

with

quote:

---

> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
The[QUOTE]
> to
>

---

|||Seems like you didn't rename the machine in Windows?
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...[Q
UOTE]
> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection wi
th
> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> to
>[/QUOTE]