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...
> 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.
>|||I have try this way, it does not work.
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> 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...
> > 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.
> >
> >
>|||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...
> I have try this way, it does not work.
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > 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...
> > > 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.
> > >
> > >
> >
> >
>|||Hi:
Please read this KB article and it may be useful:
http://support.microsoft.com/default.aspx?scid=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...
> 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...
> > I have try this way, it does not work.
> > "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> > news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > > 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...
> > > > 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.
> > > >
> > > >
> > >
> > >
> >
> >
>|||I didn't catch that was what you were trying to do, See if this link helps -
http://support.microsoft.com/default.aspx?scid=kb;en-us;289573
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...
> 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...
> > 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...
> > > I have try this way, it does not work.
> > > "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> > > news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > > > 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...
> > > > > 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.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Seems like you didn't rename the machine in Windows?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...
> 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...
> > 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...
> > > I have try this way, it does not work.
> > > "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> > > news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > > > 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...
> > > > > 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.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>sql